Search found 49 matches

by AEmpeno
2019-04-04 18:25
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Hello, You mentioned from previous conversation that "if you want to get calculation once the data changes, it would be best to handle this via the after-insert, after-update, after-delete functions in the respective hooks." Will you please guide me on this? It's been a year since I started this pro...
by AEmpeno
2019-03-31 14:27
Forum: Advanced Customizations > Others
Topic: Child Tables Slow Loading
Replies: 4
Views: 189

Re: Child Tables Slow Loading

thanks pböttcher.

i went back to your first suggestion to check my SQL statement. for now, its working fine, hopefully, this fixed the problem permanently.
by AEmpeno
2019-03-29 22:39
Forum: Advanced Customizations > Others
Topic: Child Tables Slow Loading
Replies: 4
Views: 189

Re: Child Tables Slow Loading

Thanks pböttcher for the quick response.

I did check my ajax-batches-balance.php and it seems all is good nothing changed. I also, checked and tested the site locally (localhost) everything is working fine.
by AEmpeno
2019-03-29 21:01
Forum: Advanced Customizations > Others
Topic: Child Tables Slow Loading
Replies: 4
Views: 189

Child Tables Slow Loading

Hello, Lately, I've been having this issue: Console >Error jquery-1.12.4.min.js:4 POST https://jfoodstwo.com/hooks/ajax-batches-balance.php 500 send @ jquery-1.12.4.min.js:4 ajax @ jquery-1.12.4.min.js:4 n.fn.load @ jquery-1.12.4.min.js:4 update_batches @ batches-dv.js:31 (anonymous) @ batches-dv.js...
by AEmpeno
2019-03-29 02:26
Forum: Bugs/annoyances
Topic: Child Table loading problem
Replies: 5
Views: 962

Re: Child Table loading problem

Were you able to find the solution for this issue?

I'm experiencing this issue right now. Any direction here, please?
by AEmpeno
2019-03-09 19:54
Forum: Advanced Customizations > Others
Topic: Adjustment Quantity
Replies: 0
Views: 169

Adjustment Quantity

Hello, I would like to ask for help with my code. CODE: SELECT ALL //Adjustments Batches // $AdjustedQty = sqlValue("SELECT QtyJars FROM adjustments1 where BatchesID='{$id}'"); $positive_codes = "'Found-New'"; $OnHandJars = sqlValue("SELECT OnHandJars from batches where BatchesID='{$id}'"); $reason_...
by AEmpeno
2019-02-05 03:20
Forum: Advanced Customizations > Others
Topic: Font Color changes when value changes
Replies: 11
Views: 673

Re: Font Color changes when value changes

