$lc_id = $sublist[$i][k_id]; $lcsql = "select * from takeorder_tmp_menu_remark where order_id='{$lc_id}'"; $lclist = $data->select($lcsql); for ($j = 0; $j < count($lclist); $j++) { $action = $lclist[$j][action]; $remark = $lclist[$j][remark]; $remark_no = $lclist[$j][remark_no]; $order_id = $insetlc; $lcinsertsql = "insert into takeorder_menu_remark(order_id,action,remark,remark_no) values('{$order_id}','{$action}','{$remark}','{$remark_no}')"; $data->insert($lcinsertsql); } } $delsql = "delete from takeorder_tmp_order_main"; $delfk = "delete from takeorder_tmp_menu_remark"; $delsql_sub = "delete from takeorder_tmp_order_detail"; $data->delete($delsql); $data->delete($delfk); $data->delete($delsql_sub); } if ($_GET['action'] == 'delete') { $k_id = $_GET['id']; if (!$k_id) { exit; } $fusql = "delete from takeorder_tmp_order_detail where k_id='{$k_id}'"; $cksql = "delete from takeorder_tmp_menu_remark where order_id='{$k_id}'"; $data->delete($fusql); $data->delete($cksql); } if ($_GET['action'] == 'deleteall') { $delsql = "delete from takeorder_tmp_order_main";
require './inc/ajax_order_page.inc.php'; $p = new show_page; $p->pvar="p"; $p->file='remark_list.php'; $p->prew_img=TRUE; $p->next_img=TRUE; $data=new DBSQL(); //如果是删除动作将删除 if ($_GET['sqlaction']) { $dsql="delete from takeorder_tmp_menu_remark where k_id=$_GET[k_id]"; $data->delete($dsql); } $k_id=$_GET['k_id']; //all if($_GET['type']=='all'){ //如果有值,将增加 if ($_GET['sort'] && $_GET['content'] && $_GET['k_id']) { $sort=$_GET['sort']; $content=$_GET['content']; $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);