deliver.php

电子派单系统

<?php
session_start();
include("resp.inc");
if(!isset($_SESSION['guser'])){print "请先登录再使用本功能";print $_SESSION['guser']; return false; } 
$sn=$_POST["sn"]; if (strlen($sn) >10) {print "没事干可以找我"; return false;}
$name=$_POST['name']; if (strlen($name)>30) {print  "用户名称不应超过15个汉字"; return false;}
$ctype=$_POST['ctype']; if (strlen($ctype)>30) {print "用户类别不可能超过15汉字"; return false;}
$stdman=$_POST['stdman']; if (strlen($stdman)>8) {print "联系人名称不应该超过4汉字";return false;}
$contact=$_POST['contact']; if (strlen($contact)>11) {print "联系号码不应该有超11个数字的吧？"; return false;}
$addr=$_POST['addr']; if (strlen($addr)>40) {print "我们假设联系地址应该不超过20个汉字"; return false;}
$payph=$_POST['payph']; if (strlen($payph)>8) {print "付费电话号码不应该超过8位数字";return false;}
$insph=$_POST['insph'];if (strlen($insph)>8) {print "安装电话号码不应该超过8位数字";return false;}
$contm=$_POST['besttime']; if (strlen($besttime)>60) {print "最佳联系时间或预约时间不要超过30汉字";return false;}
$descp=$_POST['descp']; if (strlen($descp)>600) {print "故障描述不应该超过300汉字";return false;}
$user=$_POST['user']; if (strlen($user)>16) {print "我们不受理用户名超过16字符的用户";return false;}
$pass=$_POST['pass']; if(strlen($pass)>16) {print "我们认为用户的密码不应该超过16字符";return false;}
$otime=$_POST['otime'];
$depart=$_POST['depart'];
resp_db_connect_i();
$result=mysql_query("select depart from worker where user='$_SESSION[guser]'") ;
if (mysql_affected_rows()>0) { $opt=mysql_fetch_array($result);$comed=$opt[0];}
else{print "不会吧？你有什么企图啊？！";return false;}
mysql_query("insert deliver (sn,name,ctype,stdman,contact,addr,payph,insph,contm,descp,user,pass,stime,indep,man)  values('$sn','$name','$ctype','$stdman','$contact','$addr','$payph','$insph','$contm','$descp','$user','$pass',now(),'$depart[0]','$_SESSION[guser]')") or die("Invalid query: " .mysql_error());
print "工单添加成功<br>";
mysql_query("insert flow (sn,comed,goin,arrtm,spdtm,man,snord) values ('$sn','$comed','$depart[0]',now(),date_add(now(),INTERVAL '$otime' HOUR_MINUTE),'$_SESSION[guser]',1)") or die("Invalid query: " . mysql_error());
print "派单成功，请稍候注意应答情况<br>";
?>