金微智能点餐支付管理系统 v6.0.0源码

<?php require "config.php"; $m=file_get_contents("php://input");if($m=="")$m='{"act":"index"}';$m=Dec($m,true); if($m["act"]!="index"){ $q=Qry("Select Nr,Nm From GwShu Where DD=0 And ID=".$m["uid"]." And Mi=".$m["nid"]." And Ni='".$m["sid"]."'"); if(Qrc($q)==0)die('{"msg":"连接超时，请重登录！"}'); $r=Qra($q);if(strpos($r[0],"A")===false&&strpos($r[0],"B")===false&&strpos($r[0],"F")===false)die('{"msg":"无此权限！"}'); $nid=$m["nid"];$uid=$m["uid"];$rid=$r[0];$unm=$r[1]; } switch($m["act"]){ case "cfg"://设置读取 $p=["msg"=>"ok","scl"=>[],"scd"=>[],"rid"=>"","unm"=>""]; $q=Qry("Select ID,Nm,No,Nh,Ns From GwShc Where Mi=".$nid." Order By No Asc"); while($r=Qra($q))$p["scl"][]=$r; $q=Qry("Select ID,Nm,Nt,No,Ni,Np,Ns,Nh,Nc,Nk,Ny,N1,N2,Nd,Nf From GwShd Where DD=0 And Mi=".$nid." Order By No Asc"); while($r=Qra($q))$p["scd"][]=$r; $r=Qra(Qry("Select Mn,Ni,Nz,Np From GwShp Where Mi=".$nid)); $p["scc"]=explode("|",$r[0]."|".$r[1]); $p["scz"]=explode("\$",$r[2]); $p["scp"]=explode("|",$r[3]); $p["rid"]=$rid;$p["unm"]=$unm; echo Enc($p); break; case "cnt"://读取统计 $a=date("Y-m-d",strtotime($m["d1"]));$b=date("Y-m-d",strtotime("+1 Day",strtotime($m["d2"]))); $s=round(strtotime($b)-strtotime($a))/86400;//区间 0 $s.="|".Qrs(Qry("Select Sum(Ps) From GwOdr Where Mi=".$nid." And Ps>0 And Dt>'".$a."' And Dt<'".$b."'"))/100;//营业额 1 $s.="|".Qrs(Qry("Select Count(ID) From GwOdr Where Mi=".$nid." And Ps>0 And Dt>'".$a."' And Dt<'".$b."'"))*1;//点单数 2 $s.="|".Qrs(Qry("Select Count(ID) From GwOdc Where Mi=".$nid." And Td<2 And Dt>'".$a."' And Dt<'".$b."'"))*1;//点菜数 3 $s.="|".Qrs(Qry("Select Count(ID) From GwOdc Where Mi=".$nid." And Td=2 And Dt>'".$a."' And Dt<'".$b."'"))*1;//退菜数 4 $q=Qry("Select Pt From GwOdr Where Mi=".$nid." And Ps>0 And Dt>'".$a."' And Dt<'".$b."'"); $c=[0,0,0,0,0,0,0];$t=[0,0]; while($r=Qra($q)){$d=explode("|",$r[0]);for($i=0;$i<7;$i++){$c[$i]+=$d[$i]/100;}$t[0]+=($d[2]*1-round($d[2]*0.006))/100;$t[1]+=($d[3]*1-round($d[3]*0.006))/100;} $s.="|".implode("|",$c);//分项 现金|刷卡|微信|支付宝|会员卡|团购券|优惠券 5|6|7|8|9|10|11 $s.="|".Qrs(Qry("Select Sum(Ps) As N From GwMxf Where Mi=".$nid." And Oi=0 And Pd>'".$a."' And Pd<'".$b."'"))/100;//会员充值 12 $t=explode("|",$s."|".implode("|",$t));$t[0]=$a;$t=implode("|",$t);$r=Rnd();$e="";$z=""; $q=Qry("Select Ci,Cn,Count(ID) As N From GwOdc Where Mi=".$nid." And Dt>'".$a."' And Dt<'".$b."' Group By Ci,Cn Order By Count(ID) Desc Limit 3"); while($r=Qra($q))$e.="\$".$r["Cn"]."#".$r["N"];$e.="|"; $q=Qry("Select A.Yi,B.Nn,Count(A.ID) As N From GwOdr As A,GwShu As B Where A.Mi=".$nid." And B.ID=A.Yi And A.Dt>'".$a."' And A.Dt<'".$b."' Group By A.Yi,B.Nn Order By Count(A.ID) Desc Limit 3"); while($r=Qra($q))$e.="\$".$r["Nn"]."#".$r["N"]; $f=(strtotime($b)-strtotime($a));$b=$a;$a=date("Y-m-d",strtotime($a)-$f); $s.="|".Qrs(Qry("Select Sum(Ps) From GwOdr Where Mi=".$nid." And Ps>0 And Dt>'".$a."' And Dt<'".$b."'"))/100;//营业额 13 $s.="|".Qrs(Qry("Select Count(ID) From GwOdr Where Mi=".$nid." And Ps>0 And Dt>'".$a."' And Dt<'".$b."'"))*1;//点单数 14 $s.="|".Qrs(Qry("Select Count(ID) From GwOdc Where Mi=".$nid." And Td<2 And Dt>'".$a."' And Dt<'".$b."'"))*1;//点菜数 15 $s.="|".Qrs(Qry("Select Count(ID) From GwOdc Where Mi=".$nid." And Td=2 And Dt>'".$a."' And Dt<'".$b."'"))*1;//退菜数 16 $q=Qry("Select Pt From GwOdr Where Mi=".$nid." And Ps>0 And Dt>'".$a."' And Dt<'".$b."'"); $c=[0,0,0,0,0,0,0]; while($r=Qra($q)){$d=explode("|",$r[0]);for($i=0;$i<7;$i++){$c[$i]+=$d[$i]/100;}} $s.="|".implode("|",$c);//分项 现金|刷卡|微信|支付宝|会员卡|团购券|优惠券 17|18|19|20|21|22|23 $s.="|".Qrs(Qry("Select Sum(Ps) As N From GwMxf Where Mi=".$nid." And Oi=0 And Pd>'".$a."' And Pd<'".$b."'"))/100;//会员充值 24 $s.="|".$e; echo '{"msg":"ok","cnt":"'.$s.'"}'; break; case "snd"://语音合成 $f=Dec(Cul($pay_post,'{"act":"snd","snd":"'.$m["snd"].'"}')); if(!isset($f["msg"])||$f["msg"]!="ok"||$f["mp3"]=="")die('{"msg":"ok","mp3":"images/warn.mp3"}'); echo Enc($f); break; case "uls"://会员列表 $a=$m["usr"];if($a!="")$a=" And (Nc Like '%".$a."%' Or Nm Like '%".$a."%')"; $p=["msg"=>"ok","scu"=>[]]; $q=Qry("Select ID,Nc,Nm,Np,Nd,Ns,Nx,Nz,Ne From GwMbr Where ID>0".$a." Order By ID Desc Limit 30"); while($r=Qra($q))$p["scu"][]=$r; echo Enc($p); break; case "usv"://会员保存 $a=$m["usr"];$b=md5($a[3]); if($a[0]=="0"){ if(Qrc(Qry("Select ID From GwMbr Where Nc='".$a[1]."'"))==0){ Qry("Insert Into GwMbr (Nc,Nm,Np,Nd,Ns,Nx,Nz,Ne,Nf) Values ('".$a[1]."','".$a[2]."','".$b."',Now(),0,0,Now(),0,'')"); }else die('{"msg":"会员卡号已被占用，请重新输入！"}'); }else{ $c=Qrs(Qry("Select Np From GwMbr Where ID=".$a[0])); Qry("Update GwMbr Set Nm='".$a[2]."',Np='".($c==$a[3]?$a[3]:$b)."' Where ID=".$a[0]); } echo '{"msg":"ok"}'; break; case "udl"://会员删除 Qry("Delete From GwMbr Where Mi=".$s[0]." And Ns=0 And Nx=0 And ID=".$m["usr"]); echo '{"msg":"ok"}'; break; case "ucz"://会员充值 $a=$m["usr"]; Qry("Insert Into GwMxf (Mi,Nc,Oi,Yi,Ps,Pc,Pd,Pf) Values (".$nid.",'".$a[1]."',0,'".$a[3]."',".$a[4].",".$a[5].",Now(),0)"); echo '{"msg":"ok","cid":"'.Qri().'"}'; Qry("Update GwMbr Set Ns=Ns+".$a[5]." Where Nc='".$a[1]."'"); break; case "pls"://排队叫号 if(!file_exists("images/".$nid."/C.json"))file_put_contents("images/".$nid."/C.json",'{"si":0,"sj":"'.date("Y-m-d H:i:s").'","ph":[],"yd":[]}'); if(substr(file_get_contents("images/".$nid."/C.json"),0,1)!='{')file_put_contents("images/".$nid."/C.json",'{"si":0,"sj":"'.date("Y-m-d H:i:s").'","ph":[],"yd":[]}'); echo '{"msg":"ok","dat":'.file_get_contents("images/".$nid."/C.json").'}'; break; case "psv"://排队新增 $f=Dec(file_get_contents("images/".$nid."/C.json")); if(date("Y-m-d")>date("Y-m-d H:i:s",strtotime($f["sj"]))){$f["si"]=1;$f["sj"]=date("Y-m-d H:i:s");}else $f["si"]+=1; $f["ph"][]=[$f["si"],$m["prs"],date("Y-m-d H:i:s"),$m["rsi"]]; file_put_contents("images/".$nid."/C.json",Enc($f)); echo '{"msg":"ok"}'; break; case "pdl"://排队删除 $f=Dec(file_get_contents("images/".$nid."/C.json")); if($m["pri"]*1!=-1){array_splice($f["ph"],$m["pri"],1);}else $f["ph"]=[]; file_put_contents("images/".$nid."/C.json",Enc($f)); echo '{"msg":"ok"}'; break; case "pys"://预定增加 $f=Dec(file_get_contents("images/".$nid."/C.json")); $f["yd"][]=[$m["gk"],$m["dh"],$m["rs"],date("Y-m-d H:i",strtotime($m["sj"])),$m["cz"]]; file_put_contents("images/".$nid."/C.json",Enc($f)); echo '{"msg":"ok"}'; break; case "pyd"://预定删除 $f=Dec(file_get_contents("images/".$nid."/C.json")); if($m["pri"]*1!=-1){array_splice($f["yd"],$m["pri"],1);}else $f["yd"]=[]; file_put_contents("images/".$nid."/C.json",Enc($f)); echo '{"msg":"ok"}'; break; case "lst"://餐桌读取 $p=["msg"=>"ok","tb"=>[],"tk"=>[],"kc"=>""]; $q=Qry("Select ID,Nm,No,Ns,Ni,Oi,Nc,Op From GwSht Where Mi=".$nid." And DD=0 Order By No Asc"); while($r=Qra($q))$p["tb"][]=$r; $q=Qry("Select ID,St,Pz,Dt,Lx From GwOdr Where Mi=".$nid." And Ti=0 And St<13 Order By ID Desc"); while($r=Qra($q))$p["tk"][]=$r; $p["kc"]=Qrc(Qry("Select ID From GwShk Where Mi=".$nid." And Nk<=Nw And DD=0")); echo Enc($p); break; case "lsi"://点单读取 $a=$m["tid"];$d=$m["oid"]; $p=["msg"=>"ok","td"=>[],"th"=>[]]; $b=$d!="0"?$d:Qrs(Qry("Select Oi From GwSht Where Mi=".$nid." And ID=".$a)); $c=1; $q=Qry("Select ID,Ti,Yi,Pz,Ps,Pc,St,Dt,I4,Ds,Pt,Bz,Lx From GwOdr Where Mi=".$nid." And ID=".$b); if(Qrc($q)>0){ $r=Qra($q);$r[13]=strtotime($r[7]);$p["td"]=$r;$c=$r[6]; $q=Qry("Select ID,Oi,Ti,Ci,Cn,Cp,Cs,St,I1,I2,I3,Dt,Td,Bz From GwOdc Where Mi=".$nid." And Oi=".$b." Order By ID Asc"); while($r=Qra($q))$p["th"][]=$r; } if($m["atc"]!=1){ Qry("Update Gw