예제 #1
0
<?php

define('IN_TG', true);
define('ACCESS', true);
include dirname(__FILE__) . '/../configs/configs.php';
require_once $GLOBALS["rootPath"] . '/includes/function.php';
$date = date('Y-m-d H:i:s', time());
$sql = "SELECT max(staffId) as maxid FROM letsgo_staff";
$ret = _query_one_assoc($sql);
$newstaffid = $ret["maxid"] + 1;
$sql = "INSERT INTO letsgo_staff (staffId,roleType,email,password,name,gender,telephone,birth,nativePlace,qq,college,campus,academy,major,registerTime,level) VALUES ('" . $newstaffid . "', 'level0' ,'" . $_POST["email"] . "','" . md5($_POST["password"]) . "','" . $_POST["name"] . "','" . $_POST["gender"] . "','" . $_POST["tel"] . "','" . $_POST["birth"] . "','" . $_POST["nativePlace"] . "','" . $_POST["qq"] . "','" . $_POST["college"] . "','" . $_POST["campus"] . "','" . $_POST["academy"] . "','" . $_POST["major"] . "','" . $date . "','0.4')";
$ret = _mysql_exec($sql);
if (1 == $ret) {
    echo json_encode(array("result" => "0", "data" => array("name" => $_POST["name"], "staffid" => $newstaffid)));
} else {
    echo json_encode(array("result" => "1000", "msg" => "Insert Error"));
}
예제 #2
0
/**
 * 添加退货信息函数
 * @param unknown $bookflowid
 * @param unknown $count
 */
function _set_tuihuo($recordid, $count)
{
    $date = date('Y-m-d H:i:s', time());
    $sql = "INSERT INTO s_supplier_bookflow (record_id,count,staff_id,type,status,datetime) VALUES (" . $recordid . "," . $count . "," . $_COOKIE['staffid'] . ",1,1,'" . $date . "')";
    _mysql_exec($sql);
}
예제 #3
0
function write_data2db($bookinfo, $supplier_id, $place, $date, $order)
{
    $sql = "INSERT INTO s_supplier_record (supplier_id,book_name,book_press,book_price,book_count,book_discount,book_off,book_isbn,place,`type`,`date`,`order`,`status`) VALUES ('" . $supplier_id . "','" . $bookinfo['name'] . "','" . $bookinfo['press'] . "','" . $bookinfo['price'] . "','" . $bookinfo['count'] . "','0.7','0.78','" . $bookinfo['ISBN'] . "','" . $place . "','0','" . $date . "','" . $order . "','0')";
    _mysql_exec($sql);
}