public function getWorkInfo($w = array(), $p = array())
{
global $kekezu, $_K, $uid;
$work_arr = array();
$sql = " select a.*,b.seller_credit,b.seller_good_num,b.seller_total_num,b.seller_level,c.quote,c.quote_desc,c.cycle from " . TABLEPRE . "witkey_task_work a left join " . TABLEPRE . "witkey_space b on a.uid=b.uid\n\t\t\t\tleft join " . TABLEPRE . "witkey_task_match_work c on a.work_id=c.work_id";
$count_sql = " select count(a.work_id) from " . TABLEPRE . "witkey_task_work a left join " . TABLEPRE . "witkey_space b on a.uid=b.uid";
$where = " where a.task_id = '{$this->_task_id}' ";
if (!empty($w)) {
$intWorkStatus = intval($w['work_status']);
switch ($intWorkStatus) {
case '2':
$where .= " and a.is_view !=1 ";
break;
case '4':
case '7':
case '9':
$where .= " and a.work_status = '" . $intWorkStatus . "'";
break;
case '11':
$where .= " and a.uid = '{$this->_uid}'";
break;
}
}
$where .= " order by a.work_status asc,work_time desc";
if (!empty($p)) {
$page_obj = $kekezu->_page_obj;
$page_obj->setAjax(1);
$page_obj->setAjaxDom("gj_summery");
$count = intval(db_factory::get_count($count_sql . $where));
$pages = $page_obj->getPages($count, $p['page_size'], $p['page'], $p['url'], $p['anchor']);
$pages['count'] = $count;
$where .= $pages['where'];
}
$work_info = db_factory::query($sql . $where);
$work_info = kekezu::get_arr_by_key($work_info, 'work_id');
$arrWorks['work_info'] = array();
if (is_array($work_info)) {
foreach ($work_info as $k => $v) {
$arrWorks['work_info'][$k] = $v;
$arrWorks['work_info'][$k]['comment'] = $this->get_comment('work', $this->_task_id, $v['work_id'], $v['uid']);
}
}
$arrWorks['pages'] = $pages;
$strWorkIds = implode(',', array_keys($work_info));
$arrWorks['mark'] = $this->has_mark($strWorkIds);
$arrWorks['count'] = $count;
$strWorkIds && $uid == $this->_task_info['uid'] and db_factory::execute('update ' . TABLEPRE . 'witkey_task_work set is_view=1 where work_id in (' . $strWorkIds . ') and is_view=0');
return $arrWorks;
}
public function get_work_info($w = array(), $order = null, $p = array())
{
global $kekezu, $_K, $uid, $gUid;
$work_arr = array();
$sql = " select a.*,\n\t\t\t\t\t\tb.seller_credit,b.seller_good_num,b.residency,b.seller_total_num,b.seller_level\n\t\t\t\t\tfrom " . TABLEPRE . "witkey_task_work a\n\t\t\t left join " . TABLEPRE . "witkey_space b on a.uid=b.uid";
$count_sql = " select count(a.work_id) from " . TABLEPRE . "witkey_task_work a left join " . TABLEPRE . "witkey_space b on a.uid=b.uid";
$where = " where a.task_id = " . $this->_task_id;
if (!empty($w)) {
$intWorkStatus = intval($w['work_status']);
switch ($intWorkStatus) {
case '2':
$where .= " and a.is_view !=1 ";
break;
case '4':
case '5':
case '7':
case '8':
$where .= " and a.work_status = '" . $intWorkStatus . "'";
break;
case '9':
$where .= " and a.uid = '{$this->_uid}'";
break;
}
}
$where .= " order by field(a.work_status,'8','7','5','4') desc, work_id asc ";
if (!empty($p)) {
$page_obj = $kekezu->_page_obj;
$page_obj->setAjax(1);
$page_obj->setAjaxDom("gj_summery");
$count = intval(db_factory::get_count($count_sql . $where));
$pages = $page_obj->getPages($count, $p['page_size'], $p['page'], $p['url'], $p['anchor']);
$where .= $pages['where'];
$pages['count'] = $count;
}
$work_info = db_factory::query($sql . $where);
$work_info = kekezu::get_arr_by_key($work_info, 'work_id');
$work_arr['work_info'] = $work_info;
$work_arr['pages'] = $pages;
$work_ids = implode(',', array_keys($work_info));
$work_arr['mark'] = $this->has_mark($work_ids);
$work_arr['count'] = $count;
if (is_array($work_info)) {
foreach ($work_info as $k => $v) {
$work_arr['work_info'][$k] = $v;
$work_arr['work_info'][$k]['attachment'] = array();
if ($v['work_file']) {
$fileids = explode(',', $v['work_file']);
$fileids = array_filter($fileids);
$fileids = implode(',', $fileids);
$work_arr['work_info'][$k]['attachment'] = db_factory::query('select file_id,save_name,file_name from ' . TABLEPRE . 'witkey_file where file_id in (' . $fileids . ')');
}
$work_arr['work_info'][$k]['comment'] = $this->get_comment('work', $this->_task_id, $v['work_id'], $v['uid']);
if ($this->_task_status == 4) {
$arrVote = db_factory::get_count(sprintf(" select count(vote_id) from %switkey_vote where\n\t\t work_id='%d' and uid='%d' and vote_ip='%s'", TABLEPRE, intval($v['work_id']), $this->_uid, kekezu::get_ip()));
if ($arrVote) {
$work_arr['work_info'][$k]['vote'] = true;
}
unset($arrVote);
}
$arrFavorite = db_factory::get_count(sprintf('select count(*) from %s where uid = %d and obj_id = %d and keep_type = "work"', TABLEPRE . 'witkey_favorite', intval($gUid), intval($v['work_id'])));
if ($arrFavorite) {
$work_arr['work_info'][$k]['favorite'] = true;
}
unset($arrFavorite);
}
}
$work_ids && $uid == $this->_task_info['uid'] and db_factory::execute('update ' . TABLEPRE . 'witkey_task_work set is_view=1 where work_id in (' . $work_ids . ') and is_view=0');
return $work_arr;
}
public function getWorkInfo($w = array(), $p = array())
{
global $kekezu, $uid;
$arrWorks = array();
$strSql = " select a.*,b.seller_credit,b.seller_good_num,b.seller_total_num,b.seller_level from " . TABLEPRE . "witkey_task_bid a left join " . TABLEPRE . "witkey_space b on a.uid=b.uid";
$strWhere = " where a.task_id = '{$this->_task_id}' ";
if (!empty($w)) {
$intBidStatus = intval($w['bid_status']);
switch ($intBidStatus) {
case '2':
$strWhere .= " and a.is_view !=1 ";
break;
case '4':
case '7':
$strWhere .= " and a.bid_status = '" . $intBidStatus . "'";
break;
case '9':
$strWhere .= " and a.uid = '{$this->_uid}'";
break;
}
}
$strWhere .= " order by field(a.bid_status,'8','7','4') desc, bid_id asc ";
if (!empty($p)) {
$objPage = $kekezu->_page_obj;
$objPage->setAjax(1);
$objPage->setAjaxDom("gj_summery");
$intCount = intval(db_factory::execute($strSql . $strWhere));
$strPages = $objPage->getPages($intCount, $p['page_size'], $p['page'], $p['url'], $p['anchor']);
$strPages['count'] = $intCount;
$strWhere .= $strPages['where'];
}
$arrWorkInfo = db_factory::query($strSql . $strWhere);
$arrWorkInfo = kekezu::get_arr_by_key($arrWorkInfo, 'bid_id');
$arrWorks['work_info'] = array();
if (is_array($arrWorkInfo)) {
foreach ($arrWorkInfo as $k => $v) {
$arrWorks['work_info'][$k] = $v;
$arrWorks['work_info'][$k]['comment'] = $this->get_comment('work', $this->_task_id, $v['bid_id'], $v['uid']);
}
}
$arrWorks['pages'] = $strPages;
$strWorkIds = implode(',', array_keys($arrWorkInfo));
$arrWorks['mark'] = $this->has_mark($strWorkIds);
$arrWorks['count'] = $intCount;
$strWorkIds && $uid == $this->_task_info['uid'] and db_factory::execute('update ' . TABLEPRE . 'witkey_task_bid set is_view=1 where bid_id in (' . $strWorkIds . ') and is_view=0');
return $arrWorks;
}
function init_model()
{
$model_arr = db_factory::query('select * from ' . TABLEPRE . 'witkey_model where 1=1 order by model_id asc', 0, null);
$this->_model_list = kekezu::get_arr_by_key($model_arr, 'model_id');
foreach ($this->_model_list as $v) {
if ($v['model_type'] == 'task') {
$this->_task_open = $this->_task_open | $v['model_status'];
} else {
$this->_shop_open = $this->_shop_open | $v['model_status'];
}
}
$route = $this->_route;
foreach ($route as $k => $v) {
if ($this->_task_open == 0) {
if (strpos($v, 'task') !== FALSE || $v == 'weibo') {
unset($route[$k]);
}
}
if ($this->_shop_open == 0) {
if (strpos($v, 'shop') !== FALSE || $v == 'seller_list') {
unset($route[$k]);
}
}
if ($this->_shop_open == 0 && $this->_task_open == 0) {
if ($v == 'case') {
unset($route[$k]);
}
}
}
$this->_route = $route;
$this->nav_filter();
}
public static function get_auth($user_info)
{
$auth_item = keke_auth_base_class::get_auth_item();
$auth_temp = array_keys($auth_item);
$user_info['user_type'] == 2 and $un_code = 'realname' or $un_code = "enterprise";
$t = implode(",", $auth_temp);
$auth_info = db_factory::query(" select a.auth_code,a.auth_status,b.auth_title,b.auth_small_ico,b.auth_small_n_ico from " . TABLEPRE . "witkey_auth_record a left join " . TABLEPRE . "witkey_auth_item b on a.auth_code=b.auth_code where a.uid ='" . $user_info['uid'] . "' and FIND_IN_SET(a.auth_code,'{$t}')", 1, -1);
$auth_info = kekezu::get_arr_by_key($auth_info, "auth_code");
return array('item' => $auth_item, 'info' => $auth_info, 'code' => $un_code);
}
$service = db_factory::query($sql . $s_sql . $f_sql . ' group by model_id', 1, 3600);
$payitem = db_factory::get_one($sql . sprintf(' from %switkey_finance where fina_type="out"
and fina_action="payitem" ', TABLEPRE) . $f_sql, 1, 3600);
break;
case 'profit':
$sql = sprintf(' select sum(site_profit) c from %switkey_finance where site_profit>0 ', TABLEPRE);
$task = db_factory::get_count($sql . ' and obj_type="task" ' . $f_sql, 0, 'c', 3600);
$service = db_factory::get_count($sql . ' and obj_type="service" ' . $f_sql, 0, 'c', 3600);
$payitem = db_factory::get_count($sql . ' and obj_type="payitem" ' . $f_sql, 0, 'c', 3600);
$auth = db_factory::get_count($sql . ' and INSTR(obj_type,"_auth")>0 ' . $f_sql, 0, 'c', 3600);
$withdraw = db_factory::get_count(sprintf(' select sum(fee) c from %switkey_withdraw
where withdraw_status=2 ', TABLEPRE) . $w_sql, 0, 'c', 3600);
$p_all = floatval($task + $service + $payitem + $auth + $withdraw);
break;
case 'withdraw':
$list = db_factory::query(sprintf(' select sum(withdraw_cash) cash,sum(fee) fee,
count(withdraw_id) count,pay_type from %switkey_withdraw where 1 = 1 ', TABLEPRE) . $w_sql . ' group by pay_type', 1, 3600);
$list && ($list = kekezu::get_arr_by_key($list, 'pay_type'));
$bank_arr = keke_glob_class::get_bank();
$pay_online = kekezu::get_payment_config('', 'online');
break;
case 'charge':
$sql = ' select sum(fina_cash) cash,sum(fina_credit) credit,count(fina_id) count ';
$r_sql = sprintf(' ,obj_type from %switkey_finance
where INSTR(obj_type,"_charge")>0 and fina_type = "in"', TABLEPRE);
$charge = db_factory::query($sql . $r_sql . $f_sql . ' group by obj_type ', 1, 3600);
$charge = kekezu::get_arr_by_key($charge, 'obj_type');
$fina_type = keke_glob_class::get_fina_charge_type();
break;
}
require keke_tpl_class::template(ADMIN_DIRECTORY . '/tpl/admin_finance_revenue');
public function get_work_info($w = array(), $p = array())
{
global $kekezu, $_K, $uid;
$work_arr = array();
$sql = " select a.*,b.seller_credit,b.seller_good_num,b.seller_total_num,b.seller_level from " . TABLEPRE . "witkey_task_work a left join " . TABLEPRE . "witkey_space b on a.uid=b.uid";
$count_sql = " select count(a.work_id) from " . TABLEPRE . "witkey_task_work a left join " . TABLEPRE . "witkey_space b on a.uid=b.uid";
$where = " where a.task_id = '{$this->_task_id}' ";
if (!empty($w)) {
$w['work_type'] == 'noview' and $where .= " and a.is_view !=1 ";
$w['work_type'] == 'my' and $where .= " and a.uid = '{$this->_uid}'";
isset($w['work_status']) and $where .= " and a.work_status = '" . intval($w['work_status']) . "'";
}
$where .= " order by field(a.work_status,'7','3','2','1') desc,work_time asc ";
if (!empty($p)) {
$page_obj = $kekezu->_page_obj;
$count = intval(db_factory::get_count($count_sql . $where));
$pages = $page_obj->getPages($count, $p['page_size'], $p['page'], $p['url'], $p['anchor']);
$where .= $pages['where'];
}
$work_info = db_factory::query($sql . $where);
$work_info = kekezu::get_arr_by_key($work_info, 'work_id');
$arrWorks['work_info'] = array();
if (is_array($work_info)) {
foreach ($work_info as $k => $v) {
$arrWorks['work_info'][$k] = $v;
$arrWorks['work_info'][$k]['attachment'] = array();
if ($v['work_file']) {
$fileids = explode(',', $v['work_file']);
$fileids = array_filter($fileids);
$fileids = implode(',', $fileids);
$arrWorks['work_info'][$k]['attachment'] = db_factory::query('select file_id,save_name,file_name from ' . TABLEPRE . 'witkey_file where file_id in (' . $fileids . ')');
}
$arrWorks['work_info'][$k]['comment'] = $this->get_comment('work', $this->_task_id, $v['work_id'], $v['uid']);
}
}
$arrWorks['pages'] = $pages;
$strWorkIds = implode(',', array_keys($work_info));
$arrWorks['mark'] = $this->has_mark($strWorkIds);
$arrWorks['count'] = $count;
$strWorkIds && $uid == $this->_task_info['uid'] and db_factory::execute('update ' . TABLEPRE . 'witkey_task_work set is_view=1 where work_id in (' . $strWorkIds . ') and is_view=0');
return $arrWorks;
}
