function create_transaction($conn, $commodity_ary) { include_once 'class/DBadder.php'; include_once 'class/Config_transaction.php'; include_once 'class/Config_commodity.php'; include_once 'class/commodity/Transaction_state_config.php'; include_once 'class/commodity/Commodity_type_Config.php'; $buyer = -1; $holder = -1; $commodity_acceptor_id = $_SESSION['CURRENT_LOGIN_ID']; if ($commodity_ary[Config_commodity::course_or_reward] == Commodity_type_Config::course) { $holder = $commodity_ary[Config_commodity::publisher]; $buyer = $commodity_acceptor_id; } else { $buyer = $commodity_ary[Config_commodity::publisher]; $holder = $commodity_acceptor_id; } $transaction_ary = array(Config_transaction::choosed_id => $commodity_ary[Config_commodity::id], Config_transaction::state => Transaction_state_config::one_want_accept, Config_transaction::commodity_buyer_id => $buyer, Config_transaction::commodity_holder_id => $holder, Config_transaction::price => $commodity_ary[Config_commodity::price], Config_transaction::date_choose => date('Y-m-d H:i:s', time()), Config_transaction::date_confirm => date('Y-m-d H:i:s', 0), Config_transaction::pay_id => substr(md5(time()), 0, 8), Config_transaction::course_or_reward => $commodity_ary[Config_commodity::course_or_reward]); $adder = new DBadder(Config_transaction::table_name, $transaction_ary); $adder->excute($conn); require_once 'class/Config_budget.php'; $budget_ary = array(Config_budget::pay_date => date('Y-m-d H:i:s', time()), Config_budget::transaction_id => mysqli_insert_id($conn)); $adder = new DBadder(Config_budget::table_name, $budget_ary); $adder->excute($conn); }
/** * 前置: 必须满足已经判断确定用户已经登陆 * @param unknown $conn 数据库连接 */ function add_message_to_DB($conn, $commodity_id) { require_once 'class/DBadder.php'; require_once 'class/Config_leave_message.php'; require_once 'class/Config.php'; require_once 'class/Injection.php'; $talker_id = $_SESSION['CURRENT_LOGIN_ID']; $talker_content = Injection::excute('content'); $array = array(Config_leave_message::commodity_id => $commodity_id, Config_leave_message::content => $talker_content, Config_leave_message::talker => $talker_id, Config_leave_message::time => date('Y-m-d H:i:s', time())); $DBadder = new DBadder(Config_leave_message::tbl_name, $array); return $DBadder->excute($conn); }
function create_transaction($conn, $commodity_ary) { include_once 'class/DBadder.php'; include_once 'class/Config_transaction.php'; include_once 'class/Config_commodity.php'; include_once 'class/commodity/Transaction_state_config.php'; include_once 'class/commodity/Commodity_type_Config.php'; $buyer = -1; $holder = -1; $commodity_acceptor_id = Injection::excute('commodity_acceptor_id'); if ($commodity_ary[Config_commodity::course_or_reward] == Commodity_type_Config::course) { $holder = $commodity_ary[Config_commodity::publisher]; $buyer = $commodity_acceptor_id; } else { $buyer = $commodity_ary[Config_commodity::publisher]; $holder = $commodity_acceptor_id; } $myary = array(Config_transaction::choosed_id => $commodity_ary[Config_commodity::id], Config_transaction::state => Transaction_state_config::acceptor_comfirmed, Config_transaction::commodity_buyer_id => $buyer, Config_transaction::commodity_holder_id => $holder, Config_transaction::price => $this->commodity_ary[Config_commodity::price], Config_transaction::date_choose => date('Y-m-d H:i:s', time()), Config_transaction::date_confirm => date('Y-m-d H:i:s', 0), Config_transaction::pay_id => substr(md5(time()), 0, 8), Config_transaction::course_or_reward => $commodity_ary[Config_commodity::course_or_reward]); $adder = new DBadder(Config_transaction::table_name, $myary); return $adder->excute($conn); }
function evaluate() { require_once 'class/Injection.php'; require_once 'class/Config_evaluation.php'; require_once 'class/DBtraverser.php'; require_once 'class/Config.php'; require_once 'class/Config_transaction.php'; include 'smarty_init.php'; $content = ''; // $content = Injection::excute('content'); //评价内容 $transaction_id = (int) $_REQUEST['transaction_id']; //评价交易单 $evaluater_id = $_SESSION['CURRENT_LOGIN_ID']; //评价人ID $score1 = $_REQUEST['score1']; $score2 = $_REQUEST['score2']; $score3 = $_REQUEST['score3']; $score = 10; $conn = Config::connect(); //判断订单是否已经存在 $trasaction_DBtraveser = new DBtraverser(Config_transaction::table_name, ' where ' . Config_transaction::id . ' = ' . "'" . $transaction_id . "'"); $transaction_retval = $trasaction_DBtraveser->excute($conn); $transaction_array = mysqli_fetch_array($transaction_retval, MYSQLI_ASSOC); if ($transaction_array) { $is_payer = $transaction_array[Config_transaction::commodity_buyer_id] == $evaluater_id ? 1 : 0; require_once 'class/Config_transaction.php'; $evaluation_DBtraveser = new DBtraverser(Config_evaluation::tbl_name, ' where ' . Config_evaluation::commodity_id . ' = ' . "'" . $transaction_array[Config_transaction::choosed_id] . "'" . 'AND' . Config_evaluation::is_payer . ' = ' . "'" . $is_payer . "'"); if (!mysqli_fetch_array($evaluation_DBtraveser->excute($conn))) { $evaluated = $transaction_array[Config_transaction::commodity_buyer_id] == $evaluater_id ? $transaction_array[Config_transaction::commodity_holder_id] : $transaction_array[Config_transaction::commodity_buyer_id]; $ary = array(Config_evaluation::evaluate_time => date('Y-m-d H:i:s', time()), Config_evaluation::evaluation => $content, Config_evaluation::is_payer => $is_payer, Config_evaluation::score1 => $score1, Config_evaluation::score2 => $score2, Config_evaluation::score3 => $score3, Config_evaluation::score => $score, Config_evaluation::commodity_id => $transaction_array[Config_transaction::choosed_id], Config_evaluation::valuator => $evaluater_id, Config_evaluation::valuated => $evaluated); $DBadder = new DBadder(Config_evaluation::tbl_name, $ary); $DBadder->excute($conn); echo "<script language='javascript'> alert('done!');\r\n window.history.go(-1);\r\n </script>"; } else { } } else { } mysqli_free_result($transaction_retval); mysqli_close($conn); }
//$_SESSION['CURRENT_LOGIN_ID'] =1; if (isset($_SESSION['CURRENT_LOGIN_ID'])) { require_once 'class/Config.php'; $commodity_id = (int) $_GET['id']; $conn = Config::connect(); //判断是否已赞 require_once 'Inlcude_is_praised.php'; if (!is_praised($conn, $commodity_id, $_SESSION['CURRENT_LOGIN_ID'])) { require_once 'class/DBincrement.php'; require_once 'class/Config_commodity.php'; require_once 'class/DBadder.php'; require_once 'class/Config_praise.php'; //在数据库里面加 $ary = array(Config_praise::commodity_id => $commodity_id, Config_praise::praiser_id => $_SESSION['CURRENT_LOGIN_ID']); $DBadder = new DBadder(Config_praise::tbl_name, $ary); $DBadder->excute($conn); //更新商品被赞数 $DBincrement = new DBincrement(Config_commodity::table_name, Config_commodity::praise, ' where ' . Config_commodity::id . ' = ' . "'" . $commodity_id . "'"); $DBincrement->excute($conn); header("Location:Commodity_details.php?id={$commodity_id}"); } else { echo "<script language='javascript'> alert('praised!');\r\n window.history.go(-1);\r\n </script>"; } } else { include 'Login.php'; } /* function add_praise($conn,$commodity_id) { $ary = array( Config_praise::commodity_id => $commodity_id, Config_praise::praiser_id => $_SESSION['CURRENT_LOGIN_ID']