alert('5.6 碼都被佔用,請洽主管!')"; } $_SESSION['newsubcode'] = $newsubcode; $_SESSION['id_new'] = $_POST['id_new']; } mysql_select_db($database_newzoo, $newzoo); $query_idfinder = "SELECT * FROM `customer` WHERE `id` LIKE '".$_SESSION['id_new']."'"; $codefinder = mysql_query($query_idfinder, $newzoo)or die(mysql_error()); $row_codefinder = mysql_fetch_assoc($codefinder); $totalRows_Recordset1 = mysql_num_rows($codefinder); if(isset($_POST['act']) && $_POST['act'] =="ver" && mysql_num_rows($codefinder) != 0){ echo ""; $_SESSION['id_new'] = ''; $_SESSION['newsubcode']= ''; } if (isset($_POST['act']) && ($_POST["act"] == "newadd") && $_SESSION['newsubcode'] !='') { $query_Recordset15 = "SELECT * FROM customer Where fullname != '' order by dsnn desc"; $Recordset15 = mysql_query($query_Recordset15, $newzoo) or die(mysql_error()); $row_Recordset15 = mysql_fetch_assoc($Recordset15); $dsnn=$row_Recordset15['dsnn']; $totalRows_Recordset15=$dsnn-11; /*b*/ $insertBook = "INSERT INTO customer_a (id, add_name, add_date) VALUES ('".$_POST['id_new']."','".$_POST['user']."','". date('Y-m-d')."')"; mysql_select_db($database_newzoo, $newzoo); $Result1 = mysql_query($insertBook, $newzoo) or die(mysql_error()); $insertSQL = sprintf("INSERT INTO customer (exp_date, spattn, name, fileno, id, code, webcode, idcode, fullname, sexul, bir, bir_w, cus_age, add_cus, add_reg, pho1, pho2, cell, dsbtype, grade, cater, email, area, wheelchair, fax_cus, impotak, died, `add_date`, `user`, n_dvr, lowin, m_lowin, car_size, dia_date,`usage`,mms ,mmsphone) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['exp_date'], "date"), GetSQLValueString($_POST['spattn'], "text"), GetSQLValueString($_POST['name'], "text"), GetSQLValueString("yc".$totalRows_Recordset15, "text"), GetSQLValueString(trim($_POST['id_new']), "text"), GetSQLValueString($_POST['code'], "text"), GetSQLValueString($_SESSION['newsubcode'], "text"), GetSQLValueString("A".$_SESSION['newsubcode'], "text"), GetSQLValueString(trim($_POST['fullname']), "text"), GetSQLValueString($_POST['sexul'], "text"), GetSQLValueString($_POST['bir'], "text"), GetSQLValueString($_POST['bir_w'], "date"), GetSQLValueString($_POST['cus_age'], "int"), GetSQLValueString(addslashes($_POST['add_cus']), "text"), GetSQLValueString(addslashes($_POST['add_reg']), "text"), GetSQLValueString(addslashes($_POST['pho1']), "text"), GetSQLValueString(addslashes($_POST['pho2']), "text"), GetSQLValueString(addslashes($_POST['cell']), "text"), GetSQLValueString($_POST['dsbtype'], "text"), GetSQLValueString($_POST['grade'], "text"), GetSQLValueString($_POST['cater'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['area'], "text"), GetSQLValueString($_POST['wheelchair'], "text"), GetSQLValueString($_POST['fax_cus'], "text"), GetSQLValueString(addslashes($_POST['impotak']), "text"), GetSQLValueString(isset($_POST['died']) ? "true" : "", "defined","1","0"), GetSQLValueString($_POST['add_date'], "date"), GetSQLValueString($_POST['user'].".".date('Ymd H:i:s'), "text"), GetSQLValueString($_POST['n_dvr'], "text"), GetSQLValueString(isset($_POST['lowin']) ? "true" : "", "defined","'1'","'0'"), GetSQLValueString(isset($_POST['m_lowin']) ? "true" : "", "defined","'1'","'0'"), GetSQLValueString($_POST['car_size'], "text"), GetSQLValueString($_POST['dia_date'], "text"), GetSQLValueString($_POST['usage'], "text"), GetSQLValueString($_POST['mms'], "text"), GetSQLValueString($_POST['mmsphone'], "text")); mysql_select_db($database_newzoo, $newzoo); $Result1 = mysql_query($insertSQL, $newzoo) or die(mysql_error()); /*a*/ $insertSQL = sprintf("INSERT INTO customer (exp_date, spattn, name, fileno, id, code, webcode, idcode, fullname, sexul, bir, bir_w, cus_age, add_cus, add_reg, pho1, pho2, cell, dsbtype, grade, cater, email, area, wheelchair, fax_cus, impotak, died, `add_date`, `user`, n_dvr, lowin, m_lowin, car_size, dia_date,`usage`,mms ,mmsphone) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['exp_date'], "date"), GetSQLValueString($_POST['spattn'], "text"), GetSQLValueString($_POST['name'], "text"), GetSQLValueString("yc".$totalRows_Recordset15, "text"), GetSQLValueString(trim($_POST['id_new']), "text"), GetSQLValueString($_POST['code'], "text"), GetSQLValueString($_SESSION['newsubcode'], "text"), GetSQLValueString("A".$_SESSION['newsubcode'], "text"), GetSQLValueString(trim($_POST['fullname']), "text"), GetSQLValueString($_POST['sexul'], "text"), GetSQLValueString($_POST['bir'], "text"), GetSQLValueString($_POST['bir_w'], "date"), GetSQLValueString($_POST['cus_age'], "int"), GetSQLValueString(addslashes($_POST['add_cus']), "text"), GetSQLValueString(addslashes($_POST['add_reg']), "text"), GetSQLValueString(addslashes($_POST['pho1']), "text"), GetSQLValueString(addslashes($_POST['pho2']), "text"), GetSQLValueString(addslashes($_POST['cell']), "text"), GetSQLValueString($_POST['dsbtype'], "text"), GetSQLValueString($_POST['grade'], "text"), GetSQLValueString($_POST['cater'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['area'], "text"), GetSQLValueString($_POST['wheelchair'], "text"), GetSQLValueString($_POST['fax_cus'], "text"), GetSQLValueString(addslashes($_POST['impotak']), "text"), GetSQLValueString(isset($_POST['died']) ? "true" : "", "defined","1","0"), GetSQLValueString($_POST['add_date'], "date"), GetSQLValueString($_POST['user'].".".date('Ymd H:i:s'), "text"), GetSQLValueString($_POST['n_dvr'], "text"), GetSQLValueString(isset($_POST['lowin']) ? "true" : "", "defined","'1'","'0'"), GetSQLValueString(isset($_POST['m_lowin']) ? "true" : "", "defined","'1'","'0'"), GetSQLValueString($_POST['car_size'], "text"), GetSQLValueString($_POST['dia_date'], "text"), GetSQLValueString($_POST['usage'], "text"), GetSQLValueString($_POST['mms'], "text"), GetSQLValueString($_POST['mmsphone'], "text")); mysql_select_db($database_newzoo, $newzoo_a); $Result1 = mysql_query($insertSQL, $newzoo_a) or die(mysql_error()); $name=substr($_POST['fullname'],0,2).substr($_POST['fullname'],-2); $insertSQL2 = sprintf("INSERT INTO tpe (idcode, fullname, name ) VALUES (%s, %s, %s)", GetSQLValueString("A".$_SESSION['newsubcode'], "text"), GetSQLValueString($_POST['fullname'], "text"), GetSQLValueString($name, "text")); mysql_select_db($database_newzoo, $newzoo); $Result2 = mysql_query($insertSQL2, $newzoo) or die(mysql_error()); /*長照 手冊*/ $insert_new= "INSERT INTO customer_sub ( nid, handbook )values('".$_POST['id']." ','".$_POST['handbook']."')"; mysql_select_db($database_newzoo, $newzoo); $Result2a = mysql_query($insert_new, $newzoo) or die(mysql_error()); $_SESSION['id_new'] =''; $_SESSION['newsubcode'] =''; echo ""; } mysql_select_db($database_newzoo, $newzoo); $query_Recordset135 = "SELECT * FROM areaselect WHERE acode='1'"; $Recordset135 = mysql_query($query_Recordset135, $newzoo) or die(mysql_error()); $row_Recordset135 = mysql_fetch_assoc($Recordset135); $totalRows_Recordset135 = mysql_num_rows($Recordset135); ?>
客戶資料新增
客戶新增
身份證號碼
sys.cus_new
資格有效日:
檔案編號:
存檔後產生!
乘客姓名:
乘客編號:
網路帳號:
訂車等級:
1n1
1n2
2n1
2n2
2n3
2n4
2n5
3n1
3n2
殘障等級:
極重度
重度
中度
輕度
障別:
重肢
中肢
輕肢
重adls
普重障
障65
中adls
罕見疾病
視障
植物人
重器障
重器障(腎)
重器障(腸)
多重障
精障
失智症
癡障
聲語障
多重障(聲、智、染)
重器障(心)
重器障(呼吸)
聽障
智障
平衡障
自閉症
癲癇症
顏殘
發展遲緩
其他
輪椅種類:
普通
無
電動
特殊
生日: 民國
年
01
02
03
04
05
06
07
08
09
10
11
12
月
日
西洋格式:
性別: 自動產生-[
" type="text" readonly /> ]
低收入戶:
中低收入戶:
年齡:
戶籍地:
新北市路段巷號樓
通訊地址:
同戶籍地
電話1:
電話2:
駕駛班表顯示:
注意事項:
手機:
傳真:
區域:
特殊要求:
無
小車
高頂
不共乘
需來回
簡訊:
0
同意
不同意
簡訊專用手機:
Email:
往生:
乘車用途:
就醫
就學
就業
其他
車輛種類:
小
中
高頂
診斷證明書的有效期限:
新增日期: 製單:
資格証明:
舊身障手冊
ICF身障証明
長照
長照專用:是否有手冊
無
有