Search found 44 matches

by AEmpeno
2019-03-09 19:54
Forum: Advanced Customizations > Others
Topic: Adjustment Quantity
Replies: 0
Views: 99

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: 418

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: 418

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: 418

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: 418

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: 418

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: 165

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: 418

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: 165

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: 236

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: 23
Views: 1799

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: 23
Views: 1799

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: 23
Views: 1799

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: 23
Views: 1799

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: 23
Views: 1799

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: 23
Views: 1799

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: 23
Views: 1799

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: 23
Views: 1799

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: 23
Views: 1799

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 = ...
by AEmpeno
2018-09-10 18:02
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 23
Views: 1799

Re: Auto-balance field

Here is my updated ajax code. Also, my fieldname "supplylotcode" in batchesdetails table is a lookup field from receiving table. If anyone has an idea how to fix my code please let me know. Appreciate any help. <?php $currDir = dirname(__FILE__) . '/..'; include("$currDir/defaultLang.php"); include(...
by AEmpeno
2018-09-09 01:19
Forum: Advanced Customizations > Others
Topic: Auto-balance field
Replies: 23
Views: 1799

Re: Auto-balance field

I'm trying to use the code below for the attached photo. Will this work? How can I make the field name 'SupplyLotCode' as the common field for receiving table and batchesdetails table. <?php $currDir = dirname(__FILE__) . '/..'; include("$currDir/defaultLang.php"); include("$currDir/language.php"); ...
by AEmpeno
2018-09-07 21:31
Forum: Advanced Customizations > Others
Topic: Jars Total
Replies: 6
Views: 487

Re: Jars Total

So I tried this code and both total jars and total cases are showing their total sums however Im getting this: Total Jars 25.003,964.00 TotalCases 3964.00 <?php $currDir = dirname(__FILE__) . '/..'; include("$currDir/defaultLang.php"); include("$currDir/language.php"); include("$currDir/lib.php"); /...
by AEmpeno
2018-09-07 21:14
Forum: Advanced Customizations > Others
Topic: Jars Total
Replies: 6
Views: 487

Re: Jars Total

Thanks so much. It works! So if I wanted to add another column for total jars should I just add or insert this code below? $sales_TotalJars = sqlValue("select sum(Jars) from salesdetails where SalesID='{$id}'"); $TotalJars = $sales_TotalJars; sql("update sales set TotalJars='{$TotalJars}' where Sale...
by AEmpeno
2018-09-07 03:40
Forum: Advanced Customizations > Others
Topic: Jars Total
Replies: 6
Views: 487

Re: Jars Total

I need help please. Below is my ajax script code; Im having an issue to display the Total Cases, I'm only seeing 0.00. I also tested per my video course showed but I'm getting "0.00" as the total cases. Will someone please help or point me the error in my script. Thanks so much. <?php $currDir = dir...