PHP kekezu::get_table_data方法代码示例

 public function get_task_indus($indus_pid = '', $ajax = '')
 {
     global $kekezu;
     global $_lang;
     if ($indus_pid > 0) {
         if ($this->_model_info['indus_bid']) {
             $indus_ids = kekezu::get_table_data('*', "witkey_industry", "indus_id in ({$this->_model_info['indus_bid']}) and indus_pid = {$indus_pid}", 'CASE WHEN listorder = 0 THEN 9999999 WHEN listorder > 0 THEN listorder END', '', '', 'indus_id', null);
         } else {
             $indus_ids = kekezu::get_table_data('*', "witkey_industry", " indus_pid = {$indus_pid}", 'CASE WHEN listorder = 0 THEN 9999999 WHEN listorder > 0 THEN listorder END', '', '', 'indus_id', null);
         }
         switch ($ajax == 'show_indus') {
             case "0":
                 return $indus_ids;
                 break;
             case "1":
                 $option .= '<option value=""> ' . $_lang['please_son_industry'] . ' </option>';
                 foreach ($indus_ids as $v) {
                     $option .= '<option value=' . $v[indus_id] . '>' . $v[indus_name] . '</option>';
                 }
                 echo $option;
                 die;
                 break;
         }
     } else {
         return false;
     }
 }

 public static function get_auth_item($auth_code = null, $find_str = null, $is_open = false, $w = null, $cache = true)
 {
     global $_cache_obj;
     $auth_code && is_array($auth_code) and $auth_code = implode(",", $auth_code);
     $auth_code and (is_array($auth_code) and $where = " auth_code in ('{$auth_code}') " or $where = " auth_code = '{$auth_code}'") or $where = " 1 = 1";
     $find_str and $fds = $find_str or $fds = '*';
     $is_open and $where .= " and auth_open=1 ";
     $w and $where .= " and " . $w;
     $cache == true and $c = null or $c = 0;
     $auth_item = kekezu::get_table_data($fds, "witkey_auth_item", $where, 'listorder asc', '', '', 'auth_code', $c);
     if ($auth_code && !is_array($auth_code)) {
         return $auth_item[$auth_code];
     } else {
         return $auth_item;
     }
 }

 function run()
 {
     global $_K, $kekezu;
     $shop_time = new goods_time_class();
     $shop_time->validtaskstatus();
     $this->validautoMail();
     $model_list = $model_list ? $model_list : kekezu::get_table_data('*', 'witkey_model', 'model_status=1', '', null, '', 'model_id');
     $this->task_finish_auto_mark();
     foreach ($model_list as $model_info) {
         $model_dir = $model_info['model_dir'];
         if (file_exists(S_ROOT . "./task/{$model_dir}")) {
             $m = strtolower($model_dir) . "_time_class";
         }
         if (class_exists($m)) {
             $time_obj = new $m();
             $time_obj->validtaskstatus();
         }
     }
     keke_task_class::hp_timeout(7);
 }

 public function wap_list()
 {
     global $_K;
     $_D = $_REQUEST;
     $ls = intval($_D['ls']);
     $le = intval($_D['le']);
     $s = isset($_D['work_status']) ? $_D['work_status'] : "all";
     $s !== "all" and $w = ' and work_status = ' . $s;
     $info = db_factory::query(sprintf('select * from %switkey_task_work where task_id=%d %s limit %d,%d', TABLEPRE, $this->_task_id, $w, $ls, $le), 1, 3600);
     $count = db_factory::get_count('select count(work_id) from ' . TABLEPRE . 'witkey_task_work where task_id=' . $this->_task_id . $w);
     if ($info) {
         $ids = implode(',', array_keys($info));
         $f_tmp = kekezu::get_table_data("obj_id,CONCAT('" . $_K['siteurl'] . "/',`save_name`) file", 'witkey_file', " obj_id in ('" . ids . "') and obj_type='work'", '', '', '', 'obj_id', 3600);
         foreach ($f_tmp as $k => $v) {
             $info[$k]['work_file'] = $v['file'];
         }
         $info = array_values($info);
     }
     kekezu::echojson(intval($count), 1, $info);
     die;
 }

 public function alipayjs_success_notify($detail_arr, $status = true)
 {
     global $_lang, $_K;
     $ids = implode(",", array_keys($detail_arr));
     $info = kekezu::get_table_data("withdraw_id,uid,username,withdraw_status,withdraw_cash,pay_username,pay_account", "witkey_withdraw", " withdraw_id in ({$ids})", "", "", "", "withdraw_id");
     foreach ($detail_arr as $k => $v) {
         if ($info[$k]['withdraw_status'] == 1) {
             switch ($v['status']) {
                 case "S":
                     $fee = $info[$k]['withdraw_cash'] - keke_finance_class::get_to_cash($info[$k]['withdraw_cash']);
                     $res = db_factory::execute(sprintf(" update %switkey_withdraw set withdraw_status='2',fee=%.2f where withdraw_id ='%d'", TABLEPRE, $fee, $k));
                     $arr = array($_lang['sitename'] => $_K['sitename'], $_lang['tx_cash'] => $v['fee']);
                     keke_msg_class::notify_user($info[$k]['uid'], $info[$k]['username'], 'draw_success', $_lang['tx_success'], $arr, 2);
                     break;
                 case "F":
                     $res = db_factory::execute(sprintf(" update %switkey_withdraw set withdraw_status='3' where withdraw_id ='%d'", TABLEPRE, $k));
                     $v_arr = array('网站名称' => $_K['sitename'], '提现方式' => $pay_way[$withdraw_info[0]['pay_type']], '失败原因' => '未注明原因', '帐户' => $withdraw_info[0]['pay_account'], '提现金额' => $v['withdraw_cash']);
                     keke_msg_class::notify_user($info[$k]['uid'], $info[$k]['username'], 'withdraw_fail', $_lang['tx_fail'], $v_arr, 2);
                     break;
             }
         }
     }
 }

 public static function get_payitem_info($user_type, $model_code)
 {
     $where = sprintf(" user_type='%s' and is_open = 1 and find_in_set('%s',model_code)", $user_type, $model_code);
     $payitem_arr = kekezu::get_table_data("*", "witkey_payitem", "{$where}", "", "", "", "item_id");
     return $payitem_arr;
 }

 function init_industry()
 {
     $this->_indus_p_arr = kekezu::get_table_data('*', "witkey_industry", "indus_type=1 and indus_pid = 0 ", " CASE WHEN listorder = 0 THEN 9999999 WHEN listorder > 0 THEN listorder END ", '', '', 'indus_id', NULL);
     $tmpArrIndus = kekezu::get_table_data('*', 'witkey_industry', 'indus_type=1 and indus_pid >0', ' CASE WHEN listorder = 0 THEN 9999999 WHEN listorder > 0 THEN listorder END ', '', '', 'indus_id', NULL);
     if (is_array($tmpArrIndus) && !empty($tmpArrIndus)) {
         $this->_indus_c_arr = array();
         foreach ($this->_indus_p_arr as $k1 => $v1) {
             foreach ($tmpArrIndus as $k => $v) {
                 if ($v1['indus_id'] == $v['indus_pid']) {
                     $this->_indus_c_arr[$v['indus_id']] = $v;
                 }
             }
         }
     }
     $this->_indus_arr = kekezu::get_table_data('*', 'witkey_industry', '', ' CASE WHEN listorder = 0 THEN 9999999 WHEN listorder > 0 THEN listorder END ', '', '', 'indus_id', NULL);
     $arrtotask = db_factory::query("show COLUMNS FROM " . TABLEPRE . 'witkey_industry' . " WHERE Field='totask' ");
     if ($arrtotask[0]) {
         $this->_indus_task_arr = kekezu::get_table_data('*', "witkey_industry", "indus_type=1 and indus_pid = 0 and totask=1 ", " CASE WHEN listorder = 0 THEN 9999999 WHEN listorder > 0 THEN listorder END ", '', '', 'indus_id', NULL);
     }
     $arrtogoods = db_factory::query("show COLUMNS FROM " . TABLEPRE . 'witkey_industry' . " WHERE Field='togoods' ");
     if ($arrtogoods[0]) {
         $this->_indus_goods_arr = kekezu::get_table_data('*', "witkey_industry", "indus_type=1 and indus_pid = 0 and togoods=1 ", " CASE WHEN listorder = 0 THEN 9999999 WHEN listorder > 0 THEN listorder END ", '', '', 'indus_id', NULL);
     }
 }

