function get_purchase_invoice_total($p_inv_id, $dbhi) { if (!isset($dbhi)) { global $mysql_host, $mysql_user, $mysql_pass, $mysql_database; $dbhi = new mysqli($mysql_host, $mysql_user, $mysql_pass, $mysql_database); } $mysql_q = "\tSELECT SUM(uprice*qty) AS p_inv_total\n\t\t\t\t\tFROM purchase_transactions\n\t\t\t\t\tWHERE invoice_id = {$p_inv_id}\n\t\t"; $query_res = $dbhi->query($mysql_q) or die($dbhi->error); $row = $query_res->fetch_assoc(); return clean_num($row['p_inv_total']); }
<tbody> <?php // Select Qurey to print the content $res_table = mysql_query('SELECT sale_id, stock_sale.item_id, date, item_name, sale_type, invoice_no, uprice, qty, comments from stock_sale LEFT JOIN stock_items ON stock_sale.item_id=stock_items.item_id;'); while ($row = mysql_fetch_array($res_table)) { echo '<tr>'; echo '<td>' . $row['sale_id'] . '</td>'; echo '<td>' . $row['date'] . '</td>'; //echo '<td>'.$row['item_name'].'</td>'; echo '<td><a href="item_detail.php?iid=' . $row['item_id'] . '&p=a">' . $row['item_name'] . '</a></td>'; echo '<td>' . $row['sale_type'] . '</td>'; echo '<td>' . $row['invoice_no'] . '</td>'; echo '<td>' . clean_num($row['uprice']) . ' ' . $currency . '</td>'; echo '<td>' . clean_num($row['qty']) . '</td>'; echo '<td>' . clean_num($row['uprice'] * $row['qty']) . '</td>'; echo '<td><pre>' . $row['comments'] . '</pre></td>'; echo '</tr>'; } ?> </tbody> </table> <div id="popupForm"> <table width=100% cellspacing="5"> <form name="addform" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <tr> <td colspan="2" align="center" valign="center"><h2>Add Sale</h2></td>
<th></th> </tr> </thead> <tbody> <?php // Select Qurey to print the content $res_table = mysql_query('SELECT hold_id, stock_hold.item_id, date, item_name, hold_type, qty, comments from stock_hold LEFT JOIN stock_items ON stock_hold.item_id=stock_items.item_id' . $mysql_condition); while ($row = mysql_fetch_array($res_table)) { echo '<tr>'; echo '<td>' . $row['hold_id'] . '</td>'; echo '<td>' . $row['date'] . '</td>'; //echo '<td>'.$row['item_name'].'</td>'; echo '<td><a href="item_detail.php?iid=' . $row['item_id'] . '&p=a">' . $row['item_name'] . '</a></td>'; echo '<td>' . $row['hold_type'] . '</td>'; echo '<td>' . clean_num($row['qty']) . '</td>'; echo '<td><pre>' . $row['comments'] . '</pre></td>'; echo '<td><a href="' . $_SERVER['PHP_SELF'] . '?delete=' . $row['hold_id'] . '"><img src="imgs/del.png" width="15" height="15"></img></a></td>'; echo '</tr>'; } ?> </tbody> </table> <div id="popupForm"> <table width=100% cellspacing="5"> <form name="addform" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <tr>
$first = 1; foreach ($terms as $term) { if ($first == 1) { $mysql_q = $mysql_q . " WHERE ( item_name LIKE '%{$term}%'"; } else { $mysql_q = $mysql_q . " AND item_name LIKE '%{$term}%'"; } $first = 0; } $mysql_q = $mysql_q . ")"; // $first=1; // foreach ($terms as $term) { // if ( $first == 1) // $mysql_q = $mysql_q." OR ( group_name LIKE '%$term%'"; // else // $mysql_q = $mysql_q." AND group_name LIKE '%$term%'"; // $first=0; // } // $mysql_q = $mysql_q.")"; } $q_result = $dbhi->query($mysql_q); if ($q_result->num_rows > 0) { while ($row = $q_result->fetch_assoc()) { $costprice = get_costprice($row['item_id'], $dbhi); $stock_info = get_stock_info($row['item_id'], $dbhi); $stock_num = $stock_info['total_purchase'] - $stock_info['total_sale'] - $stock_info['total_credit']; $data[] = array('label' => "<a>" . "#" . $row['item_id'] . " " . $row['item_name'] . "<span style='font-size:0.9em'>" . " (" . price2code($costprice) . "|" . clean_num($stock_num) . ")" . "</span>" . "<div style='font-size:0.8em'>" . $row['item_detail'] . "</div>" . "</a>", 'group' => $row['group_name'], 'detail' => $row['item_detail'], 'value' => $row['item_name'], 'id' => $row['item_id'], 'saleprice' => clean_num($row['item_saleprice']), 'costprice' => $costprice); } } echo json_encode($data); flush();
</form> </thead> <tbody> <?php $mysql_q = "\n\t\t\t\t\t\t\t\tSELECT p_trans_id, date, item_id, vendor_id, invoice_id, uprice, qty, comments, timestamp\n\t\t\t\t\t\t\t\tFROM purchase_transactions\n\t\t\t\t\t\t\t\tORDER BY p_trans_id DESC\n\t\t\t\t\t\t\t\t"; $query_res = $dbhi->query($mysql_q); while ($row = $query_res->fetch_assoc()) { $item_info = get_item_info($row['item_id'], $dbhi); $row_style = 'style="color:#d00000"'; if (!empty($row['invoice_id'])) { $inv_no = get_vendor_invoice($row['invoice_id'], $dbhi); $invoice_html = "\t<a name='a_invid[]' href='javascript:;'>\n\t\t\t\t\t\t\t\t\t\t\t\t{$inv_no}\n\t\t\t\t\t\t\t\t\t\t\t\t<input type='hidden' name='val_invid[]' value='" . $row['invoice_id'] . "' />\n\t\t\t\t\t\t\t\t\t\t\t</a>"; } else { $invoice_html = "N/A"; } echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . $row['date'] . "</td>\n\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<a href='transactions.php?iid=" . $row['item_id'] . "'>\n\t\t\t\t\t\t\t\t\t\t" . $item_info['name'] . "\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<a href='vendors.php?vendorid=" . $row['vendor_id'] . "'>\n\t\t\t\t\t\t\t\t\t\t" . get_vendorname($row['vendor_id'], $dbhi) . "\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>{$invoice_html}</td>\n\t\t\t\t\t\t\t\t<td {$row_style} title='" . clean_num($row['uprice']) . "'>" . price2code(clean_num($row['uprice'])) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . clean_num($row['qty']) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style} title='" . clean_num($row['uprice'] * $row['qty']) . "'>" . price2code(clean_num($row['uprice'] * $row['qty'])) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<pre style='display:inline;'>" . $row['comments'] . "</pre>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t"; } ?> </tbody> </table> </center> <div id="v_inv_div"></div> </body>
<th>Item Name</th> <th>Code</th> <th>Stock</th> <th>Sale Price</th> </tr> </thead> <tbody id="tbodyid"> <?php $mysql_q = "SELECT item_id, item_name, item_detail, item_saleprice\n\t\t\t\t\t\t\tFROM items\n\t\t\t\t\t\t\tORDER BY item_id DESC"; $query_res = $dbhi->query($mysql_q) or die($dbhi->error); while ($row = $query_res->fetch_assoc()) { $i_id = $row['item_id']; $i_name = $row['item_name']; $i_detail = $row['item_detail']; $i_saleprice = clean_num($row['item_saleprice']); $stock_info = get_stock_info($i_id, $dbhi); $i_costprice = get_costprice($i_id, $dbhi); $i_costcode = price2code($i_costprice); $i_stocknumber = $stock_info['total_purchase'] - $stock_info['total_sale']; echo "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t#<div style='display: inline' name='iid_editable[]'>{$i_id}</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<b><a name='i_link[]' href='transactions.php?iid={$i_id}'>\n\t\t\t\t\t\t\t\t<div name='inm_disp[]'>{$i_name}</div>\n\t\t\t\t\t\t\t\t<input style='display: none' name='inm_editable[]' value='{$i_name}'/>\n\t\t\t\t\t\t\t\t<input type='hidden' name='link_space[]' value='transactions.php?iid={$i_id}'/>\n\t\t\t\t\t\t\t</a></b>\n\t\t\t\t\t\t\t<div style='font-size:0.9em'>{$i_detail}</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td title='{$i_costprice}'>\n\t\t\t\t\t\t\t{$i_costcode}\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td title='" . $stock_info['total_purchase'] . "|" . $stock_info['total_sale'] . "|" . $stock_info['total_credit'] . "'>\n\t\t\t\t\t\t\t{$i_stocknumber}\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t{$Currency}\n\t\t\t\t\t\t\t<div style='display: inline' id='editable_{$i_id}'>{$i_saleprice}</div>\n\t\t\t\t\t\t\t<input style='display: none' id='editbox_{$i_id}' size='4' value='{$i_saleprice}' type='text' />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t"; } ?> </tbody> </table> </center> <!-- <div id="div_add_g" title="Add Group">
<tbody> <form name="inv_pay_form" method="post" action="<?php echo $_SERVER['PHP_SELF'] . "?vendorid={$vendorID}"; ?> "> <?php $mysql_q = "\tSELECT p_invoice_id, date, vendor_invoice_no, invoice_note, invoice_total, payment_id\n\t\t\t\t\t\t\tFROM purchase_invoices\n\t\t\t\t\t\t\tWHERE vendor_id='{$vendorID}'\n\t\t\t\t\t\t\tORDER BY p_invoice_id DESC\n\t\t\t\t"; $query_res = $dbhi->query($mysql_q) or die($dbhi->error); while ($row = $query_res->fetch_assoc()) { //If Invoice total and calculated total don't match, mention it $p_calc_inv_total = get_purchase_invoice_total($row['p_invoice_id'], $dbhi); if ($p_calc_inv_total != $row['invoice_total']) { $mention_calc_total = "({$p_calc_inv_total})"; } echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t" . $row['date'] . "\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t<a name='a_veninv[]' href='javascript:;'>" . $row['vendor_invoice_no'] . "\n\t\t\t\t\t\t\t\t\t<input type='hidden' name='val_invid[]' value='" . $row['p_invoice_id'] . "' />\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t{$Currency} " . clean_num($row['invoice_total']) . "{$mention_calc_total}\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t"; //If payed get payment else display check box if ($row['payment_id'] > 0) { $m_q = "\tSELECT payment_type, ref_no\n\t\t\t\t\t\t\t\tFROM payment_out\n\t\t\t\t\t\t\t\tWHERE payment_id=" . $row['payment_id']; $q_r = $dbhi->query($m_q) or die($dbhi->error); $rw = $q_r->fetch_assoc(); echo "\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t<a name='a_payment[]' href='javascript:;'>\n\t\t\t\t\t\t\t\t\t" . $rw['payment_type'] . "# " . $rw['ref_no'] . "\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t"; } else { echo "\n\t\t\t\t\t\t\t\t<td align='center'>\n\t\t\t\t\t\t\t\t\t<input type='checkbox' value='" . $row['p_invoice_id'] . "' name='invpay_check[]' />\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t"; } } ?> </form> </tbody>
$item_hold = 0; while ($row = mysql_fetch_array($res_table)) { if ($row['transaction'] == 'Purchase') { $row_style = 'style="color:#d00000"'; } else { $row_style = ''; } echo '<tr>'; //echo '<td '.$row_style.'>'.$row['trans_id'].'</td>'; echo '<td ' . $row_style . '>' . $row['date'] . '</td>'; echo '<td ' . $row_style . '>' . $row['transaction'] . '</td>'; echo '<td ' . $row_style . '>' . $row['trans_type'] . '</td>'; echo '<td ' . $row_style . '>' . $row['invoice_no'] . '</td>'; echo '<td ' . $row_style . ' title="' . clean_num($row['uprice']) . '">' . price2code(clean_num($row['uprice']), $price_code) . '</td>'; echo '<td ' . $row_style . '>' . clean_num($row['qty']) . '</td>'; echo '<td ' . $row_style . ' title="' . clean_num($row['uprice'] * $row['qty']) . '">' . price2code(clean_num($row['uprice'] * $row['qty']), $price_code) . '</td>'; echo '<td ' . $row_style . '><table style="padding:0px; margin:0px" width="100%" border="0"><tr><td style="border-bottom:0px; padding:0px;"><pre style="display:inline;">' . $row['comments'] . '</pre></td>'; //if the entery is fresh, or hold type then show the delete button $curr_ts = time(); $ts_diff = $curr_ts - $row['timestamp']; if ($ts_diff < 180 || $row['transaction'] == "Hold") { echo '<td style="border-bottom:0px; padding:0px;" align="right"><form style="display:inline" id="delform" name="delform" method="post" action="' . $_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING'] . '">'; echo '<input type="hidden" name="del_tid" value="' . $row['trans_id'] . '" />'; echo '<button style="margin:0;padding:0;" type=submit><img id="delbutton" height=8 width=8 src="imgs/del.png"></img></button>'; echo '</form></td></tr></table></td>'; } else { echo '</tr></table></td>'; } echo '</tr>'; if ($row['transaction'] == "Purchase") { $item_purchase += $row['qty'];
echo '<td><a href="javascript:;" class="Tooltip">' . $lpr_arr['date']; echo '<span>'; echo '<table id="TooltipTable">'; echo '<tr><td>ID</td><td>Date</td><td>Type</td><td>Inv #</td><td>Qty</td><td>Unit Price</td><td>Comments</td></tr>'; echo '<tr><td>' . $lpr_arr['pur_id'] . '</td><td>' . $lpr_arr['date'] . '</td><td>' . $lpr_arr['pur_type'] . '</td><td>' . $lpr_arr['invoice_no'] . '</td><td>' . clean_num($lpr_arr['qty']) . '</td><td>' . price2code(clean_num($lpr_arr['uprice'])) . '</td><td>' . $lpr_arr['comments'] . '</td></tr>'; echo '</table>'; echo '</span>'; echo '</a></td>'; //last sale $lsl_res = mysql_query("select * from stock_sale where item_id=\"{$_ii}\" ORDER BY date DESC LIMIT 1;"); $lsl_arr = mysql_fetch_array($lsl_res); echo '<td><a href="javascript:;" class="Tooltip">' . $lsl_arr['date']; echo '<span>'; echo '<table id="TooltipTable">'; echo '<tr><td>ID</td><td>Date</td><td>Type</td><td>Inv #</td><td>Qty</td><td>Unit Price</td><td>Comments</td></tr>'; echo '<tr><td>' . $lsl_arr['sale_id'] . '</td><td>' . $lsl_arr['date'] . '</td><td>' . $lsl_arr['sale_type'] . '</td><td>' . $lsl_arr['invoice_no'] . '</td><td>' . clean_num($lsl_arr['qty']) . '</td><td>' . price2code(clean_num($lsl_arr['uprice'])) . '</td><td>' . $lsl_arr['comments'] . '</td></tr>'; echo '</table>'; echo '</span>'; echo '</a></td>'; echo '</tr></tr></tr></tr></tr></tr></tr></tr></tbody>'; } } ?> </table> <div id="popupForm"> <table width=100% cellspacing="5"> <form method="post" action="<?php echo $_SERVER['PHP_SELF'];
<td align="right"> <b> Grand Total: <?php echo "{$Currency} " . clean_num($grand_total); ?> </b> <?php if ($operation == 'view' && $type == 'sale') { echo '<br>'; echo 'Amount Received:'; echo "{$Currency} " . clean_num($invoice_row['amount_received']); } elseif ($type == 'purchase' && $grand_total != $invoice_row['invoice_total']) { echo '<br>'; echo 'Invoice Total:'; echo "{$Currency} " . clean_num($invoice_row['invoice_total']); } ?> </td> </tr> <?php if ($type == 'sale') { echo ' <tr> <td colspan="2" style="font-size:0.8em;"> Note: ' . $Company_SalePolicy . ' </td> <tr> '; } ?>
<div id="s_table_container"> <table class="blue_table_tight" border=1> <tr> <th> Inv# </th> <th> Total </th> </tr> <?php $mysql_q = "SELECT * FROM credit_invoices\n\t\t\t\t\t\t\t\tWHERE client_id='" . $_GET['cid'] . "'"; //: WHERE date='".date('Y-m-d')."'"; $query_res = $dbhi->query($mysql_q); while ($row = $query_res->fetch_assoc()) { echo "\n\t\t\t\t\t<tr id='tr_inv_" . $row['sale_invoice_id'] . "'>\n\t\t\t\t\t\t<td title='" . $row['invoice_title'] . "'>\n\t\t\t\t\t\t\t" . $row['sale_invoice_id'] . "\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t{$Currency} " . clean_num($row['amount_received']) . "\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t</tr>\n\t\t\t\t\t"; } ?> </table> <div id="v_inv_div"></div> </body> </html>
<?php $mysql_q = "\n\t\t\t\t\t\t\t\tSELECT sale_trans_id, date, item_id, invoice_no, uprice, qty, amount_received, comments, timestamp\n\t\t\t\t\t\t\t\tFROM sale_transactions\n\t\t\t\t\t\t\t\tORDER BY sale_trans_id DESC\n\t\t\t\t\t\t\t\t"; $query_res = $dbhi->query($mysql_q) or die($dbhi->error); while ($row = $query_res->fetch_assoc()) { $item_info = get_item_info($row['item_id'], $dbhi); $row_style = ''; //if amount received is diff than total (uprice*qty), then show it $am_rec = ""; if (clean_num($row['uprice'] * $row['qty']) != clean_num($row['amount_received'])) { $am_rec = "(" . clean_num($row['amount_received']) . ")"; } //if invoice is KTSS* then provide link to the invoice if (substr($row['invoice_no'], 0, 4) === 'KTSS') { $invid = substr($row['invoice_no'], 4); $invoice_html = "<a name='a_invid' href='javascript:;'>{$invid}</a>"; } else { $invoice_html = $row['invoice_no']; } echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . $row['date'] . "</td>\n\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<a href='transactions.php?iid=" . $row['item_id'] . "'>\n\t\t\t\t\t\t\t\t\t\t" . $item_info['name'] . "\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . $invoice_html . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . clean_num($row['uprice']) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . clean_num($row['qty']) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . clean_num($row['uprice'] * $row['qty']) . $am_rec . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<pre style='display:inline;'>" . $row['comments'] . "</pre>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t"; } ?> </tbody> </table> </center> <div id="v_inv_div"></div> </body>
<?php $mysql_q = "\n\t\t\t\t\t\t\t\t(\tSELECT 'Sale' as SPCH, date, invoice_no as inv, uprice, qty, amount_received, comments, timestamp\n\t\t\t\t\t\t\t\t\tFROM sale_transactions\n\t\t\t\t\t\t\t\t\tWHERE item_id = {$current_itemid}\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\tUNION\n\t\t\t\t\t\t\t\t(\tSELECT 'Purchase' as SPCH, date, invoice_id as inv, uprice, qty, null, comments, timestamp\n\t\t\t\t\t\t\t\t\tFROM purchase_transactions\n\t\t\t\t\t\t\t\t\tWHERE item_id = {$current_itemid}\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\tORDER BY date DESC, timestamp DESC\n\t\t\t\t\t\t\t\t"; $query_res = $dbhi->query($mysql_q); while ($row = $query_res->fetch_assoc()) { if ($row['SPCH'] == 'Purchase') { $row_style = 'style="color:#d00000"'; } else { $row_style = ''; } //Display Invoice link if purchase or (sale & KTSS) if ($row['SPCH'] == 'Purchase' && $row['inv'] > 0) { $inv_td_html = '<a name="p_invid_link" href="javascript:;">' . $row['inv'] . '</a>'; } elseif ($row['SPCH'] == 'Sale' && substr($row['inv'], 0, 4) === 'KTSS') { $inv_td_html = '<a name="s_invid_link" href="javascript:;">' . substr($row['inv'], 4) . '</a>'; } else { $inv_td_html = $row['inv']; } echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . $row['date'] . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . $row['SPCH'] . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>{$inv_td_html}</td>\n\t\t\t\t\t\t\t\t<td {$row_style} title='" . clean_num($row['uprice']) . "'>" . price2code(clean_num($row['uprice'])) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . clean_num($row['qty']) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style} title='" . clean_num($row['uprice'] * $row['qty']) . "'>" . price2code(clean_num($row['uprice'] * $row['qty'])) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<pre style='display:inline;'>" . $row['comments'] . "</pre>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t"; } ?> </tbody> </table> </center> <div id="v_inv_div"></div> </body>
<?php if (!$_POST['iid'] > 0) { die('ERROR: Bad call. Shouldnt be called directly'); } include_once 'config.php'; // MYSQL Connection and Database Selection $dbhi = new mysqli($mysql_host, $mysql_user, $mysql_pass, $mysql_database); if (mysqli_connect_errno()) { die('Could not connect to mysql: ' . mysqli_connect_errno()); } if ($_POST['iid'] > 0 && $_POST['isp'] > 0) { $new_saleprice = clean_num($_POST['isp']); $i_id = $_POST['iid']; $mysql_q = "UPDATE items\n\t\t\t\t\t\tSET item_saleprice = '{$new_saleprice}'\n\t\t\t\t\t\tWHERE item_id = '{$i_id}'"; $dbhi->query($mysql_q) or die($dbhi->error); echo 'UPDATED: Item SalePrice'; } elseif ($_POST['iid'] > 0 && !empty($_POST['inm'])) { $new_name = clean_num($_POST['inm']); $i_id = $_POST['iid']; $mysql_q = "UPDATE items\n\t\t\t\t\t\t\tSET item_name = '{$new_name}'\n\t\t\t\t\t\t\tWHERE item_id = '{$i_id}'"; $dbhi->query($mysql_q) or die($dbhi->error); echo 'UPDATED: Item Name'; }
</tr> </tfoot> </table> </form> <div id="s_table_container"> <table id="inv_table" class="blue_table_tight" border=1> <tr> <th>Date</th> <th>Inv#</th> <th>Total</th> </tr> <?php $mysql_q = "SELECT * FROM sale_invoices"; //: WHERE date='".date('Y-m-d')."'"; $query_res = $dbhi->query($mysql_q); while ($row = $query_res->fetch_assoc()) { echo "\n\t\t\t\t\t<tr name='inv_disp_row[]'>\n\t\t\t\t\t\t<td>" . $row['date'] . "</td>\n\t\t\t\t\t\t<td name='inv_disp_id[]' title='" . $row['invoice_title'] . "'>\n\t\t\t\t\t\t\t" . $row['sale_invoice_id'] . "\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t{$Currency} " . clean_num($row['amount_received']) . "\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t</tr>\n\t\t\t\t\t"; } ?> </table> <div id="v_inv_div"></div> </body> </html>