$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();
<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"> <form method="post" action="<?php echo $_SERVER['PHP_SELF'];