function wa_payment_complete($id)
 {
     require_once WA_PLUGIN_DIR . '/includes/class-wa-db.php';
     $db = new WA_Db();
     $params = array("tableName" => "wa_product_orders", "arrItems" => array("order_id" => $id, "date" => date('Y/m/d H:i:s'), "status" => 0));
     $db->insert($params);
     echo "success.";
 }
 static function create_list_page_get_limit_post($arr_query, $post_per_page)
 {
     $current_page = isset($_GET['paged']) ? $_GET['paged'] : 1;
     $arr_query['limit'] = array("start" => $post_per_page * $current_page - $post_per_page, "count" => $post_per_page);
     $db = new WA_Db();
     $orders = $db->fetch($arr_query);
     return $orders;
 }
Example #3
0
 function wa_mails_user_bid($product_id)
 {
     require_once WA_PLUGIN_DIR . '/includes/class-wa-db.php';
     $users = array();
     $db = new WA_Db();
     $arr_query = array("tableName" => "wa_product_bids AS a", "select" => "b.ID, a.price", "join" => array(array("tableName" => "users AS b", "on" => "b.id = a.user_id")), "where" => "a.product_id = " . $product_id, "groupByField" => "a.user_id");
     $bid_users = $db->fetch($arr_query);
     if (count($bid_users) > 0) {
         foreach ($bid_users as $user) {
             array_push($users, array('user_id' => $user['ID'], 'price' => $user['price']));
         }
     }
     return $users;
 }
Example #4
0
 function count_bid_by_productid($pID)
 {
     require_once WA_PLUGIN_DIR . '/includes/class-wa-db.php';
     $db = new WA_Db();
     $arr_query = array("tableName" => "wa_product_bids", "select" => "count(id) AS count", "where" => "product_id = " . $pID);
     $bid = $db->fetch($arr_query);
     return $bid[0]['count'];
 }