Example #1
0
 /**
  * 返回国家列表
  * @access public
  */
 function index()
 {
     $key = strtolower(get_post_value('key'));
     $field = array('product_url', 'title_cn', 'title_th', 'category_3_id', 'floor_3_id', 'image_url', 'product_url', 'shop', 'shop_id', 'shop_url', 'product_id', 'status', 'category_1_id', 'sales_price');
     $m = new Products();
     $m->clear();
     $m->setTable('vcb_product');
     //设置表名
     $m->setField($field);
     $m->setWhere('title_cn', 'LIKE', '%' . $key . '%', 'and', '(');
     $m->setWhere('title_th', 'LIKE', '%' . $key . '%', 'or');
     $m->setWhere('shop', 'LIKE', '%' . $key . '%', 'or', ')');
     $count = $m->getRowsCount();
     //var_dump($count);
     $page = new Page($count, 5);
     $parameter = array();
     $page->setParameter($parameter);
     $showPage = $page->showPage();
     $showTotal = $page->showTotal();
     /*var_dump($showPage);
     		var_dump($showTotal);*/
     $m->setPage();
     $page->setListRows(5);
     $m->setLimit($page->listRows);
     $data = $m->select();
     $this->assign('data', $data);
     $this->assign('key', $key);
     $this->assign('showPage', $showPage);
     //输出分页
     $this->assign('showTotal', $showTotal);
 }
Example #2
0
 function index()
 {
     if (!Login::verifyLogin()) {
         header("Location: ../../home/login/index");
         exit;
     }
     $user_id = "";
     if (isset($_SESSION['user_id'])) {
         $user_id = $_SESSION['user_id'];
         if (!empty($user_id)) {
             $user_data = Login::verify_login($user_id);
             if (!empty($user_data)) {
                 // var_dump($user_data);
                 $this->assign('user_data', $user_data);
             }
         }
     }
     $m_order = new Orders();
     $field = array('ord.id', 'ord.order_no', 'ord.created', 'ord.status', 'ord.product_id', 'ord.qty', 'ord.freight', 'pr.product_url', 'pr.title_cn', 'pr.title_th', 'pr.category_3_id', 'pr.floor_3_id', 'pr.image_url', 'pr.product_url', 'pr.shop', 'pr.shop_id', 'pr.shop_url', 'pr.product_id', 'pr.status', 'pr.category_1_id', 'pr.sales_price');
     $m_order->clear();
     $m_order->setField($field);
     $m_order->setTable(' vcb_order as ord');
     $m_order->setJoin(' vcb_product as pr ', 'ord.product_id=pr.product_id');
     $count = $m_order->getRowsCount();
     //var_dump($count);
     $page = new Page($count, 5);
     $parameter = array();
     $page->setParameter($parameter);
     $showPage = $page->showPage();
     $showTotal = $page->showTotal();
     //var_dump($showPage);
     //var_dump($showTotal);
     $m_order->setPage();
     $page->setListRows(5);
     $m_order->setWhere('ord.user_id', '=', $user_id);
     $m_order->setWhere('ord.status', '!=', 60000);
     $m_order->setLimit($page->listRows);
     $order_data = $m_order->select();
     //	var_dump($order_data);
     /* $product_data = array();
               $m_product = new products();
               for($i = 0;$i<count($order_data);$i++){
     
               $product_data[$i] = $m_product->getproducts_id($order_data[$i]['product_id']);
     
               } */
     //var_dump($product_data);
     $this->assign('order_data', $order_data);
     $this->assign('showPage', $showPage);
     $this->assign('showTotal', $showTotal);
     //$this->assign('pro_data', $product_data);
 }
Example #3
0
 function get_orders()
 {
     $id = get_post_value("id");
     $order = get_post_value('order');
     $field = array('product_url', 'title_cn', 'title_th', 'category_3_id', 'floor_3_id', 'purchase_price', 'image_url', 'sales_price', 'product_url', 'shop', 'shop_id', 'shop_url', 'product_id', 'status', 'buys', 'category_1_id');
     $m = new Products();
     $m->clear();
     $m->setTable('vcb_product');
     //设置表名
     $m->setField($field);
     $count = $m->getRowsCount();
     //var_dump($count);
     $page = new Page($count, 2);
     $parameter = array();
     $page->setParameter($parameter);
     $showPage = $page->showPage();
     $showTotal = $page->showTotal();
     //var_dump($showPage);
     //var_dump($showTotal);
     $m->setPage();
     $page->setListRows(2);
     $m->setWhere('category_1_id', '=', $id);
     $m->setLimit($page->listRows);
     $m->setOrderBy(array($order => 'DESC'));
     $data = $m->select();
     $this->assign('data', $data);
 }