function detail() { global $G; using("area", "industry"); $area = new Areas(); $industry = new Industries(); $tpl_file = "company/detail"; $this->viewhelper->setTitle(L("yellow_page", "tpl")); $this->viewhelper->setPosition(L("yellow_page", "tpl"), "index.php?do=company"); if (isset($_GET['id'])) { $id = intval($_GET['id']); $result = $area->dbstuff->GetRow("SELECT * FROM {$area->table_prefix}companies WHERE id='" . $id . "'"); if (!empty($result)) { $login_check = 1; //default open if (isset($G['setting']['company_logincheck'])) { $login_check = $G['setting']['company_logincheck']; } $this->viewhelper->setTitle($result['name']); $this->viewhelper->setPosition($result['name']); $result['tel'] = pb_hidestr(preg_replace('/\\((.+?)\\)/i', '', $result['tel'])); $result['fax'] = pb_hidestr(preg_replace('/\\((.+?)\\)/i', '', $result['fax'])); $result['mobile'] = pb_hidestr($result['mobile']); $result['industry_names'] = $industry->disSubNames($result['industry_id'], null, true, "company"); $result['area_names'] = $area->disSubNames($result['area_id'], null, true, "company"); setvar("item", $result); setvar("LoginCheck", $login_check); } } render($tpl_file, 1); }
function Search($firstcount, $displaypg) { global $cache_types; uses("space", "industry", "area"); $space = new Space(); $area = new Areas(); $industry = new Industries(); $cache_options = cache_read('typeoption'); $area_s = $space->array_multi2single($area->getCacheArea()); $industry_s = $space->array_multi2single($industry->getIndustry()); $result = $this->findAll("*,name AS title,description AS digest", null, null, $this->orderby, $firstcount, $displaypg); if (!isset($_PB_CACHE['membergroup'])) { require CACHE_PATH . "cache_membergroup.php"; } while (list($keys, $values) = each($result)) { $r = array(); $result[$keys]['pubdate'] = df($values['created']); $result[$keys]['typename'] = $cache_options['manage_type'][$values['manage_type']]; $result[$keys]['thumb'] = $result[$keys]['logo'] = pb_get_attachmenturl($values['picture'], '', 'small'); $result[$keys]['gradeimg'] = URL . 'images/group/' . $_PB_CACHE['membergroup'][$result[$keys]['cache_membergroupid']]['avatar']; $result[$keys]['gradename'] = $_PB_CACHE['membergroup'][$result[$keys]['cache_membergroupid']]['name']; if (!empty($result[$keys]['area_id'])) { $r[] = $area_s[$result[$keys]['area_id']]; } if (!empty($result[$keys]['industry_id'])) { $r[] = $industry_s[$result[$keys]['industry_id']]; } $r[] = L("integrity_index", "tpl") . "(" . $result[$keys]['cache_credits'] . ")"; if (!empty($r)) { $result[$keys]['extra'] = implode(" - ", $r); } $result[$keys]['url'] = $space->rewrite($values['member_id'], $values['id']); } return $result; }
function lists() { global $viewhelper, $pos; using("industry", "area"); $area = new Areas(); $industry = new Industries(); $conditions[] = "Job.status=1"; $viewhelper->setTitle(L("hr_information", "tpl")); $viewhelper->setPosition(L("hr_information", "tpl"), "index.php?do=job&action=" . __FUNCTION__); if (!empty($_GET['q'])) { $title = trim($_GET['q']); $conditions[] = "Job.name like '%" . $title . "%'"; } if (!empty($_GET['data']['salary_id'])) { $conditions[] = "Job.salary_id=" . intval($_GET['data']['salary_id']); } if (!empty($_GET['data']['area_id'])) { $conditions[] = "Job.area_id=" . intval($_GET['data']['area_id']); } if (isset($_GET['industryid'])) { $industry_id = intval($_GET['industryid']); $tmp_info = $industry->setInfo($industry_id); if (!empty($tmp_info)) { $conditions[] = "Job.industry_id=" . $tmp_info['id']; $viewhelper->setTitle($tmp_info['name']); $viewhelper->setPosition($tmp_info['name'], "index.php?do=job&action=" . __FUNCTION__ . "&industryid=" . $tmp_info['id']); } } if (isset($_GET['areaid'])) { $area_id = intval($_GET['areaid']); $tmp_info = $area->setInfo($area_id); if (!empty($tmp_info)) { $conditions[] = "Job.area_id=" . $tmp_info['id']; $viewhelper->setTitle($tmp_info['name']); $viewhelper->setPosition($tmp_info['name'], "index.php?do=job&action=" . __FUNCTION__ . "&areaid=" . $tmp_info['id']); } } $amount = $this->job->findCount(null, $conditions, "Job.id"); $result = $this->job->findAll("Job.*,Job.cache_spacename AS userid,Job.created AS pubdate,(select Company.name from " . $this->job->table_prefix . "companies Company where Company.id=Job.id) AS companyname", null, $conditions, "Job.id DESC", $pos, $this->displaypg); $viewhelper->setTitle(L("search", "tpl")); $viewhelper->setPosition(L("search", "tpl")); setvar("items", $result); setvar("paging", array('total' => $amount)); render("job/list", 1); }
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2205 $ */ require "../libraries/common.inc.php"; require "room.share.php"; require PHPB2B_ROOT . 'libraries/page.class.php'; check_permission("offer"); $tpl_file = "offer"; $page = new Pages(); uses("trade", "tradefield", "product", "tag", "attachment", "form", "typeoption", "point", "industry", "area"); $attachment = new Attachment("pic"); $area = new Areas(); $industry = new Industries(); $form = new Forms(); $point = new Points(); $tradefield = new Tradefields(); $tag = new Tags(); $trade = new Trades(); $trade_controller = new Trade(); $typeoption = new Typeoption(); $conditions = array(); $conditions[] = "member_id = " . $the_memberid; setvar("TradeTypes", $trade_controller->getTradeTypes()); setvar("TradeNames", $trade_controller->getTradeTypeNames()); $tmp_personalinfo = $memberinfo; setvar("MemberInfo", $tmp_personalinfo); $expires = $trade_controller->getOfferExpires(); setvar("TradeTypes", $trade_controller->getTradeTypes());
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2075 $ */ require "../libraries/common.inc.php"; require LIB_PATH . 'page.class.php'; require "session_cp.inc.php"; require LIB_PATH . "cache.class.php"; require CACHE_COMMON_PATH . "cache_type.php"; $_PB_CACHE['industry'] = cache_read("industry"); uses("industry", "typeoption"); $cache = new Caches(); $typeoption = new Typeoption(); $industry = new Industries(); $condition = null; $conditions = array(); $tpl_file = "industry"; $page = new Pages(); setvar("Types", $_PB_CACHE['industrytype']); $cache_items = $_PB_CACHE['industry']; setvar("AskAction", $typeoption->get_cache_type("common_option")); if (isset($_POST['del'])) { if (!empty($_POST['id'])) { $industry->del($_POST['id']); } } if (isset($_POST['hide_batch'])) { if (!empty($_POST['id'])) { $industry->saveField('available', 0, $_POST['id']);
* [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2083 $ */ session_cache_limiter('nocache'); require "../libraries/common.inc.php"; require "session_cp.inc.php"; require CACHE_COMMON_PATH . "cache_type.php"; uses("friendlink", "industry", "typeoption", "area"); require PHPB2B_ROOT . 'libraries/page.class.php'; $link = new Friendlinks(); $page = new Pages(); $area = new Areas(); $industry = new Industries(); $industry = new Industries(); $typeoption = new Typeoption(); $conditions = null; $tpl_file = "friendlink"; setvar("AskAction", $typeoption->get_cache_type("common_option")); if (!empty($_PB_CACHE['friendlinktype'])) { setvar("FriendlinkTypes", $_PB_CACHE['friendlinktype']); } if (isset($_POST['save']) && !empty($_POST['data']['friendlink']['title'])) { $vals = array(); $vals = $_POST['data']['friendlink']; if (isset($_POST['id'])) { $id = intval($_POST['id']); } if (!preg_match("/^(http|ftp):/", $_POST['data']['friendlink']['url'])) { $vals['url'] = 'http://' . $_POST['data']['friendlink']['url'];
/** * search * @list */ function lists() { global $G, $viewhelper, $pos; uses("trade", "industry", "area", "tradefield", "form", "tag"); $trusttypes = cache_read("trusttype"); $countries = cache_read("country"); $membergroups = cache_read("membergroup"); $area = new Areas(); $offer = new Tradefields(); $trade = new Trades(); $form = new Forms(); $industry = new Industries(); $tag = new Tags(); $conditions = array(); $industry_id = $area_id = 0; $conditions[] = "t.status=1"; !empty($_GET) && ($_GET = clear_html($_GET)); if (isset($_GET['navid'])) { setvar("nav_id", intval($_GET['navid'])); } $viewhelper->setTitle(L('offer', 'tpl')); $viewhelper->setPosition(L('offer', 'tpl'), "index.php?do=offer"); $trade_types = cache_read("type", "offertype"); if (isset($_GET['typeid'])) { $type_id = intval($_GET['typeid']); $conditions[] = "t.type_id='" . $type_id . "'"; setvar("typeid", $type_id); $type_name = $trade_types[$type_id]; $viewhelper->setTitle($type_name); $viewhelper->setPosition($type_name, "index.php?do=offer&action=lists&typeid=" . $type_id); } if (isset($_GET['industryid'])) { $industry_id = intval($_GET['industryid']); $tmp_info = $industry->setInfo($industry_id); if (!empty($tmp_info)) { $sub_ids = $industry->getSubDatas($tmp_info['id']); $sub_ids = array_keys($sub_ids); $conditions[] = "t.industry_id IN (" . implode(",", $sub_ids) . ")"; $viewhelper->setTitle($tmp_info['name']); $viewhelper->setPosition($tmp_info['name'], "index.php?do=offer&action=lists&industryid=" . $tmp_info['id']); } } if (isset($_GET['areaid'])) { $area_id = intval($_GET['areaid']); $tmp_info = $area->setInfo($area_id); if (!empty($tmp_info)) { $sub_ids = $area->getSubDatas($tmp_info['id']); $sub_ids = array_keys($sub_ids); $conditions[] = "t.area_id IN (" . implode(",", $sub_ids) . ")"; $viewhelper->setTitle($tmp_info['name']); $viewhelper->setPosition($tmp_info['name'], "index.php?do=offer&action=lists&areaid=" . $tmp_info['id']); } } if (isset($_GET['type'])) { if ($_GET['type'] == "urgent") { $conditions[] = "t.if_urgent='1'"; } } if (!empty($_GET['price_start']) || !empty($_GET['price_end'])) { $conditions[] = "t.price BETWEEN " . intval($_GET['price_start']) . " AND " . intval($_GET['price_end']); } if (!empty($_GET['picture'])) { $conditions[] = "t.picture!=''"; } if (!empty($_GET['urgent'])) { $conditions[] = "t.if_urgent=1"; } if (!empty($_GET['commend'])) { $conditions[] = "t.if_commend=1"; } if (!empty($_GET['country'])) { $conditions[] = "t.country_id='" . intval($_GET['country']) . "'"; } if (!empty($_GET['sure'])) { $conditions[] = "m.trusttype_ids='" . intval($_GET['sure']) . "'"; } if (!empty($_GET['date'])) { $d = intval($_GET['date']); if ($d <= 7948800) { $conditions[] = "t.submit_time<='" . intval($_GET['date']) . "'"; } } if (isset($_GET['q'])) { $searchkeywords = $_GET['q']; $viewhelper->setTitle(L("search_in_keyword", "tpl", $searchkeywords)); $viewhelper->setPosition(L("search_in_keyword", "tpl", $searchkeywords)); $conditions[] = "t.title like '%" . $searchkeywords . "%'"; setvar("highlight_str", $searchkeywords); } if (isset($_GET['pubdate'])) { switch ($_GET['pubdate']) { case "l3": $conditions[] = "t.submit_time>" . ($offer->timestamp - 3 * 86400); break; case "l10": $conditions[] = "t.submit_time>" . ($offer->timestamp - 10 * 86400); break; case "l30": $conditions[] = "t.submit_time>" . ($offer->timestamp - 30 * 86400); break; default: break; } } if ($G['setting']['offer_expire_method'] == 2 || $G['setting']['offer_expire_method'] == 3) { $conditions[] = "t.expire_time>" . $offer->timestamp; } $amount = $trade->findCount(null, $conditions, null, "t"); $result = $trade->getRenderDatas($conditions, $G['setting']['offer_filter']); $important_result = $trade->getStickyDatas(); setvar("StickyItems", $important_result); setvar('items', $result); setvar('trusttype', $trusttypes); setvar('countries', $countries); setvar("paging", array('total' => $amount)); render("offer/list"); }
<?php /** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2048 $ */ define('CURSCRIPT', 'content'); require "../libraries/common.inc.php"; require "../share.inc.php"; uses("product", "company", "member", "form", "tag", "area", "industry"); $company = new Companies(); $area = new Areas(); $industry = new Industries(); $tag = new Tags(); $member = new Members(); $product = new Products(); $form = new Forms(); $tmp_status = explode(",", L('product_status', 'tpl')); $viewhelper->setPosition(L("product_center", 'tpl'), 'product/'); $viewhelper->setTitle(L("product_center", 'tpl')); if (isset($_GET['title'])) { $title = rawurldecode(trim($_GET['title'])); $res = $product->findByName($title); $id = $res['id']; } if (isset($_GET['id'])) { $id = intval($_GET['id']); } $info = $product->getProductById($id);
<?php /** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2223 $ */ require "../libraries/common.inc.php"; require "room.share.php"; require LIB_PATH . 'time.class.php'; uses("job", "typeoption", "area", "industry"); check_permission("job"); $job = new Jobs(); $area = new Areas(); $industry = new Industries(); $typeoption = new Typeoption(); $tpl_file = "job"; if (!$company->Validate($companyinfo)) { flash("pls_complete_company_info", "company.php", 0); } if (isset($_GET['do'])) { $do = trim($_GET['do']); if (isset($_GET['id'])) { $id = intval($_GET['id']); } if ($do == "del" && !empty($id)) { $job->del($id, "member_id=" . $the_memberid); } if ($do == "edit") { setvar("Genders", $typeoption->get_cache_type('gender'));
$file->rmDirs(DATA_PATH . "dbcache", false, false); $file->rmDirs(DATA_PATH . "dbcache", false, true); } flash("success", "htmlcache.php?do=clear"); break; case "update": if (in_array("area", $_POST['data']['type'])) { $cache->writeCache("area", "area"); $cache->writeCache("country", "country"); } if (in_array("options", $_POST['data']['type'])) { $cache->updateTypevars(); } if (in_array("industry", $_POST['data']['type'])) { uses("industry"); $industry = new Industries(); $industry->updateCache(); $cache->writeCache("industry", "industry"); } if (in_array("language", $_POST['data']['type'])) { $cache->updateLanguages(); } if (in_array("setting", $_POST['data']['type'])) { $cache->updateIndexCache(); $cache->updateTypes(); $cache->writeCache("setting", "setting"); $cache->writeCache("nav", "nav"); } if (in_array("ext", $_POST['data']['type'])) { $cache->writeCache("userpage", "userpage"); $cache->writeCache("trusttype", "trusttype");
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2133 $ */ require "../libraries/common.inc.php"; require "room.share.php"; uses("product", "producttype", "form", "attachment", "tag", "brand", "productcategory", "area", "industry"); require PHPB2B_ROOT . 'libraries/page.class.php'; require CACHE_PATH . 'cache_membergroup.php'; require CACHE_PATH . 'cache_type.php'; check_permission("product"); $area = new Areas(); $industry = new Industries(); $productcategory = new Productcategories(); $page = new Pages(); $brand = new Brands(); $tag = new Tags(); $form = new Forms(); $product = new Products(); $producttype = new Producttypes(); $attachment = new Attachment('pic'); $conditions[] = "member_id = " . $the_memberid; setvar("Countries", $countries = cache_read("country")); setvar("ProductSorts", $_PB_CACHE['productsort']); setvar("ProductTypes", $producttype->findAll('id,name', null, $conditions, "id DESC")); setvar("Productcategories", $productcategory->getTypeOptions()); $tpl_file = "product"; if (!$company->Validate($companyinfo)) {
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2214 $ */ function smarty_function_get($params, &$smarty) { $op = null; extract($params); global $tb_prefix, $pdb; if (empty($var)) { $var = "item"; } if (!empty($from)) { switch ($from) { case "market": $num = 4; if (isset($params['row'])) { $num = intval($params['row']); } $latest_commend_markets = $industry->GetArray("SELECT * FROM " . $tb_prefix . "markets WHERE if_commend='1' AND status='1' AND picture!='' ORDER BY id DESC LIMIT " . $num); $urls = $infos = $images = array(); if (!empty($latest_commend_markets)) { while (list($key, $val) = each($latest_commend_markets)) { $urls[] = $industry->getPermaLink($val['id'], null, 'market'); $infos[] = pb_lang_split($val['name']); $images[] = pb_get_attachmenturl($val['picture'], '', $size); } $items['url'] = implode("|", $urls); $items['info'] = implode("|", $infos); $items['image'] = implode("|", $images); $return = $items; } break; case "area": if (class_exists("Areas")) { $area = new Areas(); } else { uses("area"); $area = new Areas(); } $return = $area->getLevelAreas(); break; case "industry": //depth if (class_exists("Industries")) { $industry = new Industries(); $obj_controller = new Industry(); } else { uses("industry"); $industry = new Industries(); $obj_controller = new Industry(); } $return = $industry->getCacheIndustry(); break; case "type": if (!empty($name)) { //depth if (class_exists("Industries")) { $industry = new Industries(); $obj_controller = new PbController(); } else { uses("industry"); $industry = new Industries(); $obj_controller = new PbController(); } $name = $obj_controller->pluralize($name); $industry->findIt($name); $return = $industry->params['data'][1]; if (isset($multi)) { $return = $obj_controller->flatten_array($return); } if (empty($var)) { $var = "Items"; } } break; default: $return = cache_read($name, $key); break; } } if (!empty($sql)) { //replace table prefix $pdb->setFetchMode(ADODB_FETCH_ASSOC); $sql = str_replace("pb_", $tb_prefix, $sql); //for secure if (eregi('insert|update|delete|union|into|load_file|outfile|replace', $sql)) { trigger_error('no supported sql.'); } //mysql_escape_string() $return = $industry->GetArray($sql); } if (isset($name)) { switch ($name) { case "language": global $G; $languages = unserialize($G['setting']['languages']); if (!empty($languages)) { if (!isset($echo)) { $smarty->assign($var, $languages); } else { foreach ($languages as $lang_key => $lang_val) { $tmp = "<a href='" . URL . 'redirect.php?url=' . pb_getenv("REQUEST_URI") . "&app_lang=" . $lang_key . "' title='" . $lang_val['title'] . "'>"; if ($image && !empty($lang_val['img'])) { $tmp .= "<img src='" . $lang_val['img'] . "' alt='" . $lang_val['title'] . "' />"; } else { $tmp .= $lang_val['title']; } $tmp .= "</a>"; if ($sep) { $tmp .= $sep; } if (isset($title_li) && $title_li == "list") { $op .= "<li>" . $tmp . "</li>"; } else { $op .= $tmp; } } } } break; case "nav": $_nav = cache_read("nav"); $navs = $_nav['navs']; if (!empty($exclude)) { $_exclude_navs = explode(",", $exclude); foreach ($_exclude_navs as $_exkey => $_exval) { unset($navs[$_exval]); } } if (empty($echo)) { $smarty->assign($var, $navs); } else { foreach ($navs as $nav) { $op .= '<li id="mn_' . $nav['id'] . '" class="nav_item nav-item-' . $nav['id']; $file_name = pb_getenv('REQUEST_URI'); if (strpos($file_name, $nav['url']) !== false && $nav['url'] != 'index.php') { $op .= ' current_nav_item'; } $op .= '"><a href="' . $nav['url'] . '" target="_self"><span>' . pb_lang_split($nav['name']) . '</span></a></li>'; } } break; default: if (is_file(CACHE_COMMON_PATH . "cache_" . $name . ".php")) { require CACHE_COMMON_PATH . "cache_" . $name . ".php"; } if (isset($_PB_CACHE)) { $smarty->assign($var, $_PB_CACHE); } break; } } if (!empty($return)) { $smarty->assign($var, $return); } return $op; }
<div class="icon-wrapper"> <?php $industries = $fields['charts'][0]['industries']; ?> <script> var barArray = JSON.parse( '<?php echo json_encode(array_column($industries, "industry")); ?> ' );</script> <?php foreach ($industries as $key => $industry) { ?> <div class="icon"> <?php $industriesClass = new Industries(); $industryInfo = $industriesClass->getIndustryList($industry['industry']); ?> <img src="/wp-content/themes/digital-river-translated/img/crossborder/<?php echo $industryInfo['img']; ?> " /> <span><?php echo $industryInfo['label']; ?> </span> <span data-barid="<?php echo $key; ?> " class="score"></span> </div>
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2154 $ */ require "../libraries/common.inc.php"; require "room.share.php"; require LIB_PATH . 'time.class.php'; require LIB_PATH . 'validation.class.php'; $validate = new Validation(); check_permission("company"); uses("industry", "area", "attachment", "companyfield", "typeoption"); $attachment = new Attachment('pic'); $area = new Areas(); $industry = new Industries(); $companyfield = new Companyfields(); $typeoption = new Typeoption(); $tpl_file = "company"; if (isset($_POST['do']) && !empty($_POST['data']['company'])) { pb_submit_check('data'); $vals = $_POST['data']['company']; $company->doValidation($vals); if (!empty($company->validationErrors)) { setvar("item", $vals); setvar("Errors", $validate->show($company)); template($tpl_file, true); } if (isset($companyinfo)) { if (empty($companyinfo['name'])) { $i18n = new L10n();
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2124 $ */ function smarty_function_get($params, &$smarty) { extract($params); global $tb_prefix, $pdb; if (empty($var)) { $var = "item"; } //depth if (class_exists("Industries")) { $industry = new Industries(); $obj_controller = new Industry(); } else { uses("industry"); $industry = new Industries(); $obj_controller = new Industry(); } switch ($from) { case "market": $latest_commend_markets = $industry->GetArray("SELECT * FROM " . $tb_prefix . "markets WHERE if_commend='1' AND status='1' AND picture!='' ORDER BY id DESC LIMIT 0,10"); $urls = $infos = $images = array(); if (!empty($latest_commend_markets)) { while (list($key, $val) = each($latest_commend_markets)) { $urls[] = $industry->getPermaLink($val['id'], null, 'market'); $infos[] = $val['name']; $images[] = pb_get_attachmenturl($val['picture'], '', $size); } $items['url'] = implode("|", $urls); $items['info'] = implode("|", $infos); $items['image'] = implode("|", $images); $return = $items; } break; case "area": if (class_exists("Areas")) { $area = new Areas(); } else { uses("area"); $area = new Areas(); } $return = $area->getLevelAreas(); break; case "industry": $return = $industry->getCacheIndustry(); break; case "type": if (!empty($name)) { $name = $obj_controller->pluralize($name); $industry->findIt($name); $return = $industry->params['data'][1]; if (isset($multi)) { $return = $obj_controller->flatten_array($return); } if (empty($var)) { $var = "Items"; } } break; default: $return = cache_read($name, $key); break; } if (!empty($sql)) { //replace table prefix $pdb->setFetchMode(ADODB_FETCH_ASSOC); $sql = str_replace("pb_", $tb_prefix, $sql); //for secure if (eregi('insert|update|delete|union|into|load_file|outfile|replace', $sql)) { trigger_error('no supported sql.'); } //mysql_escape_string() $return = $industry->GetArray($sql); } $smarty->assign($var, $return); unset($return, $from, $item); }
<?php echo $form->dropDownList($model, 'experience', $this->getExperienceList(), array('class' => 'form-control', 'empty' => 'Select Experience')); ?> <?php echo $form->error($model, 'experience'); ?> </div> </div> <div class="form-group"> <?php echo $form->labelEx($model, 'industry', array('class' => 'col-sm-offset-2 col-sm-2')); ?> <div class="col-sm-6"> <?php $list = CHtml::listData(Industries::model()->findAll(array('order' => 'industry')), 'id', 'industry'); ?> <?php echo $form->dropDownList($model, 'industry', $list, array('class' => 'form-control', 'empty' => 'Select Category', 'style' => 'text-transform: capitalize', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('functionalAreas', array('form' => 'User')), 'update' => '#User_functional_area'))); ?> <?php echo $form->error($model, 'industry'); ?> </div> </div> <div class="form-group"> <?php echo $form->labelEx($model, 'functional_area', array('class' => 'col-sm-offset-2 col-sm-2')); ?> <div class="col-sm-6">
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2193 $ */ function smarty_block_industry($params, $content, &$smarty, &$repeat) { $conditions = array(); $param_count = count($smarty->_tag_stack); if (empty($params['name'])) { $params['name'] = "industry"; } if (class_exists("Industries")) { $industry = new Industries(); $industry_controller = new Industry(); } else { uses("industry"); $industry = new Industries(); $industry_controller = new Industry(); } $conditions[] = "available=1"; if (isset($params['depth'])) { //depth if ($params['depth'] == -1) { if (!empty($_GET['level']) && !isset($_GET['areaid'])) { $conditions['level'] = "level=" . intval($_GET['level']); } else { $conditions['level'] = "level=1"; } } } if (!empty($params['typeid'])) { $conditions[] = "indusrytype_id=" . $params['typeid']; } if (!empty($params['id'])) { $conditions[] = "id=" . $params['id']; } if (!empty($params['topid'])) { $conditions[] = "top_parentid='" . $params['topid'] . "'"; } if (!empty($params['level'])) { $conditions['level'] = "level=" . $params['level']; } if (!empty($params['parentid'])) { $conditions[] = "parent_id='" . $params['parentid'] . "' OR id=" . intval($params['parentid']); } elseif (isset($_GET['parentid'])) { $i_id = intval($_GET['parentid']); $conditions[] = "parent_id='" . $i_id . "' OR id=" . $i_id; } if (!empty($params['topparentid'])) { $conditions[] = "top_parentid='" . $params['topparentid'] . "'"; } if (!empty($params['exclude'])) { $conditions[] = "id NOT IN (" . $params['exclude'] . ")"; } if (!empty($params['include'])) { $conditions[] = "id IN (" . $params['include'] . ")"; } $orderby = null; if (isset($params['orderby'])) { $orderby = " ORDER BY " . trim($params['orderby']) . " "; } else { $orderby = " ORDER BY id DESC"; } $industry->setCondition($conditions); $limit = $offset = 0; if (isset($params['row'])) { $limit = $params['row']; } if (isset($params['start'])) { $offset = $params['start']; } if (!empty($limit)) { $industry->setLimitOffset($offset, $limit); } else { $industry->limit_offset = 0; } $sql = "SELECT id,name,level,name as title,alias_name,highlight,url,parent_id FROM {$industry->table_prefix}industries i " . $industry->getCondition() . "{$orderby}" . $industry->getLimitOffset(); $industry->dbstuff->setFetchMode(ADODB_FETCH_ASSOC); if (empty($smarty->blockvars[$param_count])) { $smarty->blockvars[$param_count] = $industry->GetArray($sql); if (!$smarty->blockvars[$param_count]) { return $repeat = false; } } if (!function_exists("smarty_function_the_url")) { require "function.the_url.php"; } if (list($key, $item) = each($smarty->blockvars[$param_count])) { $repeat = true; if (!empty($item['url'])) { $url = $item['url']; } else { $url = smarty_function_the_url(array("module" => "special", "type" => "industry", "id" => $item['id'], "do" => $smarty->_tpl_vars['do'])); } $item['url'] = $url; if (isset($params['titlelen'])) { $item['title'] = mb_substr(strip_tags($item['title']), 0, $params['titlelen']); } $item['style'] = parse_highlight($item['highlight']); $item['link'] = '<a title="' . $item['name'] . '" href="' . $url . '">' . $item['title'] . '</a>'; if (isset($_GET['industryid'])) { $id = intval($_GET['industryid']); if ($id > 0 && $id == $item['id']) { $item['child'] = $industry->GetArray("SELECT *,name AS title FROM {$industry->table_prefix}industries WHERE parent_id=" . $id . " AND available=1 ORDER BY display_order ASC"); } } $smarty->assign($params['name'], $item); } else { $repeat = false; reset($smarty->blockvars[$param_count]); } if (!is_null($content)) { print $content; } if (!$repeat) { $smarty->blockvars[$param_count] = array(); } }
/** * [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved. * The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2116 $ */ function smarty_block_offer($params, $content, &$smarty, &$repeat) { global $_PB_CACHE; $conditions[] = "t.status='1'"; $param_count = count($smarty->_tag_stack); if (empty($params['name'])) { $params['name'] = "offer"; } if (!class_exists("Trades")) { uses("trade"); $trade = new Trades(); $trade_controller = new Trade(); } else { $trade = new Trades(); $trade_controller = new Trade(); } if ($_PB_CACHE['setting']['offer_expire_method']) { switch ($_PB_CACHE['setting']['offer_expire_method']) { case "2": $conditions[] = "t.expire_time>" . $trade->timestamp; break; case "3": $conditions[] = "t.expire_time>" . $trade->timestamp; break; default: break; } } if (isset($params['type'])) { $type = explode(",", $params['type']); $type = array_unique($type); foreach ($type as $val) { switch ($val) { case 'image': $conditions[] = "t.picture!=''"; break; case 'urgent': $conditions[] = "t.if_urgent='1'"; break; case 'company': $conditions[] = "t.company_id>0"; break; case 'commend': $conditions[] = "t.if_commend>0"; break; default: break; } } } if (isset($params['industryid'])) { if (isset($params['depth'])) { $depth = intval($params['depth']); if ($depth) { if (class_exists("Industries")) { $industry = new Industries(); $industry_controller = new Industry(); } else { uses("industry"); $industry = new Industries(); $industry_controller = new Industry(); } $ids_s = $industry->getConditionIds($params['industryid']); if (is_array($ids_s)) { $ids_s = array_filter($ids_s); $conditions['industry'] = "t.industry_id IN (" . implode(",", $ids_s) . ")"; } else { $conditions['industry'] = "t.industry_id='" . $ids_s . "'"; } } } else { $conditions[] = "t.industry_id = '" . $params['industryid'] . "'"; } } if (isset($params['areaid'])) { if (isset($params['depth'])) { $depth = intval($params['depth']); if ($depth) { global $industry; $ids_s = $industry->getConditionIds($params['areaid']); if (is_array($ids_s)) { $ids_s = array_filter($ids_s); $conditions['area'] = "t.area_id IN (" . implode(",", $ids_s) . ")"; } else { $conditions['area'] = "t.area_id='" . $ids_s . "'"; } } } else { $conditions['area'] = "t.area_id = '" . $params['areaid'] . "'"; } } if (!empty($_GET['industryid'])) { $conditions['industry'] = "t.industry_id=" . intval($_GET['industryid']); } if (!empty($_GET['areaid'])) { $conditions['area'] = "t.area_id=" . intval($_GET['areaid']); } if (isset($params['exclude'])) { $conditions[] = $trade->getExcludeIds($params['exclude']); } if (isset($params['include'])) { $conditions[] = $trade->getIncludeIds($params['include']); } if (isset($params['country_id'])) { $conditions[] = "t.country_id='" . $params['country_id'] . "'"; } if (isset($params['expday'])) { $conditions[] = "t.expire_time<'" . ($params['expday'] * 86400 + $trade->timestamp) . "'"; } if (isset($params['subday'])) { $conditions[] = "t.submit_time>'" . ($trade->timestamp - $params['expireday'] * 86400) . "'"; } if (isset($params['typeid'])) { if (!empty($params['typeid'])) { if (strpos($params['typeid'], ",") > 0) { $tmp_ids = explode(",", $params['typeid']); $conditions[] = "t.type_id in ('" . implode("','", $tmp_ids) . "')"; } else { $conditions[] = "t.type_id='" . $params['typeid'] . "'"; } } } if (isset($params['urgent'])) { $conditions[] = "t.if_urgent='1'"; } if (!empty($params['memberid'])) { $conditions[] = "t.member_id='" . $params['memberid'] . "'"; } if (!empty($params['companyid'])) { $conditions[] = "t.company_id='" . $params['companyid'] . "'"; } if (isset($params['cash'])) { $conditions[] = "t.require_point>0"; } $trade->setCondition($conditions); $orderby = null; $orderby = isset($params['orderby']) ? " ORDER BY " . trim($params['orderby']) . " " : " ORDER BY modified DESC"; $limit = $offset = 0; if (isset($params['row'])) { $limit = $params['row']; } if (isset($params['start'])) { $offset = $params['start']; } if (isset($_GET['pos'])) { $offset = intval($_GET['pos']); } $trade->setLimitOffset($offset, $limit); $mysql_limit = $trade->getLimitOffset(); if (isset($params['limit'])) { $mysql_limit = " " . trim($params['limit']); } if (!$params['recursive']) { $sql = "SELECT *,title as name,title as fulltitle,content as fullcontent FROM {$trade->table_prefix}trades t " . $trade->getCondition() . "{$orderby}" . $mysql_limit; } else { $sql = "SELECT *,content as fullcontent FROM {$trade->table_prefix}trades t " . $trade->getCondition() . " ORDER BY t.display_order ASC,t.id DESC" . $mysql_limit; } $offer_typenames = $trade_controller->getTradeTypes(); if (empty($smarty->blockvars[$param_count])) { $smarty->blockvars[$param_count] = $trade->GetArray($sql); if (!$smarty->blockvars[$param_count]) { return $repeat = false; } } if (!function_exists("smarty_function_the_url")) { require "function.the_url.php"; } if (list($key, $item) = each($smarty->blockvars[$param_count])) { $repeat = true; $item['rownum'] = $key; $item['iteration'] = ++$key; $url = smarty_function_the_url(array("id" => $item['id'], "typeid" => $item['type_id'], "module" => "offer")); $item['url'] = $url; $item['title'] = strip_tags($item['title']); $item['content'] = strip_tags($item['content']); if (isset($params['titlelen'])) { $item['title'] = mb_substr($item['title'], 0, $params['titlelen']); } if (isset($params['infolen'])) { $item['content'] = mb_substr($item['content'], 0, $params['infolen']); } if (isset($params['titlestart'])) { $item['title'] = $params['titlestart'] . $item['title']; } $item['pubdate'] = df($item['submit_time']); $item['typeid'] = $item['type_id']; $item['typename'] = $offer_typenames[$item['type_id']]; $item['src'] = $item['thumb'] = URL . "attachment/" . $item['picture'] . ".small.jpg"; $item['link'] = '<a title="' . $item['fulltitle'] . '" href="' . $url . '">' . $item['title'] . '</a>'; $item['style'] = parse_highlight($item['highlight']); $smarty->assign($params['name'], $item); } else { $repeat = false; reset($smarty->blockvars[$param_count]); } if (!is_null($content)) { print $content; } if (!$repeat) { $smarty->blockvars[$param_count] = array(); } }
* * @version $Revision: 2048 $ */ define('CURSCRIPT', 'list'); require "../libraries/common.inc.php"; require "../share.inc.php"; uses("trade", "industry", "area", "tradefield", "form"); require CACHE_PATH . 'cache_trusttype.php'; require CACHE_PATH . 'cache_country.php'; require CACHE_PATH . 'cache_membergroup.php'; $area = new Areas(); $offer = new Tradefields(); $trade = new Trades(); $trade_controller = new Trade(); $form = new Forms(); $industry = new Industries(); $conditions = array(); $industry_id = $area_id = 0; $conditions[] = "t.status=1"; if (isset($_GET['navid'])) { setvar("nav_id", intval($_GET['navid'])); } uses("tag"); $tag = new Tags(); $viewhelper->setTitle(L('offer', 'tpl')); $viewhelper->setPosition(L('offer', 'tpl'), "offer/"); if (isset($_GET['typeid'])) { $type_id = intval($_GET['typeid']); $conditions[] = "t.type_id='" . $type_id . "'"; setvar("typeid", $type_id); $trade_controller->setTypeInfo($type_id);