$data = array("aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 0; $i < $count; $i++) {
/* General output */
$row[] = $aRow[$i];
if ($i == $count - 1) {
$row[] = '<input type="checkbox" name="check_' . $aRow[$hidden] . '" class="check" value="' . $aRow[$hidden] . '" />';
}
}
$data['aaData'][] = $row;
}
break;
case 'disable':
$trans_id = $_REQUEST['id'];
SaleunDone($trans_id);
DisableProduct($trans_id);
break;
default:
$error = 'Action is Null';
}
$data['error'] = $error;
echo json_encode($data);
/* ******************************
* transactions Functions
* ******************************
*/
function DisableProduct($trans_id)
{
$rResult = mysql_query("UPDATE sale_transaction\n\t\t\t\t\t\t\t SET sale_transaction.`status` = 3\n\t\t\t\t\t\t\t WHERE sale_transaction.id = {$trans_id} ");
}
DisableProduct($trans_id);
update_transact_sumprice($sum_price, $transaction_id);
SaleunDone($prod_id, $quantity);
break;
case 'count_change':
$detail_id = $_REQUEST['detail_id'];
$old_quantity = $_REQUEST['old_quantity'];
$new_quantity = $_REQUEST['new_quantity'];
$production_id = $_REQUEST['production_id'];
$cost = $_REQUEST['cost'];
$transaction_id = $_REQUEST['transaction_id'];
$corect_quantity = $old_quantity - $new_quantity;
$sum_price = $corect_quantity * $cost;
update_transact_count($new_quantity, $detail_id);
update_transact_sumprice($sum_price, $transaction_id);
SaleunDone($production_id, $corect_quantity);
break;
default:
$error = 'Action is Null';
}
$data['error'] = $error;
echo json_encode($data);
/* ******************************
* transactions Functions
* ******************************
*/
function GettransQuantity($trans_id)
{
$res = mysql_query("SELECT \tsale_transaction_detail.product_quantity\n\t\t\t\t\t\tFROM \tsale_transaction_detail\n\t\t\t\t\t\tWHERE \tsale_transaction_detail.id={$trans_id}");
$row = mysql_fetch_assoc($res);
return $row['product_quantity'];