<?php

defined('IN_KEKE') or exit('Access Denied');
$strUrl = 'index.php?do=user&view=account&op=basic';
$arrTopIndustrys = $indus_p_arr;
$arrAllIndustrys = $indus_arr;
$objSpaceT = keke_table_class::get_instance('witkey_space');
$intUserRole = intval($gUserInfo['user_type']);
$arrMemberExts = kekezu::get_table_data("*", "witkey_member_ext", " type='sect' and uid= " . $gUid, "", "", "", "k");
$boolEmailAuth = keke_auth_fac_class::auth_check('email', $gUid);
$boolMobileAuth = keke_auth_fac_class::auth_check('mobile', $gUid);
$arrProvinces = CommonClass::getDistrictByPid('0', 'id,upid,name');
if ($gUserInfo['province']) {
    $arrCity = CommonClass::getDistrictByPid($gUserInfo['province'], 'id,upid,name');
}
if ($gUserInfo['city']) {
    $arrArea = CommonClass::getDistrictByPid($gUserInfo['city'], 'id,upid,name');
}
if ($intUserRole === 2) {
    $intAuthStatus = keke_auth_fac_class::auth_check('enterprise', $gUid);
    $arrEnterPriseInfo = db_factory::get_one(sprintf("select * from %switkey_auth_enterprise where uid='%d'", TABLEPRE, $gUid));
    if (isset($formhash) && kekezu::submitcheck($formhash)) {
        if ($gUserInfo['uid'] != $pk['uid']) {
            kekezu::show_msg('无权操作', NULL, NULL, NULL, 'error');
            return false;
        }
        if (strtoupper(CHARSET) == 'GBK') {
            $company = kekezu::utftogbk($company);
            $legal = kekezu::utftogbk($legal);
            $address = kekezu::utftogbk($address);
            $summary = kekezu::utftogbk($summary);

<?php

defined('ADMIN_KEKE') or die('Access Denied');
kekezu::admin_check_role(32);
$table_name = 'witkey_ad_target';
$target_arr = kekezu::get_table_data('*', $table_name, '', '', '', '', 'target_id', null);
$target_ad_num = kekezu::get_table_data('target_id, count(*) as num', 'witkey_ad', 'target_id is not null', '', 'target_id', '', 'target_id', null);
while (list($key, $value) = each($target_arr)) {
    $target_ad_arr[$key] = $target_ad_num[$key]['num'] ? $target_ad_num[$key]['num'] : '0';
}
require $template_obj->template(ADMIN_DIRECTORY . '/tpl/admin_' . $do . '_' . $view);

 public static function get_prom_type()
 {
     return kekezu::get_table_data("prom_code,prom_item,type", "witkey_prom_rule", "", "", "", "", "prom_code", 3600);
 }

<?php

defined('IN_KEKE') or exit('Access Denied');
$intUserRole = intval($gUserInfo['user_type']);
$footer_load = 1;
$identy_auth_info = kekezu::get_table_data('auth_code,auth_status', 'witkey_auth_record', "uid=" . $gUid, '', '', '', 'auth_code');
if ($intUserRole === 2) {
    $strCodeWh = " auth_code!='realname' ";
    $intAuthStatus = keke_auth_fac_class::auth_check('enterprise', $gUid);
    if ($intUserRole && !$intAuthStatus) {
        $intAuthStatus = 1;
    }
} else {
    $strCodeWh = " auth_code!='enterprise' ";
    $intAuthStatus = keke_auth_fac_class::auth_check('realname', $gUid);
    if ($intUserRole && !$intAuthStatus) {
        $intAuthStatus = 1;
    }
}
$arrAuthItems = keke_auth_base_class::get_auth_item(null, null, 1, $strCodeWh);
$arrAllAuthItems = keke_auth_base_class::get_auth_item(null, null, 1, null);
$keys = array_keys($arrAuthItems);
$arrAllowAuth = array('realname', 'enterprise', 'bank', 'mobile', 'email', 'alipayjs');
if ($code && in_array($code, $arrAllowAuth)) {
    $code or $code = $keys['0'];
    $code or kekezu::show_msg($_lang['param_error'], "index.php?do=auth", 3, '', 'warning');
    $auth_class = "keke_auth_" . $code . "_class";
    $objAuth = new $auth_class($code);
    $auth_item = $arrAllAuthItems[$code];
    $auth_dir = $auth_item['auth_dir'];
    $arrAuthInfo = $objAuth->get_user_auth_info($gUid, 0, $intBankAid);

if ($arrNerLists) {
    foreach ($arrNerLists as $k => $v) {
        $arrNerLists[$k]['pro_city'] = keke_shop_class::getUserAddress($v['uid'], 2, 1, 1, 0);
    }
}
$arrShopIndusC = $kekezu->_indus_c_arr;
$arrShopIndusP = $kekezu->_indus_p_arr;
if (is_array($arrShopIndusC)) {
    $arrNewShopIndusC = array();
    foreach ($arrShopIndusC as $k => $v) {
        $arrNewShopIndusC[$v['indus_pid']][] = $v;
    }
}
$arrDisplaypro = CommonClass::getDistrictByPid('0', 'id,upid,name');
$arrSellerType = array('1' => '个人用户', '2' => '企业用户');
$data = array('地区' => $arrCityone['name'] . $arrCitytwo['name'] . $arrCitythree['name'], '店铺类型' => $arrSellerType[$t], '行业' => $arrIndusPInfo['indus_name'], '子行业' => $arrIndusInfo['indus_name']);
list($strPageTitle, $strPageKeyword, $strPageDescription) = keke_seo_class::getListSEO($pd, $i, $data, 'seller', true);
$floatCashLists = kekezu::get_table_data(' uid,sum(fina_cash) as threeCash', 'witkey_finance', "(fina_action='sale_service' or fina_action='task_bid') and DATE_SUB(CURDATE(),INTERVAL 90 day) <= date(from_unixtime(fina_time))", '', 'uid', '', 'uid');
function thisurl($keys = '')
{
    $pars = parse_url($_SERVER["QUERY_STRING"]);
    $pars = explode("&", $pars['path']);
    foreach ($pars as $ps) {
        $uri = explode("=", $ps);
        $url .= !strstr($keys, $uri[0]) ? "&" . $ps : '';
    }
    return $_SERVER['PHP_SELF'] . '?' . trim($url, "&");
}
$arrFeedPubs = kekezu::get_feed("(feedtype='pub_task' or feedtype='pub_service')", "feed_time desc", 8);
$arrRecommShops = db_factory::query(sprintf("select a.username,a.uid,b.indus_id,b.indus_pid,a.shop_name,if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate from %switkey_shop a " . " left join %switkey_space b on a.uid=b.uid  where b.recommend=1 and b.status=1 and IFNULL(a.is_close,0)=0 and shop_status=1 order by good_rate desc limit 0,5", TABLEPRE, TABLEPRE), 1, $intIndexCacheTime);
$_SESSION['spread'] = 'index.php?do=sellerlist';

<?php

defined('IN_KEKE') or exit('Access Denied');
$strUrl = 'index.php?do=user&view=account&op=binding';
$arrApiNames = keke_glob_class::get_open_api();
$strOauthUrl = $kekezu->_sys_config['website_url'] . "/index.php?do={$do}&view={$view}&op={$op}&ac={$ac}&type={$type}";
$res = kekezu::get_table_data('*', 'witkey_member_oauth', 'uid=' . $gUid, "", "source", 6, "source");
if (is_array($api_open)) {
    foreach ($api_open as $key => $value) {
        $value = array("open" => $value);
        if ($res[$key]) {
            $t[$key] = array_merge($value, $res[$key]);
        } else {
            $t[$key] = $value;
        }
    }
}
switch ($ac) {
    case 'bind':
        if ($type) {
            switch ($type == "alipay_trust") {
                case true:
                    $interface = "sns_bind";
                    require S_ROOT . "/payment/alipay_trust/order.php";
                    header("Location:" . $request);
                    break;
                case false:
                    if (in_array($type, array('sina', 'qq', 'taobao', 'renren', 'douban', 'baidu'))) {
                        $oauth_obj = OAuthClass::factory($type);
                        $oauth_obj->requestAuthorize();
                    } else {

<?php

defined('IN_KEKE') or exit('Access Denied');
$strUrl = 'index.php?do=user&view=account&op=banklist';
$objMemBankT = keke_table_class::get_instance("witkey_member_bank");
$arrBankList = keke_glob_class::get_bank();
if ($action == 'removeBind') {
    if ($intBankId) {
        if ($intBankAid) {
            db_factory::execute(sprintf(" delete from %switkey_auth_bank where bank_a_id='%d'", TABLEPRE, $intBankAid));
            db_factory::execute(sprintf(" delete from %switkey_auth_record where ext_data='%d'", TABLEPRE, $intBankAid));
        }
        $res = db_factory::execute(sprintf(" delete from %switkey_member_bank where bank_id='%d'", TABLEPRE, $intBankId));
        $res and kekezu::show_msg('解除关联成功', $strUrl, null, null, 'ok') or kekezu::show_msg('解除关联失败', $strUrl, null, null, 'error');
    } else {
        kekezu::show_msg('请选择关联账户', null, null, null, null);
    }
} else {
    $arrBankLists = db_factory::query(sprintf(" select * from %switkey_member_bank where uid = '%d' and bind_status='1'", TABLEPRE, $gUid));
    $arrAuthLists = kekezu::get_table_data('bank_a_id,bank_id', "witkey_auth_bank", " uid='.{$gUid}.' and auth_status!=2", '', '', '', 'bank_id', null);
}

 public function get_task_prize()
 {
     $task_prize_arr = kekezu::get_table_data("*", "witkey_task_prize", "task_id={$this->_task_id}", "", "", "", "prize", 0);
     return $task_prize_arr;
 }