<?php session_start(); //include_once './inc/page.inc.php'; include_once './inc/init.php'; if ($_POST['id'] != '') { $sql = "update main set no='{$_POST['no']}',itemname='{$_POST['itemname']}',price='{$_POST['price']}',qty='{$_POST['qty']}',disc='{$_POST['disc']}',lineamt='{$_POST['lineamt']}',tax='{$_POST['tax']}',r='{$_POST['r']}',customize='{$_POST['customize']}',totalqty='{$_POST['totalqty']}',grossamt='{$_POST['grossamt']}',normal='{$_POST['normal']}',discount='{$_POST['discount']}',addin='{$_POST['addin']}',netamount='{$_POST['netamount']}',importer='{$_POST['importer']}',salesman='{$_POST['salesman']}',customer='{$_POST['customer']}',name='{$_POST['name']}',class='{$_POST['class']}',`delete`='{$_POST['delete']}',single='{$_POST['single']}',b='{$_POST['b']}',c='{$_POST['c']}',customeerno='{$_POST['customeerno']}',hold='{$_POST['hold']}',rethold='{$_POST['rethold']}',reprint='{$_POST['reprint']}',remark='{$_POST['remark']}',function='{$_POST['function']}',payment='{$_POST['payment']}',`exit`='{$_POST['exit']}' where id='{$_POST['id']}'"; m_query($sql); echo "successful"; } $sql = "select * from main"; $result = s_fetch($sql); $smarty->assign('rows', $result); $smarty->display("menumain.htm"); ?>
<?php session_start(); include_once './inc/init.php'; require 'inc/ajax_order_page.inc.php'; $id = $_GET['id']; $no = $_GET['no']; $customize = $_GET['customize']; $sql = "select sortname from takeorder_item where id='{$id}'"; $res = s_fetch($sql); $sortname = $res[0]['sortname']; $sql_itemself = "select * from takeorder_item where sortname='{$sortname}' and itemname!=''"; $query_itemself = m_query($sql_itemself); $num = mysql_num_rows($query_itemself); $p = new show_page(); $p->pvar = "p"; $p->setvar(array("id" => $_GET['id'], "no" => $no, "customize" => $customize)); $p->set(3, $num, "", "itemself"); $sql_itemself .= " limit " . $p->limit(); $itemsort_result = m_query($sql_itemself); while ($row_itemself = m_fetch($itemsort_result)) { $itemselflist[] = $row_itemself; } //print_rr($itemselflist); /* $i =0; while($row=m_fetch($itemsort_result)){ $sortlist[]=$row; if($i==0){ $sql_itemself = "select sortname from item where id='$id'"; $query_itemself = m_query($sql_itemself);
<?php session_start(); include_once './inc/init.php'; $id = $_GET['id']; $sql = "select * from item where id='{$id}' order by id desc"; $arritem = s_fetch($sql); $no = $_GET['no']; $customize = $_GET['customize']; $smarty->assign('no', $no); $smarty->assign('customize', $customize); $smarty->assign('items', $arritem); $smarty->display("setitemnum.htm");