Exemplo n.º 1
0
Arquivo: stock.php Projeto: kxr/stock3
				<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">
	<form method="post" action="<?php 
Exemplo n.º 2
0
    $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();
Exemplo n.º 3
0
if (!isset($_GET['iid'])) {
    die("_GET[iid] not found");
}
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());
}
// ItemID from GET
$current_itemid = $_GET['iid'];
$current_iteminfo = get_item_info($current_itemid, $dbhi);
$current_itemname = $current_iteminfo['name'];
$current_itemsaleprice = $current_iteminfo['sale_price'];
$current_itemdetail = $current_iteminfo['detail'];
$current_stockinfo = get_stock_info($current_itemid, $dbhi);
$current_totalsale = $current_stockinfo['total_sale'];
$current_totalpurchase = $current_stockinfo['total_purchase'];
// If addform is posted, insert values in database
if (!empty($_POST['t_date_val']) && (!empty($_POST['tinvoiceno']) || $_POST['trans_t'] == 'Purchase') && $_POST['tuprice'] > 0 && $_POST['tqty'] > 0) {
    echo 'hellooo';
    if ($_POST['trans_t'] == 'Sale') {
        $sql_q = "INSERT INTO sale_transactions\n\t\t\t\t\t\t\t\t( sale_trans_id, date, item_id, invoice_no, uprice, qty, amount_received, comments, timestamp )\n\t\t\t\t\t\tVALUES  (\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'" . $_POST['t_date_val'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['iid'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tinvoiceno'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tuprice'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tqty'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tuprice'] * $_POST['tqty'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tcomments'] . "',\n\t\t\t\t\t\t\t\t'" . time() . "'\n\t\t\t\t\t\t\t\t);\n\t\t\t\t\t\t";
    } elseif ($_POST['trans_t'] == 'Purchase') {
        $sql_q = "INSERT INTO purchase_transactions\n\t\t\t\t\t\t\t\t( p_trans_id, date, item_id, vendor_id, invoice_id, uprice, qty, comments, timestamp )\n\t\t\t\t\t\tVALUES\t(\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'" . $_POST['t_date_val'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['iid'] . "',\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'" . $_POST['tuprice'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tqty'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tcomments'] . "',\n\t\t\t\t\t\t\t\t'" . time() . "'\n\t\t\t\t\t\t\t\t);\n\t\t\t\t\t\t";
    }
    $dbhi->query($sql_q) or die($dbhi->error);
    if ($dbhi->affected_rows == 1) {
        header("Location: " . $_SERVER['PHP_SELF'] . "?iid=" . $_POST['iid'] . "&submit_success=yes&message=" . $_POST['trans_t'] . " Added");
    } else {
        header("Location: " . $_SERVER['PHP_SELF'] . "?iid=" . $_POST['iid'] . "&submit_success=no&message=MYSQL_ERR_NOTONERET");