Hello, Here is my take.I tested first my sql statement on my phpmyadmin and its working fine. I then inserted the whole statement to hooks/batches.php /* Font color changes */ $old_options = $options->QueryFieldsTV; foreach($old_options as $field => $caption){ if ($field == '`batches`.`SoldJars`') {...
by AEmpeno
2019-02-01 16:41
Forum: Advanced Customizations > Others
Topic: Font Color changes when value changes
Replies: 11
Views: 673

Re: Font Color changes when value changes

Thanks Jan! I appreciate all the help though. So I was following your code and instruction,however, I'm still confused where should I insert these set of codes. Also what do mean by this Follow this tutorial to change the display value: https://bigprof.com/appgini/tips-and-tu ... sing-hooks 1. <div ...
by AEmpeno
2019-02-01 01:39
Forum: Advanced Customizations > Others
Topic: Font Color changes when value changes
Replies: 11
Views: 673

Re: Font Color changes when value changes

Attached is a screenshot of my batches table in table view. What I'm trying to do accomplish here is to change the font color or change the cell color if "SoldJars" become 5% left of "ProductionJars" So every time "SoldJars" dropped by less than or equal to 5% the color of the font color changes. Th...
by AEmpeno
2019-01-26 17:37
Forum: Advanced Customizations > Others
Topic: Font Color changes when value changes
Replies: 11
Views: 673

Re: Font Color changes when value changes

Thanks for the info and the code, Jan!

I will try this option though. Will you guide me where should I add this code?
by AEmpeno
2019-01-26 14:23
Forum: Advanced Customizations > Others
Topic: Font Color changes when value changes
Replies: 11
Views: 673

Re: Font Color changes when value changes

Yes I would like to see the font change color both in table view and detail view if possible. This will help me or any users be alerted of the balances in the inventory.
by AEmpeno
2019-01-26 03:46
Forum: Bugs/annoyances
Topic: Not Found Error message
Replies: 2
Views: 232

Re: Not Found Error message

Thanks for the answer.
by AEmpeno
2019-01-26 03:45
Forum: Advanced Customizations > Others
Topic: Font Color changes when value changes
Replies: 11
Views: 673

Font Color changes when value changes

Hello, I have fields named receiving.amountrecieved, batchesdetails.quantityused, receiving.balance. What I would like to happen is the color of the font in receiving.balance will change to red when the value is less than or equal 5%. <?php $currDir = dirname(__FILE__) . '/..'; include("$currDir/def...
by AEmpeno
2019-01-04 18:24
Forum: Bugs/annoyances
Topic: Not Found Error message
Replies: 2
Views: 232

Not Found Error message

Error message: Not Found The requested URL /SOP_FSS_2.016_Handling_Regulatory_Inspections_Procedures.doc was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache Server at jfoodsone.com Port 443 This error me...
by AEmpeno
2018-09-25 14:54
Forum: Advanced Customizations > Others
Topic: Table doesn't exist
Replies: 1
Views: 299

Table doesn't exist

Hello, I uploaded my appgini application on the web however I get this error message "Table 'jfoodstw_db1.Receiving' doesn't exist Query: update Receiving set Balance='4877' where ReceivingID='1' The above info is displayed because you are currently signed in as the super admin. Other users won't se...
by AEmpeno
2018-09-18 18:34
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Hi pböttcher, For some reason, it disappears. But here are my unfinished codes - ajax-batches-balance.php and batches-dv.js. Im trying to get the OnHoldJars and OnHoldCases but no success especially for the OnHold Jars? <?php $currDir = dirname(__FILE__) . '/..'; include("$currDir/defaultLang.php");...
by AEmpeno
2018-09-18 15:31
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Hello, I've been getting a warning message where I have my calculated field. Does anyone know why I'm getting this warning message? This happens when I added two more calculated fields on the same table. Warning: Use of undefined constant label_jars - assumed 'label_jars' (this will throw an Error i...
by AEmpeno
2018-09-14 18:55
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Hello, Thanks pböttcher! The calculation is showing now on the field, however if i do changes on "QuantityUsed" and save it. The "balance" field does not change unless if I open another browser and type localhost/inventory/hooks/ajax-receiving-balance.php?id=128 (it gives me the right amount) then I...
by AEmpeno
2018-09-13 15:45
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Attached is my appgini table structure - receiving, batches, batchesdetails.
by AEmpeno
2018-09-13 15:33
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Hello,

I inserted your suggested code, saved it, and refreshed the page but balance still shows "0.00"

Did I miss something?
by AEmpeno
2018-09-12 19:12
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Sorry it was a typo error. It should be +SupplyLotCode (lookup field - receiving table) I created receiving-dv.js and inserted the code below. /* update balance total automatically every 5 seconds */ if($j('[name=SelectedID]').val().length) setInterval(update_Balance, 5000); /* load balance total on...
by AEmpeno
2018-09-12 14:52
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Hello, Here is my table structure Receiving table fields: +id +date +SupplierName(Lookup field - supplier table) +SupplyName (lookup field - supplies table) +SupplyLotCode +AmountReceived +UoM +Storage +Balance (need calculated field) Batches table fields: +id +ManuDate +ExpDate +ProductName (lookup...
by AEmpeno
2018-09-12 13:46
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Hello, Thank you for your reply. I added your code yet there's no changes on my balance. I'm still getting "0.00". Here is my new code: $SupplyLotCode = intval($_REQUEST['SupplyLotCode']); $ID = intval($_REQUEST['id']); if(!$SupplyLotCode) exit; $QuantityUsed = sqlValue("SELECT sum(QuantityUsed) FRO...
by AEmpeno
2018-09-11 19:08
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 24
Views: 2329

Re: Auto-balance field

Thanks you. The only problem I'm having right now is the balance still shows "0.00" I did add the "supplylotcode" lately to try new fieldname so it will be easy to remember and to make the name same as in receiving table. Below is my new script. I'm still getting "0.00" as balance. <?php $currDir = ...