$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'];