include_once './inc/db.inc.php'; require './inc/ajax_inpage.inc.php'; $data=new DBSQL(); $arr=array(); //分页数组构造初始化 $arr['search']='1'; //搜索的必要条件 $showsql="select * from takeorder_tmp_order_detail inner join takeorder_menu_list on menu_list.k_id=tmp_order_detail.menu_id where 1=1 "; if($_GET['k_id']){ $showsql.="and order_id='$_GET[k_id]' "; //搜索类别 $arr['k_id']=urlencode($_GET['k_id']); } if($_GET['id']){ $showsql.="and client_id='$_GET[id]' "; //搜索类别 $arr['id']=urlencode($_GET['id']); } $list=$data->select($showsql); $num=count($list); $p = new show_page; $p->pvar="p"; $p->setvar($arr); $p->set(5,$num,"",'main_div',''); $list2=array(); $showsql.=" limit ".$p->limit(); $list=$data->select($showsql); if(count($list)<5){ $num=5-count($list); for($k=0;$k<$num;$k++){ $list2[]=$k; $smarty->assign("list2",$list2); } }
<?php include_once './inc/init.php'; include_once './inc/db.inc.php'; require './inc/ajax_page.inc.php'; $data = new DBSQL(); $arr = array(); //分页数组构造初始化 $arr['search'] = '1'; //搜索的必要条件 $showsql = "select * from coment where 1=1 "; if ($_GET['id']) { $showsql .= "and id='{$_GET['id']}' "; //搜索类别 $arr['id'] = urlencode($_GET['id']); } $list = $data->select($showsql); $num = count($list); $p = new show_page(); $p->pvar = "p"; $p->file = "list.php"; $p->setvar($arr); $p->set(5, $num, "", 'main_div', ''); $showsql .= " ORDER BY id desc "; $showsql .= " limit " . $p->limit(); $list = $data->select($showsql); $smarty->assign("list", $list); $pages = $p->output(1); $smarty->assign('pages', $pages); $smarty->display("sublist.htm");
<?php include_once './inc/init.php'; include_once './inc/db.inc.php'; $db=new DBSQL(); if ($_POST['sub']){ $sql="select * from takeorder_a_user where login_name='$_POST[username]'"; $account=$db->select($sql); if ($account[0]['login_pass']==$_POST['passwd']){ $_SESSION['name']=$_POST['username']; if($_POST['type']=='simple'){ alert_msg(FALSE,'simple.php'); }else{ alert_msg(FALSE,'index.php'); } }else { $smarty->assign('message','Account Error!'); $smarty->display('login.htm'); } }else { $smarty->display("login.htm"); } ?>
$sql="insert into takeorder_tmp_menu_remark(order_id,action,remark,remark_no,seq_id) values ('$k_id','$sort','$content','$remark_no',1)"; $data->insert($sql); } } // if($_GET['type']=='simple'){ //如果有值,将增加 if ($_GET['sort'] && $_GET['content'] && $_GET['k_id']) { $sort=$_GET['sort']; $content=$_GET['content']; $sqlsort="select name from takeorder_remark_sort where remark_no='$sort'"; $sqlcontent="select name from takeorder_remark_content where remark_no='$content'"; $listsort=$data->select($sqlsort); $sort=$listsort[0][0]; $listcontent=$data->select($sqlcontent); $content=$listcontent[0][0]; $remark_no=$sort.$content; $sql="insert into takeorder_tmp_menu_remark(order_id,action,remark,remark_no,seq_id) values ('$k_id','$sort','$content','$remark_no',1)"; $data->insert($sql); } }
<?php include_once './inc/init.php'; include_once './inc/db.inc.php'; require './inc/ajax_page.inc.php'; $data = new DBSQL(); $oldid = $_GET['oldid']; $ttsql = "select k_id from takeorder_order_main where order_no='{$oldid}'"; $tmdlist = $data->select($ttsql); $pk_id = $tmdlist[0][k_id]; $musql = "select k_id from takeorder_order_detail where order_id='{$pk_id}'"; $sblist = $data->select($musql); for ($i = 0; $i < count($sblist); $i++) { $sbid = $sblist[$i][k_id]; $mbdsql = "delete from takeorder_menu_remark where order_id='{$sbid}'"; $data->delete($mbdsql); } $data->delete("delete from takeorder_order_detail where order_id='{$pk_id}'"); $hhsql = "delete from takeorder_order_main where order_no='{$oldid}'"; $data->delete($hhsql); $insertsql = "insert into takeorder_order_main(table_id,order_time,price,status,order_no,operator,pay_status) select table_id,order_time,price,status,order_no,operator,pay_status from tmp_order_main"; $insertid = $data->insert($insertsql); $sub_insertsql = "select * from takeorder_tmp_order_detail"; $sublist = $data->select($sub_insertsql); for ($i = 0; $i < count($sublist); $i++) { $order_id = $insertid; $client_id = $sublist[$i][client_id]; $menu_id = $sublist[$i][menu_id]; $qty = $sublist[$i][qty]; $remark_id = $sublist[$i][remark_id]; $subsql = "insert into takeorder_order_detail(order_id,client_id,menu_id,qty,remark_id) values('{$order_id}','{$client_id}','{$menu_id}','{$qty}','{$remark_id}')"; $insetlc = $data->insert($subsql);
<?php include_once './inc/init.php'; include_once './inc/db.inc.php'; require './inc/ajax_page.inc.php'; $data = new DBSQL(); if ($_GET['action'] == 'table') { $tableno = $_GET['tableno']; $time = time(); $operator = $_SESSION['name']; $ifsql = "select count(*) from takeorder_tmp_order_main where table_id='{$tableno}'"; $list = $data->select($ifsql); $num = $list[0][0]; $st = time(); $orde_no = rand(10, 99) . $st . rand(10, 99); if ($flag == 0) { $sql = "insert into takeorder_tmp_order_main(table_id,order_time,order_no,operator) values('{$tableno}','{$time}','{$orde_no}','{$operator}')"; $k_id = $data->insert($sql); } else { if ($num > 0) { exit; } else { $sql = "insert into takeorder_tmp_order_main(table_id,order_time,order_no,operator) values('{$tableno}','{$time}','{$orde_no}','{$operator}')"; $k_id = $data->insert($sql); } } //echo "You had choose NO.".$tableno." customize,Chooes Customize Successfully!"; echo "<input type='hidden' id='k_id' name='k_id' value='{$k_id}'>"; } if ($_GET['action'] == 'people') { $order_id = $_GET['k_id']; $client_id = $_GET['id'];
<?php include_once './inc/init.php'; include_once './inc/db.inc.php'; require './inc/ajax_order_page.inc.php'; $p = new show_page(); $p->pvar = "p"; $data = new DBSQL(); $sql = "select * from takeorder_kind"; $list = $data->select($sql); $num = count($list); $p->set(4, $num, "", "newpalce", ''); $sql .= " limit " . $p->limit(); $list = $data->select($sql); for ($i = 0; $i < count($list); $i++) { $id = $list[$i][id]; $subsql = "select * from takeorder_kind_sub where id='{$id}'"; $sublist = $data->select($subsql); $list[$i][sub] = $sublist; } $pages = $p->output(1); $smarty->assign("list", $list); $smarty->assign('pages', $pages); $smarty->display("getchoseitem.htm");
<?php session_start(); //include_once './inc/page.inc.php'; include_once './inc/init.php'; include_once './inc/db.inc.php'; $sql = "select * from main"; $result = s_fetch($sql); $data = new DBSQL(); $sqlitem = "select distinct(sortname) from takeorder_item"; $listitem = $data->select($sqlitem); //print_rr($listitem); $sql = "select * from takeorder_item"; //̨ºÅ $arrCustomer = array(); if (isset($_GET['cusomizepage'])) { $cusomizepage = $_GET['cusomizepage']; } else { $cusomizepage = 1; } for ($i = 1; $i <= 6 * $cusomizepage; $i++) { $arrCusomize[] = array("id" => $i, "name" => $i); } $rowitem = $data->select($sql); $smarty->assign('rowitem', $rowitem); $smarty->assign('arrCusomize', $arrCusomize); $smarty->assign('rows', $result); $smarty->display("main1.htm");
<?php include_once './inc/init.php'; include_once './inc/db.inc.php'; require './inc/ajax_page.inc.php'; $data = new DBSQL(); $arr = array(); //分页数组构造初始化 $arr['search'] = '1'; //搜索的必要条件 $reholdsql = "select * from takeorder_tmp_order_detail inner join menu_list on menu_list.k_id=tmp_order_detail.menu_id"; $list = $data->select($reholdsql); $num = count($list); $p = new show_page(); $p->file = "lcshow.php"; $p->pvar = "p"; $p->setvar($arr); $p->set(5, $num, "", 'show', ''); $reholdsql .= " limit " . $p->limit(); $list = $data->select($reholdsql); for ($i = 0; $i < count($list); $i++) { $m_id = $list[$i][0]; $remarksql = "select count(*) from takeorder_tmp_menu_remark where order_id='{$m_id}'"; $remarklist = $data->select($remarksql); if ($remarklist[0][0] > 0) { $list[$i]['rm'] = '*'; } else { $list[$i]['rm'] = ''; } } $smarty->assign("list", $list);
<?php include_once './inc/init.php'; include_once './inc/db.inc.php'; require './inc/ajax_page.inc.php'; $cache_on = false; $data = new DBSQL(); $table = $_GET['table']; $whatid = $table; $tablsql = "select * from takeorder_tmp_order_main where order_no='{$table}'"; $tablist = $data->select($tablsql); $table_id = $tablist[0][table_id]; if (count($tablist) == 0) { $insertsql = "insert into takeorder_tmp_order_main(table_id,order_time,price,status,order_no,operator,pay_status) select table_id,order_time,price,status,order_no,operator,pay_status from takeorder_order_main where order_no='{$table}'"; $selectk_id = "select k_id from takeorder_order_main where order_no='{$table}'"; $idlist = $data->select($selectk_id); $oldid = $idlist[0][0]; $insertid = $data->insert($insertsql); $sql = "select * from takeorder_order_detail where order_id='{$oldid}'"; $sublist = $data->select($sql); for ($i = 0; $i < count($sublist); $i++) { $order_id = $insertid; $client_id = $sublist[$i][client_id]; $menu_id = $sublist[$i][menu_id]; $qty = $sublist[$i][qty]; $remark_id = $sublist[$i][remark_id]; $subsql = "insert into takeorder_tmp_order_detail(order_id,client_id,menu_id,qty,remark_id) values('{$order_id}','{$client_id}','{$menu_id}','{$qty}','{$remark_id}')"; $insetlc = $data->insert($subsql); $fkid = $sublist[$i][k_id]; $lcsql = "select * from takeorder_menu_remark where order_id='{$fkid}'"; $lclist = $data->select($lcsql);
if ($_GET['action'] == 'add') { $title = $_GET['title']; $context = $_GET['context']; $context = preg_replace("/\\[Y\\](.+?)\\[\\/\\Y\\]/", "<img src=images/\\1.gif>", $context); $context = ereg_replace("'", "\\'", $context); $time = date("Y-m-d"); $sql = "insert into coment(title,context,time) values('{$title}','{$context}','{$time}')"; $data->insert($sql); } if ($_GET['action'] == 'rq') { $title = $_GET['title']; $context = $_GET['context']; $time = date("Y-m-d"); $id = $_GET['id']; $qsql = "select context from coment where id={$id}"; $nw = $data->select($qsql); $oldcon = $nw[0][0]; $context = "<div class=newarticle>" . $oldcon . "</div>" . $context; $context = preg_replace("/\\[Y\\](.+?)\\[\\/\\Y\\]/", "<img src=images/\\1.gif>", $context); $context = ereg_replace("'", "\\'", $context); $sql = "insert into coment(title,context,time) values('{$title}','{$context}','{$time}')"; $data->insert($sql); } if ($_GET['action'] == 'show') { $id = $_GET['id']; $smarty->assign('id', $id); $smarty->display("text.htm"); } if ($_GET['action'] == 'image') { $id = $_GET['id']; for ($i = 1; $i <= count($imagearray); $i++) {