public function show()
{
//if (!$this->QX[$this->get['open']][$this->get['action']]) $this->fun->Msg('你没有此权限');
if (is_numeric($this->get['weight'])) {
$this->default_value();
$start = (double) $this->get['weight'] / 10;
$stop = $start + 0.09;
switch ($this->get['weight']) {
case '03':
$weight = "and weight<={$stop}";
break;
case '010':
$weight = "and weight>={$start}";
break;
default:
$weight = "and weight>={$start} and weight<={$stop}";
}
$this->get['px'] = $this->get['px'] ? $this->get['px'] : 'agio';
$this->get['orders'] = $this->get['orders'] ? $this->get['orders'] : 'asc';
$ORDER = $this->get['px'] . ' ' . $this->get['orders'];
$this->sma->assign('get', $this->get);
$promotion_dot = $_SESSION['proxy']['is_offer'] == 'Y' ? 'promotion_dot' : $_SESSION['proxy']['rebate'];
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = 50;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select id,ProID,shape,weight,color,clarity,cut,buffing,symmetry,Fent_Isity,scalar_value,diploma,diplomaNO,INTbid,(agio+baseAgio+{$promotion_dot}) as agio from product where status='up' {$weight} and amount>0 and is_promotion='Y' and promotion_start<=UNIX_TIMESTAMP() and promotion_stop>=UNIX_TIMESTAMP() order by {$ORDER}";
//$list->SQL = "select id,ProID,shape,weight,color,clarity,cut,buffing,symmetry,Fent_Isity,scalar_value,diploma,diplomaNO,INTbid,(agio+baseAgio+{$promotion_dot}) as agio from product where status='up' {$weight} and amount>0 and proSource='self' order by {$ORDER}";
$this->sma->assign('list_page', $list->getPage(true));
$this->sma->assign('list_text', $list->getText());
} else {
$this->default_value();
//$start = (float)$this->get['weight'] / 10;
//$stop = $start + 0.09;
//switch($this->get['weight'])
//{
// case '03':$weight = "and weight<={$stop}";break;
// case '010':$weight = "and weight>={$start}";break;
// default:$weight = "and weight>={$start} and weight<={$stop}";
//}
$weight = "and weight>=0.3";
$this->get['px'] = $this->get['px'] ? $this->get['px'] : 'agio';
$this->get['orders'] = $this->get['orders'] ? $this->get['orders'] : 'asc';
$ORDER = $this->get['px'] . ' ' . $this->get['orders'];
$this->sma->assign('get', $this->get);
$promotion_dot = $_SESSION['proxy']['is_offer'] == 'Y' ? 'promotion_dot' : $_SESSION['proxy']['rebate'];
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = 50;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select id,ProID,shape,weight,color,clarity,cut,buffing,symmetry,Fent_Isity,scalar_value,diploma,diplomaNO,INTbid,(agio+baseAgio+{$promotion_dot}) as agio from product where status='up' {$weight} and amount>0 and is_promotion='Y' and promotion_start<=UNIX_TIMESTAMP() and promotion_stop>=UNIX_TIMESTAMP() order by {$ORDER}";
//$list->SQL = "select id,ProID,shape,weight,color,clarity,cut,buffing,symmetry,Fent_Isity,scalar_value,diploma,diplomaNO,INTbid,(agio+baseAgio+{$promotion_dot}) as agio from product where status='up' {$weight} and amount>0 and proSource='self' order by {$ORDER}";
$this->sma->assign('list_page', $list->getPage(true));
$this->sma->assign('list_text', $list->getText());
}
$this->sma->display('SP');
}
public function show()
{
//if (!$this->QX[$this->get['open']][$this->get['action']]) $this->fun->Msg('你没有此权限');
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = 5;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select id,title,uptime,bewrite from news where is_view='Y' order by taxis desc";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
$this->sma->display('news_list');
}
public function show()
{
$ORDER = array('time_UP' => 'time asc', 'time_Dn' => 'time desc', 'open_UP' => 'open asc', 'open_Dn' => 'open desc');
$this->get['ORDER'] = $ors = $this->get['ORDER'] ? $this->get['ORDER'] : 'open_Dn';
$this->sma->assign('get', $this->get);
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select * from purview order by {$ORDER[$ors]}";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
$this->sma->display($this->get['open']);
}
public function log()
{
if (!$this->BTP[$this->get['open']][$this->get['action']]) {
$this->fun->Msg($this->BTP_Words);
}
$ORDER = array('time_UP' => 'log.year asc,log.month asc', 'time_Dn' => 'log.year desc,log.month desc');
$this->get['ORDER'] = $ors = $this->get['ORDER'] ? $this->get['ORDER'] : 'time_Dn';
$this->sma->assign('get', $this->get);
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['PNS']) ? $this->get['PNS'] : 14;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select log.*,a.name from api_log as log join api_user as a on a.key=log.api_key order by {$ORDER[$ors]}";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
$this->sma->display('API_log');
}
public function show()
{
if (!$this->BTP[$this->get['open']][$this->get['action']]) {
$this->fun->Msg($this->BTP_Words);
}
$ORDER = array('Wt_UP' => 'weight_start asc', 'Wt_Dn' => 'weight_start desc', 'Cy_UP' => 'clarity asc', 'Cy_Dn' => 'clarity desc', 'Cr_UP' => 'color asc', 'Cr_Dn' => 'color desc', 'Pe_UP' => 'price asc', 'Pe_Dn' => 'price desc');
$this->get['ORDER'] = $ors = $this->get['ORDER'] ? $this->get['ORDER'] : 'Wt_Dn';
$this->sma->assign('get', $this->get);
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['PNS']) ? $this->get['PNS'] : 14;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select * from bid order by {$ORDER[$ors]}";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
$this->sma->display($this->get['open']);
}
public function show()
{
if (!$this->BTP[$this->get['open']][$this->get['action']]) {
$this->fun->Msg($this->BTP_Words);
}
$ORDER = array('time_UP' => 'time asc', 'time_Dn' => 'time desc', 'name_UP' => 'title asc', 'name_Dn' => 'title desc');
$this->get['ORDER'] = $ors = $this->get['ORDER'] ? $this->get['ORDER'] : 'time_Dn';
$this->sma->assign('get', $this->get);
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['PNS']) ? $this->get['PNS'] : 14;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select id,title,taxis,uptime,is_view from news order by {$ORDER[$ors]}";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
$this->sma->display($this->get['open']);
}
public function appx_show()
{
if (!$this->BTP[$this->get['open']][$this->get['action']]) {
$this->fun->Msg($this->BTP_Words);
}
$this->_appendix_public();
$ORDER = array('time_UP' => 'time asc', 'time_Dn' => 'time desc', 'type_UP' => 'type asc', 'type_Dn' => 'type desc');
$this->get['ORDER'] = $ors = $this->get['ORDER'] ? $this->get['ORDER'] : 'time_Dn';
$this->sma->assign('get', $this->get);
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['PNS']) ? $this->get['PNS'] : 14;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select id,type,name,`into`,time from service_appendix where service_id='{$this->get['id']}' order by {$ORDER[$ors]}";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
$this->sma->display('service_appx_show');
}
public function show()
{
if (!$this->BTP[$this->get['open']][$this->get['action']]) {
$this->fun->Msg($this->BTP_Words);
}
$this->default_value();
$ORDER = array('time_UP' => 'o.time asc', 'time_Dn' => 'o.time desc', 'prxy_UP' => 'o.proxy_id asc', 'prxy_Dn' => 'o.proxy_id desc');
$this->get['ORDER'] = $ors = $this->get['ORDER'] ? $this->get['ORDER'] : 'time_Dn';
//查询
if ($this->get['go'] == 'query') {
$query = "and o.orders_id like '%{$this->get['info']}%' \n\t\t\t \tor p.account like '%{$this->get['info']}%' or p.name like '%{$this->get['info']}%' or p.number like '%{$this->get['info']}%'\n\t\t\t \tor s.account like '%{$this->get['info']}%' or s.name like '%{$this->get['info']}%' or s.number like '%{$this->get['info']}%'\n\t\t\t \tor ps.account like '%{$this->get['info']}%' or ps.name like '%{$this->get['info']}%' or ps.number like '%{$this->get['info']}%'\n\t\t\t \t";
}
//订单状态
switch ($this->get['status']) {
//下订单 -> 审核
case 'null':
$status = "and o.status is null";
break;
//通过审核
//通过审核
case 'audit':
$status = "and o.status='audit' and o.earnest is null";
break;
//通过审核 -> 付定金
//通过审核 -> 付定金
case 'earnest':
$status = "and o.status='earnest' and o.earnest>0 and o.gotten_money is null";
break;
//付定金 -> 调货
//付定金 -> 调货
case 'deploy':
$status = "and o.status='deploy' and o.earnest=o.gotten_money";
break;
//调货 -> 付余款
//调货 -> 付余款
case 'balance':
$status = "and o.status='balance' and o.earnest=o.gotten_money";
break;
//付余款 -> 发货
//付余款 -> 发货
case 'dispatch':
$status = "and o.status='dispatch' and o.price=o.gotten_money";
break;
//收到货物
//收到货物
case 'receiving':
$status = "and o.status='receiving'";
break;
//取消订单
//取消订单
case 'returned':
$status = "and o.status='returned'";
break;
}
$this->sma->assign('get', $this->get);
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['PNS']) ? $this->get['PNS'] : 14;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select o.proxy_id,o.orders_id,o.time,o.earnest,o.price,o.gotten_money,o.status,p.account,s.name as service_name,ps.name as salesman_name\n\t\t\t\t\t\t\tfrom orders as o join proxy as p on p.id=o.proxy_id\tjoin service as s on s.id=o.service_id \n\t\t\t\t\t\t\tjoin proxy as ps on ps.id=o.salesman_id where 1 {$query} {$status} order by {$ORDER[$ors]}";
$info = $list->getText();
if ($info) {
foreach ($info as $key => $val) {
$info[$key]['status'] = $this->get_status($val);
}
}
//print_r($info);
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $info);
$this->sma->display($this->get['open']);
}
public function show()
{
$user = $this->get_user();
if ($this->db->update('api_log', array('amount' => '+++1'), "api_key='{$this->get['key']}' and type='product' and year=EXTRACT(YEAR FROM CURDATE()) and month=EXTRACT(MONTH FROM CURDATE())") == false) {
$this->db->insert('api_log', array('api_key' => $this->get['key'], 'type' => 'product', 'year' => date('Y'), 'month' => date('m'), 'amount' => 1));
}
if ($this->get['shape']) {
$shape = "and shape in ('" . implode("','", explode(',', $this->get['shape'])) . "')";
}
if ($this->get['color']) {
$color = "and color in ('" . implode("','", explode(',', $this->get['color'])) . "')";
}
if ($this->get['clarity']) {
$clarity = "and clarity in ('" . implode("','", explode(',', $this->get['clarity'])) . "')";
}
if ($this->get['cut']) {
$cut = "and cut in ('" . implode("','", explode(',', $this->get['cut'])) . "')";
}
if ($this->get['polish']) {
$polish = "and buffing in ('" . implode("','", explode(',', $this->get['polish'])) . "')";
}
if ($this->get['symmetry']) {
$symmetry = "and symmetry in ('" . implode("','", explode(',', $this->get['symmetry'])) . "')";
}
if ($this->get['FLR']) {
$FLR = "and Fent_Isity in ('" . implode("','", explode(',', $this->get['FLR'])) . "')";
}
if ($this->get['cert']) {
$cert = "and diploma in ('" . implode("','", explode(',', $this->get['cert'])) . "')";
}
switch ($this->get['is_promotion']) {
case 'Y':
$is_promotion = "and is_promotion='Y' and promotion_start<=UNIX_TIMESTAMP() and promotion_stop>=UNIX_TIMESTAMP()";
break;
case 'N':
$is_promotion = "and (is_promotion='N' or promotion_start>UNIX_TIMESTAMP() and promotion_stop<UNIX_TIMESTAMP())";
}
if ($this->get['weight'] || $this->get['weight'] === '0') {
$weight = explode(',', $this->get['weight']);
if (count($weight) > 1) {
$weight[0] = $weight[0] ? $weight[0] : 0;
$weight[1] = $weight[1] ? $weight[1] : 100;
if (is_numeric($weight[0]) && is_numeric($weight[1])) {
$weight = 'and weight>=' . $weight[0] . ' and weight<=' . $weight[1];
} else {
$this->{make_ . $this->get['R']}(array('error' => array('code' => 1, 'info' => '重量错误')));
}
} else {
if (is_numeric($weight[0])) {
$weight = 'and weight=' . $weight[0];
} else {
$this->{make_ . $this->get['R']}(array('error' => array('code' => 1, 'info' => '重量错误')));
}
}
}
if (!$this->get['view']) {
$this->{make_ . $this->get['R']}(array('error' => array('code' => -2, 'info' => '显示的参数不能为空')));
}
if ($this->get['list']) {
$list = explode(',', $this->get['list']);
foreach ($list as $val) {
$val = explode('/', $val);
if (!$val[0]) {
$this->{make_ . $this->get['R']}(array('error' => array('code' => 2, 'info' => '排序字段为空')));
}
$val[1] = $val[1] ? $val[1] : 'asc';
if (!in_array($val[1], array('asc', 'desc'))) {
$this->{make_ . $this->get['R']}(array('error' => array('code' => 3, 'info' => '排序格式错误')));
}
$ORDER .= ",{$val[0]} {$val[1]}";
}
$ORDER = 'order by ' . substr($ORDER, 1);
}
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['page_amount']) ? $this->get['page_amount'] : 100;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select INTbid,ProID,shape,weight,color,clarity,cut,buffing as polish,symmetry,Fent_Isity as FLR,scalar_value,body_ratio as depth,table_width as `table`,diploma as cert,diplomaNO as certNO,infml from product where status='up' {$is_promotion} {$weight} {$shape} {$color} {$clarity} {$cut} {$polish} {$symmetry} {$FLR} {$cert} {$ORDER}";
if (count($DATA = $list->getText())) {
$DATA = $this->make_data($DATA, $user);
$info['data'] = $list->getPage();
$info['source'] = '广利珠宝网';
$info['home_page'] = 'www.GLDHK.com';
$info['author'] = 'simon';
$info['time'] = date('Y-m-d H:i:s');
$info['view'] = $this->get['view'];
$info['amount'] = $info['data']['Record'];
$info['page'] = $info['data']['count'];
$info['now_page'] = $info['data']['NowPage'];
$info['page_amount'] = $info['data']['PNS'];
unset($info['data']);
$DATA = $this->get_new_array('info', $info, $DATA);
$this->{make_ . $this->get['R']}($DATA);
} else {
$this->{make_ . $this->get['R']}(array('error' => array('code' => 0, 'info' => '没有产品')));
}
}
public function advanced()
{
$post = $this->fun->pars_all('post', true);
if ($post && count($post)) {
//把搜索条件存储进cookie中去
setcookie('advanced', serialize($post));
} else {
if (get_magic_quotes_gpc()) {
$post = unserialize(stripslashes($_COOKIE['advanced']));
} else {
$post = unserialize($_COOKIE['advanced']);
}
}
if (!$this->BTP[$this->get['open']][$this->get['action']]) {
$this->fun->Msg($this->BTP_Words);
}
//状态
$status = $this->get['status'] ? "and status='{$this->get['status']}'" : '';
if ($this->get['go'] == 'query') {
$ORDER = array('agio_UP' => 'agio asc', 'agio_Dn' => 'agio desc', 'nber_UP' => 'id asc', 'nber_Dn' => 'id desc', 'inml_UP' => 'infml asc', 'inml_Dn' => 'infml desc');
$this->get['ORDER'] = $ors = $this->get['ORDER'] ? $this->get['ORDER'] : 'agio_Dn';
//形状
if ($post['shape'] && count($post['shape'])) {
$shape = "and shape in ('" . join("','", $post['shape']) . "')";
}
//颜色
if ($post['color'] && count($post['color'])) {
$color = "and color in ('" . join("','", $post['color']) . "')";
}
//净度
if ($post['clarity'] && count($post['clarity'])) {
$clarity = "and clarity in ('" . join("','", $post['clarity']) . "')";
}
//切工
if ($post['cut'] && count($post['cut'])) {
$cut = "and cut in ('" . join("','", $post['cut']) . "')";
}
//抛光
if ($post['buffing'] && count($post['buffing'])) {
$buffing = "and buffing in ('" . join("','", $post['buffing']) . "')";
}
//对称
if ($post['symmetry'] && count($post['symmetry'])) {
$symmetry = "and symmetry in ('" . join("','", $post['symmetry']) . "')";
}
//荧光强度
if ($post['Fent_Isity'] && count($post['Fent_Isity'])) {
$Fent_Isity = "and Fent_Isity in ('" . join("','", $post['Fent_Isity']) . "')";
}
//荧光颜色
if ($post['Fent_color'] && count($post['Fent_color'])) {
$Fent_color = "and Fent_color in ('" . join("','", $post['Fent_color']) . "')";
}
//证书
if ($post['diploma'] && count($post['diploma'])) {
$diploma = "and diploma in ('" . join("','", $post['diploma']) . "')";
}
//产品来源
if ($post['proSource'] && count($post['proSource'])) {
$proSource = "and proSource in ('" . join("','", $post['proSource']) . "')";
}
//促销
if ($post['promotion_start'] && $post['promotion_stop']) {
$st = strtotime($post['promotion_start']);
$sp = strtotime($post['promotion_stop']);
if ($st > $sp) {
$sp = $st + $sp;
$st = $sp - $st;
$sp = $sp - $st;
}
$promotion = "and '{$sp}'>=promotion_start and '{$st}'<=promotion_stop";
}
//退点
if (is_numeric($post['agio'][0]) && is_numeric($post['agio'][1]) && ($post['agio'][0] || $post['agio'][1])) {
$s = $post['agio'][0];
$p = $post['agio'][1];
if ($s > $p) {
$p = $s + $p;
$s = $p - $s;
$p = $p - $s;
}
$agio = "and agio>={$s} and agio<={$p}";
}
//重量
if (is_numeric($post['weight'][0]) && is_numeric($post['weight'][1]) && ($post['weight'][0] || $post['weight'][1])) {
$s = $post['weight'][0];
$p = $post['weight'][1];
if ($s > $p) {
$p = $s + $p;
$s = $p - $s;
$p = $p - $s;
}
$weight = "and weight>={$s} and weight<={$p}";
}
//全身比
if (is_numeric($post['body_ratio'][0]) && is_numeric($post['body_ratio'][1]) && ($post['body_ratio'][0] || $post['body_ratio'][1])) {
$s = $post['body_ratio'][0];
$p = $post['body_ratio'][1];
if ($s > $p) {
$p = $s + $p;
$s = $p - $s;
$p = $p - $s;
}
$body_ratio = "and body_ratio>={$s} and body_ratio<={$p}";
}
//台宽比
if (is_numeric($post['table_width'][0]) && is_numeric($post['table_width'][1]) && ($post['table_width'][0] || $post['table_width'][1])) {
$s = $post['table_width'][0];
$p = $post['table_width'][1];
if ($s > $p) {
$p = $s + $p;
$s = $p - $s;
$p = $p - $s;
}
$table_width = "and table_width>={$s} and table_width<={$p}";
}
$this->default_value();
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['PNS']) ? $this->get['PNS'] : 14;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select INTbid,id,ProID,shape,weight,color,clarity,cut,buffing,symmetry,Fent_Isity,scalar_value,diploma,diplomaNO,agio,baseAgio,infml,is_promotion,promotion_start,promotion_stop,promotion_dot \n\t\t\t\t\t\t\t\tfrom product where 1 {$status} {$shape} {$color} {$clarity} {$cut} {$buffing} {$symmetry} {$Fent_Isity} {$Fent_color} \n\t\t\t\t\t\t\t\t{$diploma} {$proSource} {$promotion} {$agio} {$weight} {$body_ratio} {$table_width} order by {$ORDER[$ors]}";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
} else {
$this->default_value(true);
}
$this->sma->display($this->get['open'] . '_advanced');
}
public function show()
{
if (!$this->QX[$this->get['open']][$this->get['action']]) {
$this->fun->Msg('你没有此权限');
}
$this->get['st'] = $this->get['st'] ? $this->get['st'] : 'l';
$this->sma->assign('get', $this->get);
$post = $this->fun->pars_all('post', true);
if ($post && count($post)) {
//把搜索条件存储进cookie中去
setcookie('Query', serialize($post));
} else {
if (get_magic_quotes_gpc()) {
$post = unserialize(stripslashes($_COOKIE['Query']));
} else {
$post = unserialize($_COOKIE['Query']);
}
}
//echo $this->get['open'];die;
if ($this->get['go'] == 'query') {
$this->get['px'] = $this->get['px'] ? $this->get['px'] : 'agio';
$this->get['orders'] = $this->get['orders'] ? $this->get['orders'] : 'asc';
$ORDER = $this->get['px'] . ' ' . $this->get['orders'];
//形状
$this->st_array(&$post['shape']);
$shape = $post['shape'] && count($post['shape']) ? "and shape in ('" . join("','", $post['shape']) . "')" : '';
//颜色
$this->st_array(&$post['color']);
$color = $post['color'] && count($post['color']) ? "and color in ('" . join("','", $post['color']) . "')" : '';
//净度
$this->st_array(&$post['clarity']);
$clarity = $post['clarity'] && count($post['clarity']) ? "and clarity in ('" . join("','", $post['clarity']) . "')" : '';
//切工
$this->st_array(&$post['cut']);
$cut = $post['cut'] && count($post['cut']) ? "and cut in ('" . join("','", $post['cut']) . "')" : '';
//抛光
$this->st_array(&$post['buffing']);
$buffing = $post['buffing'] && count($post['buffing']) ? "and buffing in ('" . join("','", $post['buffing']) . "')" : '';
//对称
$this->st_array(&$post['symmetry']);
$symmetry = $post['symmetry'] && count($post['symmetry']) ? "and symmetry in ('" . join("','", $post['symmetry']) . "')" : '';
//荧光强度
$this->st_array(&$post['Fent_Isity']);
$Fent_Isity = $post['Fent_Isity'] && count($post['Fent_Isity']) ? "and Fent_Isity in ('" . join("','", $post['Fent_Isity']) . "')" : '';
//荧光颜色
$this->st_array(&$post['Fent_color']);
$Fent_color = $post['Fent_color'] && count($post['Fent_color']) ? "and Fent_color in ('" . join("','", $post['Fent_color']) . "')" : '';
//证书
$this->st_array(&$post['diploma']);
$diploma = $post['diploma'] && count($post['diploma']) ? "and diploma in ('" . join("','", $post['diploma']) . "')" : '';
//重量
if (is_numeric($post['weight'][0]) && is_numeric($post['weight'][1]) && ($post['weight'][0] || $post['weight'][1])) {
$s = $post['weight'][0];
$p = $post['weight'][1];
if ($s > $p) {
$p = $s + $p;
$s = $p - $s;
$p = $p - $s;
}
$weight = "and weight>={$s} and weight<={$p}";
}
$this->default_value();
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = is_numeric($this->get['PNS']) ? $this->get['PNS'] : 50;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select INTbid,id,ProID,shape,weight,color,clarity,cut,buffing,symmetry,Fent_Isity,scalar_value,diploma,diplomaNO,agio,baseAgio,infml,is_promotion,promotion_start,promotion_stop,promotion_dot \n\t\t\t\t\t\t\t\tfrom product where amount>0 and agio>-100 and baseAgio !=9 and status='up' {$shape} {$color} {$clarity} {$cut} {$buffing} {$symmetry} {$Fent_Isity} {$Fent_color} \n\t\t\t\t\t\t\t\t{$diploma} {$weight} order by {$ORDER}";
$this->sma->assign('list_page', $list->getPage(true));
$this->sma->assign('list_text', $list->getText());
} else {
$this->default_value();
//$this->sma->assign('post' , $post);
}
$this->sma->assign('post', $post);
if ($this->get['st'] == 'l') {
$this->sma->display('search_letter');
} else {
$this->sma->display('search_button');
}
}
public function log()
{
if (!$this->QX[$this->get['open']][$this->get['action']]) {
$this->fun->Msg('你没有此权限');
}
require_once BASEPATH . '../Class/page.php';
$list = new page();
$list->db = $this->db;
$list->pageNS = 20;
$list->NowPage = empty($this->get['page']) | $this->get['page'] < 1 | !is_numeric($this->get['page']) ? 1 : $this->get['page'];
$list->SQL = "select id,`show`,time from log where `type`='money' and who_id='{$_SESSION['proxy']['id']}' order by time desc";
$this->sma->assign('list_page', $list->getPage());
$this->sma->assign('list_text', $list->getText());
$this->sma->display('me_log');
}
