public function news_list()
{
// global $db, $config;
global $config;
$db = new mysql($config["db2"]);
$db->connect();
//排序
$set_sort = $this->set_sort();
//搜尋
$set_search = $this->news_list_set_search();
//SQL指令
$query_count = " SELECT count(*) as num ";
$query_record = "SELECT * ";
$query = "FROM `{$config['db'][2]['dbname']}`.`{$config['default_prefix']}news` n\n\t\t{$set_search['join_query']}\n\t\tWHERE \n\t\t\tn.prefixid = '{$config['default_prefix_id']}' \n\t\t\tAND unix_timestamp() >= unix_timestamp(n.ontime)\n\t\t\tAND n.switch = 'Y'\n\t\t";
//AND unix_timestamp() BETWEEN unix_timestamp(n.ontime) AND unix_timestamp(n.offtime)
$query .= $set_search['sub_search_query'];
$query .= $set_sort ? $set_sort : ' ORDER BY n.seq ';
//總筆數
$getnum = $db->getQueryRecord($query_count . $query);
$num = !empty($getnum['table']['record'][0]['num']) ? $getnum['table']['record'][0]['num'] : 0;
if ($num) {
//分頁資料
$page = $db->recordPage($num, $this);
$query_limit = " LIMIT " . ($page["rec_start"] - 1) . "," . $config['max_page'];
//取得資料
$table = $db->getQueryRecord($query_record . $query . $query_limit);
} else {
$table['table']['record'] = '';
}
if (!empty($table['table']['record'])) {
$table['table']['page'] = $page;
return $table;
}
return false;
}
public function product_flash_list_all()
{
// global $db, $config;
global $config;
$db = new mysql($config["db2"]);
$db->connect();
//排序
$set_sort = $this->set_sort();
//搜尋
$set_search = $this->product_list_set_search();
//SQL指令
$query_count = " SELECT count(*) as num ";
$query_record = "SELECT distinct(p.productid) as ppp , p.*, unix_timestamp(p.offtime) as offtime, unix_timestamp() as `now`, pt.filename as thumbnail ";
// Not By Channel
$query = "FROM `{$config['db'][4]['dbname']}`.`{$config['default_prefix']}product` p \n\t\t{$set_search['join_query']}\n\t\tLEFT OUTER JOIN `{$config['db'][2]['dbname']}`.`{$config['default_prefix']}store_product_rt` sp ON \n\t\t\tp.prefixid = sp.prefixid\n\t\t\tAND p.productid = sp.productid\n\t\t\tAND sp.switch = 'Y'\n\t\tLEFT OUTER JOIN `{$config['db'][2]['dbname']}`.`{$config['default_prefix']}channel_store_rt` cs ON \n\t\t\tsp.prefixid = cs.prefixid\n\t\t\tAND sp.storeid = cs.storeid\n\t\t\tAND cs.switch = 'Y'\n\t\tLEFT OUTER JOIN `{$config['db'][4]['dbname']}`.`{$config['default_prefix']}product_thumbnail` pt ON \n\t\t\tp.prefixid = pt.prefixid\n\t\t\tAND p.ptid = pt.ptid\n\t\t\tAND pt.switch = 'Y'\n\t\tWHERE \n\t\t\tp.prefixid = '{$config['default_prefix_id']}'\n AND p.switch='Y'\n AND p.display='Y'\t\t\t\n\t\t\tAND p.is_flash = 'Y'\n\t\t\tAND sp.productid IS NOT NULL\n\t\t\tAND cs.channelid IS NOT NULL\n\t\t";
$query .= $set_search['sub_search_query'];
$query .= $set_sort ? $set_sort : " ORDER BY offtime ASC ";
//總筆數
$getnum = $db->getQueryRecord($query_count . $query);
$num = !empty($getnum['table']['record'][0]['num']) ? $getnum['table']['record'][0]['num'] : 0;
if ($num) {
//分頁資料
$page = $db->recordPage($num, $this);
$query_limit = " LIMIT 1 ";
// $query_limit = " LIMIT ". ($page["rec_start"]-1) .",". ($config['max_page']);
error_log("[m/product_flash_list_all] : " . $query_record . $query . $query_limit);
//取得資料
$table = $db->getQueryRecord($query_record . $query . $query_limit);
} else {
$table['table']['record'] = '';
}
if (!empty($table['table']['record'])) {
$table['table']['page'] = $page;
foreach ($table['table']['record'] as $tk => $tv) {
$productid = $tv['productid'];
//红利回馈
if ($tv['bonus_type'] == 'ratio') {
$table['table']['record'][$tk]['bonus'] = (double) sprintf("%0.2f", $tv['bonus']) . '%';
} elseif ($tv['bonus_type'] == 'value') {
$table['table']['record'][$tk]['bonus'] = (double) sprintf("%0.2f", $tv['bonus']) . '点';
} else {
$table['table']['record'][$tk]['bonus'] = 0;
}
// Relation product_rule_rt 下標條件關聯
$rule_rt = $this->get_product_rule_rt($productid);
$table['table']['record'][$tk]['srid'] = $rule_rt['srid'];
$table['table']['record'][$tk]['value'] = $rule_rt['value'];
}
return $table;
}
return false;
}
public function product_cancelled_list()
{
// global $db, $config;
global $config;
$db = new mysql($config["db2"]);
$db->connect();
//排序
$set_sort = $this->set_sort();
//SQL指令
$query_count = " SELECT count(*) as num ";
$query_record = "SELECT p.*, unix_timestamp(p.offtime) as offtime, unix_timestamp() as `now`, pt.filename thumbnail ";
$query = "FROM `{$config['db'][4]['dbname']}`.`{$config['default_prefix']}product` p \n\t\tLEFT OUTER JOIN `{$config['db'][4]['dbname']}`.`{$config['default_prefix']}product_thumbnail` pt ON \n\t\t\tp.prefixid = pt.prefixid\n\t\t\tAND p.ptid = pt.ptid\n\t\t\tAND pt.switch = 'Y'\n\t\tLEFT OUTER JOIN `{$config['db'][2]['dbname']}`.`{$config['default_prefix']}store_product_rt` sp ON \n\t\t\tp.prefixid = sp.prefixid\n\t\t\tAND p.productid = sp.productid\n\t\t\tAND sp.switch = 'Y'\n\t\tLEFT OUTER JOIN `{$config['db'][2]['dbname']}`.`{$config['default_prefix']}channel_store_rt` cs ON \n\t\t\tsp.prefixid = cs.prefixid\n\t\t\tAND sp.storeid = cs.storeid\n\t\t\tAND cs.channelid = '{$_GET["channelid"]}'\n\t\t\tAND cs.switch = 'Y'\n\t\tWHERE \n\t\t\tp.prefixid = '{$config['default_prefix_id']}' \n\t\t\tAND closed = 'NB'\n\t\t\tAND p.switch = 'Y'\n\t\t";
$query .= $set_sort ? $set_sort : "ORDER BY p.offtime DESC";
//總筆數
$getnum = $db->getQueryRecord($query_count . $query);
$num = !empty($getnum['table']['record'][0]['num']) ? $getnum['table']['record'][0]['num'] : 0;
if ($num) {
//分頁資料
$page = $db->recordPage($num, $this);
$query_limit = " LIMIT " . ($page["rec_start"] - 1) . "," . $config['max_page'];
//取得資料
$table = $db->getQueryRecord($query_record . $query . $query_limit);
} else {
$table['table']['record'] = '';
}
if (!empty($table['table']['record'])) {
$table['table']['page'] = $page;
foreach ($table['table']['record'] as $tk => $tv) {
//市價
$table['table']['record'][$tk]['retail_price'] = number_format($tv['retail_price']);
//sprintf("%0.2f", $tv['retail_price']);
//流標原因
if ($this->bid_info($tv['productid']) < $tv['saja_limit']) {
$table['table']['record'][$tk]['memo'] = '未达' . $tv['saja_limit'] . '标';
} else {
$table['table']['record'][$tk]['memo'] = '无唯一流标';
}
}
return $table;
}
return false;
}
public function order_list($uid)
{
// global $db, $config;
global $config;
$db = new mysql($config["db2"]);
$db->connect();
//排序
$set_sort = $this->set_sort();
//搜尋
$set_search = $this->order_list_set_search();
//SQL指令
$query_count = " SELECT count(*) as num ";
$query_record = "SELECT o.* ";
$query = "FROM `{$config['db'][3]['dbname']}`.`{$config['default_prefix']}order` o \n\t\t{$set_search['join_query']}\n\t\tWHERE \n\t\t\to.prefixid = '{$config['default_prefix_id']}' \n\t\t\tAND o.userid = '{$uid}'\n\t\t\tAND o.confirm = 'Y'\n\t\t\tAND o.switch = 'Y'\n\t\t";
$query .= $set_search['sub_search_query'];
$query .= $set_sort ? $set_sort : "ORDER BY o.insertt DESC";
//總筆數
$getnum = $db->getQueryRecord($query_count . $query);
$num = !empty($getnum['table']['record'][0]['num']) ? $getnum['table']['record'][0]['num'] : 0;
if ($num) {
//分頁資料
$page = $db->recordPage($num, $this);
$query_limit = " LIMIT " . ($page["rec_start"] - 1) . "," . $config['max_page'];
//取得資料
$table = $db->getQueryRecord($query_record . $query . $query_limit);
} else {
$table['table']['record'] = '';
}
if (!empty($table['table']['record'])) {
$table['table']['page'] = $page;
$status = _v('status');
foreach ($table['table']['record'] as $tk => $tv) {
$table['table']['record'][$tk] = $tv;
if ($tv['type'] == 'saja') {
$query = "SELECT p.productid, p.name \n\t\t\t\t\tFROM `{$config['db'][4]['dbname']}`.`{$config['default_prefix']}pay_get_product` gp\n\t\t\t\t\tLEFT OUTER JOIN `{$config['db'][4]['dbname']}`.`{$config['default_prefix']}product` p ON \n\t\t\t\t\t\tp.prefixid = gp.prefixid\n\t\t\t\t\t\tAND p.productid = gp.productid\n\t\t\t\t\t\tAND p.switch = 'Y'\n\t\t\t\t\tWHERE \n\t\t\t\t\t\tgp.prefixid = '{$config['default_prefix_id']}' \n\t\t\t\t\t\tAND gp.pgpid = '{$tv['pgpid']}'\n\t\t\t\t\t\tAND gp.switch = 'Y'\n\t\t\t\t\t\tAND p.productid IS NOT NULL\n\t\t\t\t\t";
$recArr = $db->getQueryRecord($query);
$rs = isset($recArr['table']['record'][0]) ? $recArr['table']['record'][0] : '';
$table['table']['record'][$tk]['productid'] = $rs ? $rs['productid'] : '';
$table['table']['record'][$tk]['name'] = $rs ? $rs['name'] : '';
$table['table']['record'][$tk]['href'] = $rs ? APP_DIR . '/product/saja/?' . $status['status']['args'] . '&productid=' . $rs['productid'] : '';
} else {
$query = "SELECT p.epid, p.name \n\t\t\t\t\tFROM `{$config['db'][3]['dbname']}`.`{$config['default_prefix']}exchange_product` p\n\t\t\t\t\tWHERE \n\t\t\t\t\tp.prefixid = '{$config['default_prefix_id']}' \n\t\t\t\t\tAND p.epid = '{$tv['epid']}'\n\t\t\t\t\tAND p.switch = 'Y'\n\t\t\t\t\t";
$recArr = $db->getQueryRecord($query);
$rs = isset($recArr['table']['record'][0]) ? $recArr['table']['record'][0] : '';
$table['table']['record'][$tk]['productid'] = $rs ? $rs['epid'] : '';
$table['table']['record'][$tk]['name'] = $rs ? $rs['name'] : '';
$table['table']['record'][$tk]['href'] = $rs ? APP_DIR . '/mall/exchange/?' . $status['status']['args'] . '&epid=' . $tv['epid'] : '';
}
}
return $table;
}
return false;
}
