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); }
/** * */ function register() { include_once 'class/DBadder.php'; $myDBadder = new DBadder(Config_user::table_name, $this->ary); if ($myDBadder->excute_without_conn()) { return false; } else { return true; } }
/** * 前置: 必须满足已经判断确定用户已经登陆 * @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); }
/** * 不区分商品类别, 悬赏还是课程 */ public function excute() { $path = dirname(dirname(__FILE__)); include_once $path . '/DBadder.php'; include_once $path . '/Config_commodity.php'; $myDBadder = new DBadder(Config_commodity::table_name, $this->ary); if ($myDBadder->excuteWithoutConn()) { return true; } else { return false; } }
/** * */ public function register() { $path = dirname(dirname(__FILE__)); include_once $path . '/DBadder.php'; include_once $path . '/Config_user.php'; include_once 'ResultReturn.php'; $myDBadder = new DBadder(Config_user::table_name, $this->ary); if ($myDBadder->excute_without_conn()) { return ResultReturn::register_pass; } else { return ResultReturn::register_failed; } }
private function add_transaction_in_DB() { $path = dirname(dirname(__FILE__)); include_once $path . '/DBadder.php'; include_once $path . '/Config_transaction.php'; include_once $path . '/Config_commodity.php'; include_once 'Transaction_state_config.php'; include_once 'Commodity_type_Config.php'; $buyer = -1; $holder = -1; if ($this->commodity_ary[Config_commodity::type] == Commodity_type_Config::course) { $holder = $this->commodity_ary[Config_commodity::publisher]; $buyer = $this->commodity_acceptor_id; } else { $buyer = $this->commodity_ary[Config_commodity::publisher]; $holder = $this->commodity_acceptor_id; } $myary = array(Config_transaction::choosed_id => $this->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 => $this->generate_pay_id()); $adder = new DBadder(Config_transaction::table_name, $myary); $adder->excute_without_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_start(); //$_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,
* @param string $username */ function is_username_exist($username) { include_once 'class/DBtraverser.php'; include_once 'class/Config.php'; include_once 'class/Config_user.php'; include_once 'class/DBcount.php'; $ary = ' where ' . Config_user::log_name . " = '{$username}' "; $myDBcount = new DBcount(Config_user::table_name, $ary); $retval = $myDBcount->excute_without_conn(); $row = mysqli_fetch_array($retval, MYSQLI_NUM); return $row ? $row[0] : 0; } if (isset($_POST['reg'])) { require_once 'class/Injection.php'; $name = Injection::excute('username'); $pwd = Injection::excute('pwd'); $phone = Injection::excute('phone'); $register_user = array(Config_user::is_seller => 1, Config_user::create_time => date('Y-m-d H:i:s', time()), Config_user::last_log => date('Y-m-d H:i:s', time()), Config_user::phone_number => $phone, Config_user::seller_credit => 5, Config_user::payer_credit => 5, Config_user::log_name => $name, Config_user::password => $pwd, Config_user::pic_path => 'avatar.jpg'); if (is_username_exist($name)) { } else { include_once 'class/DBadder.php'; $myDBadder = new DBadder(Config_user::table_name, $register_user); if ($myDBadder->excute_without_conn()) { $smarty->display("Login&Register/Login.html"); } } } else { $smarty->display("Login&Register/Register.html"); }