/**
* 返回国家列表
* @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);
}
