Beispiel #1
0
 function init()
 {
     $tmsql = new phpMysql_h();
     $tmsql->init();
     $str = "SELECT * FROM {$tmsql->system} ";
     $tmsql->query($str);
     list($tserial, $tgomark, $tpictext1, $tpictext2, $tpictext3) = mysql_fetch_row($tmsql->listmysql);
     $tmsql->close_mysql();
     $this->tn_serial = $tserial;
     $this->tn_gomark = $tgomark;
     $this->tn_pictext1 = $tpictext1;
     $this->tn_pictext2 = $tpictext2;
     $this->tn_pictext3 = $tpictext3;
 }
     exit;
 } elseif ($act == "doSpeedMatch") {
     $ps = " WHERE id={$aid} ";
     $row = loaddata_row($dbTable['application'][$cateid], $ps);
     // 	$year = substr($row['deadline'],0,4);
     // 	$month = substr($row['deadline'],5,2);
     // 	$day = substr($row['deadline'],8,2);
     // 	$hour = substr($row['deadline'],11,2);
     // 	$min = substr($row['deadline'],14,2);
     // 	$sec = substr($row['deadline'],17,2);
     // 	$deadline2 = date("Y-m-d H:i:s",mktime($hour, $min, $sec, $month, $day+7, $year));
     $msql = new phpMysql_h();
     $msql->init();
     $sql = "UPDATE " . $dbTable['application'][$cateid] . " SET status='2' , isSpeedMatch='1' , speedmatchTime=NOW() WHERE id={$aid} ";
     // 	$sql = "UPDATE ".$dbTable['application'][$cateid]." SET isSpeedMatch='1' , speedmatchTime=NOW() WHERE id=$aid ";
     $msql->query($sql);
     $ps = " WHERE isSpeedMatch='1' AND speedmatchTime!='' AND id=" . $aid;
     $row = loaddata_row($dbTable['application'][$cateid], $ps);
     if ($row) {
         echo "OK";
         //已完成快速服務設定
     } else {
         echo "NOT";
         //快速服務設定失敗
     }
     exit;
 } elseif ($act == "getLastDesc") {
     $ps = " WHERE id={$aid} ";
     $row = loaddata_row($dbTable['application'][$cateid], $ps);
 } elseif ($act == "setSession") {
     if (!$_SESSION[$name]) {
if (!$_SESSION) {
    session_start();
}
// ini_set('default_charset', 'utf-8');
//--- 讀入基本設定
include "function/function.php";
require 'libs/Smarty.class.php';
include "base_config.php";
// include ADMINROOT."/getfile.php";
$msql = new phpMysql_h();
$tool = new tools_h();
$sql = "SELECT id FROM `wwd_application_speedmatch` WHERE applyid='" . $aid . "' AND cateid='" . $cateid . "' ";
// echo "<br>sql=".$sql; exit;
$msql->init();
$msql->query($sql);
if (list($id) = mysql_fetch_row($msql->listmysql)) {
    $tool->showmessage("此需求單已送過快速服務申請,請勿重複操作或聯繫客服人員確認!");
    $tool->goURL2("parent", "member_client_myneeds01.php");
    exit;
}
$hash = uniqid(mt_srand((double) microtime() * 1000000));
$sql = "INSERT INTO `wwd_application_speedmatch` (`hash`,`cateid` ,`applyid` ,`serial` ,`firstname` ,`sex` ,`mobile` ,`contactable` ,`office_city` ,\n\t\t`office_area` ,`isSeen` ,`SheetBuyPlace` ,`buySelf` ,`creator` ,`createdtime`) VALUES ('{$hash}', '{$cateid}',  '{$aid}',  '{$serial}',  '{$firstname}',  \n\t\t'{$sex}',  '{$mobile}',  '{$contactable}',  '{$office_city}',  '{$office_area}',  '{$isSeen}',  '{$SheetBuyPlace}',  '{$buySelf}',  '" . $_COOKIE[user_id] . "',  \n\t\tNOW());";
// error_log($sql."\r\n\r\n",3,"log_fast_do_sql.log");
$msql->init();
$msql->query($sql);
$sql2 = "SELECT id FROM `wwd_application_speedmatch` WHERE hash='" . $hash . "' ";
$msql->init();
$msql->query($sql2);
if (list($id2) = mysql_fetch_row($msql->listmysql)) {
    if ($_COOKIE[user_email] != "*****@*****.**") {