Purchase_Order_view.php

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
jnewtcomp
Posts: 27
Joined: 2019-07-25 08:05

Purchase_Order_view.php

Post by jnewtcomp » 2023-03-27 18:25

I have an error in purchase order qty update section of my database. I need help looking at my code to find the error please! :)

<?php
// For help on using hooks, please refer to https://bigprof.com/appgini/help/workin ... tion/hooks

function Purchase_Order_init(&$options, $memberInfo, &$args){

return TRUE;
}

function Purchase_Order_header($contentType, $memberInfo, &$args){
$header='';

switch($contentType){
case 'tableview':
$header='';
break;

case 'detailview':
$header='';
break;

case 'tableview+detailview':
$header='';
break;

case 'print-tableview':
$header='';
break;

case 'print-detailview':
$header='';
break;

case 'filters':
$header='';
break;
}

return $header;
}

function Purchase_Order_footer($contentType, $memberInfo, &$args){
$footer='';

switch($contentType){
case 'tableview':
$footer='';
break;

case 'detailview':
$footer='';
break;

case 'tableview+detailview':
$footer='';
break;

case 'print-tableview':
$footer='';
break;

case 'print-detailview':
$footer='';
break;

case 'filters':
$footer='';
break;
}

return $footer;
}

function Purchase_Order_before_insert(&$data, $memberInfo, &$args){

return TRUE;
}

function Purchase_Order_after_insert($data, $memberInfo, &$args){
sqlvalue("UPDATE Inventory i set i.Stock_QTY = i.Stock_QTY + {$data['Qty_Received']} where i.InventoryID={$data['Part_Number']}");

return TRUE;

}

function Purchase_Order_before_update(&$data, $memberInfo, &$args){

$new_value=sqlvalue("SELECT ({$data['Qty_Received']} - Qty_Received) as qty from Purchase_Order where Purchase_OrderID = {$data['selectedID']} ");
if ($new_value <> 0) {
sqlvalue("UPDATE Inventory i set i.Stock_QTY = i.Stock_QTY + {$new_value} where i.InventoryID={$data['Part_Number']}"); }

return TRUE;
}


function Purchase_Order_after_update($data, $memberInfo, &$args){

return TRUE;
}

function Purchase_Order_before_delete($selectedID, &$skipChecks, $memberInfo, &$args){

return TRUE;
}

function Purchase_Order_after_delete($selectedID, $memberInfo, &$args){

}

function Purchase_Order_dv($selectedID, $memberInfo, &$html, &$args){

}

function Purchase_Order_csv($query, $memberInfo, &$args){

return $query;
}
function Purchase_Order_batch_actions(&$args){

return array();
}

jnewtcomp
Posts: 27
Joined: 2019-07-25 08:05

Re: Purchase_Order_view.php

Post by jnewtcomp » 2023-03-27 18:37

UPDATE Inventory i set i.Stock_QTY = i.Stock_QTY + where i.InventoryID=191
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where i.InventoryID=191' at line 1

Post Reply