/** * 返回国家列表 * @access public */ function index() { $country = get_post_value('country'); $region = get_post_value('region'); $province = get_post_value('province'); $city = get_post_value('city'); $field = array('country.country_id', 'country.country', 'region.region_id', 'region.region', 'province.province_id', 'province.province', 'city.city_id', 'city.city', 'city.status', 'city.orders'); // 排序方法2 $orderby = array('country.orders', 'region.orders', 'province.orders'); $m = new Address(); $m->clear(); $m->setField($field); $m->setWhere('country.status', '!=', '50000'); $m->setWhere('region.status', '!=', '50000'); $m->setWhere('province.status', '!=', '50000'); $m->setWhere('city.status', '!=', '50000'); if ($country != '') { $m->setWhere('country.country_id', '=', $country); } if ($region != '') { $m->setWhere('region.region_id', '=', $region); } if ($province != '') { $m->setWhere('province.province_id', '=', $province); } if ($city != '') { $m->setWhere('city.city', 'LIKE', '%' . $city . '%'); } $m->setTable('vcb_address_country AS country'); $m->setJoin('vcb_address_region as region', 'country.country_id=region.country_id'); $m->setJoin('vcb_address_province as province', 'region.region_id=province.region_id'); $m->setJoin('vcb_address_city as city', 'province.province_id=city.province_id'); $m->setOrderBy($orderby); $count = $m->getRowsCount(); //合计计录数 //分页其他参数 $page = new Page($count); $parameter = array('country' => get_post_value('country')); $page->setParameter($parameter); $showPage = $page->showPage(); $showTotal = $page->showTotal(); $m->setPage(get_current_page()); $data = $m->select(); //状态标题 $count = count($data); for ($i = 0; $i < $count; $i++) { $status = $data[$i]['status']; $data[$i]['status_name'] = $m->getStatus($status); } $this->assign('data', $data); //输出数据 $this->assign('showPage', $showPage); //输出分页 $this->assign('showTotal', $showTotal); //输出分页合计 $r = $m->getRegion($country); $this->assign('region', $r); $p = $m->getProvince($region); $this->assign('province', $p); }
/** * 返回国家列表 * @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); }
/** * 返回国家列表 * @access public */ function index() { $floor_1 = get_post_value('floor_1'); $floor_2 = get_post_value('floor_2'); $floor_3 = get_post_value('floor_3'); $field = array('floor_2.floor_1_id', 'floor_2.floor_2_id', 'floor_2.floor_2_cn', 'floor_2.floor_2_th', 'floor_3.floor_3_id', 'floor_3.floor_3_cn', 'floor_3.floor_3_th', 'floor_3.orders', 'floor_3.status', 'floor_3.created', 'floor_3.created_name', 'floor_3.audit_name', 'floor_3.start_time', 'floor_3.end_time'); $m = new Floor(); $m->clear(); $m->setField($field); $m->setTable('vcb_product_floor_3 AS floor_3'); $m->setJoin('vcb_product_floor_2 as floor_2', 'floor_2.floor_2_id=floor_3.floor_2_id'); $m->setWhere('floor_3.status', '!=', '60000'); if ($floor_1 != '') { $m->setWhere('floor_3.floor_1_id', '=', $floor_1); } if ($floor_2 != '') { $m->setWhere('floor_3.floor_2_id', '=', $floor_2); } if ($floor_2 != '') { $m->setWhere('floor_3.floor_3_cn', 'LIKE', '%' . $floor_3 . '%', 'AND', '('); $m->setWhere('floor_3.floor_3_th', 'LIKE', '%' . $floor_3 . '%', 'OR', ')'); } $m->setOrderBy(array('floor_2.orders' => 'ASC', 'floor_3.orders' => 'ASC')); $count = $m->getRowsCount(); $page = new Page($count); $parameter = array('floor_1' => $floor_1, 'floor_2' => $floor_2, 'floor_3' => $floor_3); $page->setParameter($parameter); $showPage = $page->showPage(); $showTotal = $page->showTotal(); $m->setPage(); /*$page->setListRows(5); $m->setLimit($page->listRows);*/ $data = $m->select(); //状态标题 $count = count($data); for ($i = 0; $i < $count; $i++) { $status = $data[$i]['status']; $data[$i]['status_cn'] = $m->getStatus('cn', $status); $data[$i]['status_th'] = $m->getStatus('th', $status); $data[$i]['floor_1'] = $m->getFloor_1($data[$i]['floor_1_id']); } $this->assign('data', $data); $this->assign('showPage', $showPage); //输出分页 $this->assign('showTotal', $showTotal); //输出分页合计 if ($floor_1 != '') { $c_2 = $m->getFloor_2($floor_1); $this->assign('floor_2', $c_2); } else { $this->assign('floor_2', array()); } }
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); }
/** * 返回国家列表 * @access public */ function index() { $category_1 = get_post_value('category_1'); $category_2 = get_post_value('category_2'); $field = array('category_1_id', 'category_2_id', 'category_2_cn', 'category_2_th', 'orders', 'status', 'created', 'created_name', 'audit_name'); $m = new Category(); $m->clear(); $m->setField($field); $m->setTable('vcb_product_category_2'); $m->setWhere('status', '!=', '60000'); if ($category_1 != '') { $m->setWhere('category_1_id', '=', $category_1); } if ($category_2 != '') { $m->setWhere('category_2_cn', 'LIKE', '%' . $category_2 . '%', 'AND', '('); $m->setWhere('category_2_th', 'LIKE', '%' . $category_2 . '%', 'OR', ')'); } $m->setOrderBy('orders'); $count = $m->getRowsCount(); $page = new Page($count); $parameter = array('category_1' => $category_1, 'category_2' => $category_2); $page->setParameter($parameter); $showPage = $page->showPage(); $showTotal = $page->showTotal(); $m->setPage(); $data = $m->select(); //状态标题 $count = count($data); for ($i = 0; $i < $count; $i++) { $status = $data[$i]['status']; $data[$i]['status_cn'] = $m->getStatus('cn', $status); $data[$i]['status_th'] = $m->getStatus('th', $status); $data[$i]['category_1'] = $m->getCategory_1($data[$i]['category_1_id']); } $this->assign('data', $data); $this->assign('showPage', $showPage); //输出分页 $this->assign('showTotal', $showTotal); //输出分页合计 }
public function add_issue() { $id = get_post_value('id'); $field = array('id', 'title'); $m = new Survey(); $m->clear(); $m->setField($field); $m->setTable('vcb_survey'); $m->setWhere('id', '=', $id); $data = $m->select(); //var_dump($data); if (!empty($data)) { $field1 = array('issue.id', 'issue.survey_id', 'issue.issue', 'item.item', 'item.status', 'item.issue_id', 'issue.issue_type', 'issue.status'); $m1 = new Survey(); $m1->clear(); $m1->setField($field1); $m1->setTable('vcb_survey_issue AS issue'); $m1->setJoin('vcb_survey_item as item', 'issue.id=item.issue_id', 'left join'); $m1->setWhere('issue.issue_type', '=', '10000'); $m1->setWhere('issue.survey_id', '=', $id); $m1->setWhere('issue.status', '!=', '60000'); $count = $m1->getRowsCount(); $page = new Page($count); $parameter = array(); $page->setParameter($parameter); $showPage = $page->showPage(); $showTotal = $page->showTotal(); $data_issue = $m1->select(); // var_dump($data_issue); $this->assign('showPage', $showPage); //输出分页 $this->assign('showTotal', $showTotal); $this->assign('data', $data); $this->assign('data_issue', $data_issue); //多项 $field2 = array('issue.id', 'issue.survey_id', 'issue.issue', 'item.item', 'item.status', 'item.issue_id', 'issue.issue_type'); $m2 = new Survey(); $m2->clear(); $m2->setField($field1); $m2->setTable('vcb_survey_issue AS issue'); $m2->setJoin('vcb_survey_item as item', 'issue.id=item.issue_id', 'left join'); $m2->setWhere('issue.issue_type', '=', '20000'); $m2->setWhere('issue.survey_id', '=', $id); $count2 = $m2->getRowsCount(); $page2 = new Page($count2); $parameter2 = array(); $page2->setParameter($parameter2); $showPage2 = $page2->showPage(); $showTotal2 = $page2->showTotal(); $data_issue2 = $m2->select(); //var_dump($data_issue2); $this->assign('showPage2', $showPage); //输出分页 $this->assign('showTotal2', $showTotal); $this->assign('data_issue2', $data_issue2); } else { header("Location:error"); } }
<table id="InformationTable" > <tr class="tableTitle"> <th width="10%" >序号</th> <th width="60%" >信息</th> <th width="20%">来源</th> </tr> <?php include './newsComp.php'; /*获取数据库中数据条数*/ $gettocount = mysql_query("SELECT * FROM quotes"); //$count=count($temp);或者$count=mysql_num_rows($result); $count = mysql_num_rows($gettocount); $temp = mysql_fetch_array($gettocount); //echo $count; $page = new Page($count, 17); echo $page->showPage(); //session_start(); ?> <?php if (isAdministrator()) { print "<a href=\"add_quote.php?id={$row['quote_id']}\" >添加</a> <a href=\"view_quote.php?id={$row['quote_id']}\">操作列表</a>"; } else { //print"<p>未找到</p>"; } ?> </div><!--newss--> </div><!--news--> <?php include './footer.php'; ?>
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); }