$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);
