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