public function index()
{
// set rules
$this->_set_page_rule('R');
// set template content
$this->smarty->assign("template_content", "member/pending/index.html");
// list waiting
$rs_id = $this->m_member->get_list_pending_task_waiting(array($this->com_user['role_id'], $this->com_user['airlines_id']));
foreach ($rs_id as $value) {
// get detail rute
$rs_rute = $this->m_member->get_data_rute_by_id(array($value['data_id']));
$total_rute = COUNT($rs_rute);
$list_rute = "";
$x = 1;
foreach ($rs_rute as $rute) {
$x++;
$list_rute .= $rute['airport_iata_cd'];
if ($x <= $total_rute) {
$list_rute .= "-";
}
}
$data[] = array("data_id" => $value['data_id'], "document_no" => $value['document_no'], "data_type" => $value['data_type'], "data_flight" => $value['data_flight'], "date_start" => $value['date_start'], "date_end" => $value['date_end'], "rute_all" => $list_rute, "services_nm" => $value['services_nm'], "task_nm" => $value['task_nm'], "selisih_hari" => $value['selisih_hari'], "selisih_waktu" => $value['selisih_waktu'], "group_link" => $value['group_link']);
}
$this->smarty->assign("rs_id", $rs_id);
// $this->smarty->assign("rs_id", $rs_id);
$this->smarty->assign("total", count($rs_id));
// notification
$this->tnotification->display_notification();
$this->tnotification->display_last_field();
// output
parent::display();
}
public function index()
{
// 取商铺幻灯片
$where = array('type' => 'SHOP');
$scroll_shop = M('scroll')->where($where)->order('sort')->select();
while (COUNT($scroll_shop) < 12) {
$scroll_shop = array_merge($scroll_shop, $scroll_shop);
}
$this->scroll_shop = $scroll_shop;
// 取首页幻灯片
$where = array('type' => 'INDEX');
$this->scroll_index = M('scroll')->where($where)->order('sort')->select();
// 男士服装封面图片
$data = M('picture')->where(array('type' => 'MANCLOTH'))->find();
$this->man_cloth_picture = $data['pic_adr'];
// 女士服装封面图片
$data = M('picture')->where(array('type' => 'WOMANCLOTH'))->find();
$this->woman_cloth_picture = $data['pic_adr'];
// 鞋类封面图片
$data = M('picture')->where(array('type' => 'SHOE'))->find();
$this->shoe_picture = $data['pic_adr'];
// 取QQ
$where = array('type' => 'QQ');
$this->QQ = M('webinfo')->where($where)->find();
$this->display();
}
public function indexAction()
{
$loansearch = new Loandisbursmentg_Form_Search();
$this->view->form = $loansearch;
$this->view->transactiontype = 'Loan transaction';
if ($this->_request->isPost() && $this->_request->getPost('Search')) {
$formData = $this->_request->getPost();
if ($this->_request->isPost()) {
$formData = $this->_request->getPost();
if ($loansearch->isValid($formData)) {
$search = $this->view->loanModel->searchaccounts($this->_request->getParam('accNum'));
if (!$search) {
echo "Enter a valid Number";
} else {
if (COUNT($search) == '1') {
foreach ($search as $account) {
$accountnumber = $account->number;
}
$this->_redirect("/loandisbursmentg/index/disbursment/accNum/" . base64_encode($accountnumber));
} else {
$this->view->accounts = $search;
}
}
}
}
}
}
public function postBuscardni()
{
if (Request::ajax()) {
$dni = Input::get('dni');
$ficha = Input::get('ficha');
$aData = Reniec::getPersona($dni);
$aParametro['data'] = $aData;
$aParametro['rst'] = 1;
$aParametro['msj'] = "";
if (COUNT($aData) == 0) {
$ef = EscalafonFichas::getEFIdporFicha($ficha);
$efr = EscalafonFichas::getEFRIdporFicha($ficha);
$ficham = new Ficha();
if (count($ef) > 0) {
$ficham['escalafon_ficha_id'] = $ef[0]->id;
if (count($efr) > 0) {
$ficham['escalafon_ficha_recepcion_id'] = $efr[0]->id;
}
}
$ficham['ficha'] = $ficha;
$ficham['estado_ficha'] = 3;
$ficham['usuario_created_at'] = Auth::user()->id;
$ficham->save();
$aParametro['rst'] = 2;
$aParametro['msj'] = "No Existe persona con el dni:" . $dni . " Será contabilizada como firma inválida";
}
$vef = Ficha::getValidarEstadoFicha($ficha);
$aParametro['estado'] = $vef;
return Response::json($aParametro);
}
}
public static function DataTable($db_name, $array_data)
{
$list = "<a href='?T=" . $_GET["T"] . "&REQ=DEL_TABLE'>- DELETE TABLE " . strtoupper($_GET["T"]) . "</a><br>";
$list .= "<a href='?T=" . $_GET["T"] . "&REQ=ADD_ENTITIES'>- ADD ENTITIES TO " . strtoupper($_GET["T"]) . "</a><br>";
$list .= "<table>";
//open table
$i = 0;
//iteraction counter
$a = 0;
//get table name
foreach ($array_data[0] as $key => $value) {
if ($i % 2 == 0) {
$list .= "<th>" . $key . "</th>";
$titre[$a] = $key;
$a++;
}
$i++;
}
//get table data
foreach ($array_data as $k => $DATA) {
$list .= "<tr>";
//open row
for ($i = 0; $i < COUNT($DATA) / 2; $i++) {
$list .= "<td>" . $DATA[$i] . "</td>";
}
$list .= "<td><a href='?ID=" . $DATA[0] . "&PRIMARY=" . $titre[0] . "&T=" . $_GET["T"] . "&REQ=UPDATE_DATA'><img src='./Fichiers/images/modifier.png'></a></td>";
$list .= "<td><a href='?ID=" . $DATA[0] . "&PRIMARY=" . $titre[0] . "&T=" . $_GET["T"] . "&REQ=DEL_DATA'><img src='./Fichiers/images/supprimer.png'></a></td>";
$list .= "</tr>";
// close row
}
$list .= "</table>";
//close table
return $list;
}
public function search_func()
{
$make = $this->input->post("chosen_make_box");
echo json_encode($make);
die;
$make = "";
$year = "";
$price = "";
if (isset($_POST['chosen_make_box'])) {
$make = $_POST['chosen_make_box'];
}
if ($_POST['chosen_year_box']) {
$year = $_POST['chosen_year_box'];
}
if ($_POST['chosen_price_tag']) {
$price = $_POST['chosen_price_tag'];
}
echo "<pre>";
print_r($_POST);
die;
$data["result"] = $this->home_m->search_func($make, $year, $price);
$data['rows'] = COUNT($this->home_m->search_func($make, $year, $price));
$data['page_rows'] = 12;
$data['last'] = ceil($data['rows'] / $data['page_rows']);
$data['pagenum'] = 1;
//first page of gallery
print_r($data["result"]);
die;
$data['content_view'] = "index/search_v";
$data['menu'] = "home";
$this->load->view('template/layout', $data);
// echo json_encode($result);
}
public function index()
{
// set page rules
$this->_set_page_rule("R");
// set template content
$this->smarty->assign("template_content", "member/registration_non/list.html");
// list opened form
$rs_id = $this->m_registration->get_list_registration_open(array('bukan niaga', $this->com_user['airlines_id']));
$data = array();
foreach ($rs_id as $value) {
// get detail rute
$rs_rute = $this->m_registration->get_data_rute_by_id(array($value['data_id']));
$total_rute = COUNT($rs_rute);
$list_rute = "";
$x = 1;
foreach ($rs_rute as $rute) {
$x++;
$list_rute .= $rute['airport_iata_cd'];
if ($x <= $total_rute) {
$list_rute .= "-";
}
}
$data[] = array("data_id" => $value['data_id'], "published_no" => $value['published_no'], "data_type" => $value['data_type'], "data_flight" => $value['data_flight'], "date_start" => $value['date_start'], "date_end" => $value['date_end'], "rute_all" => $list_rute, "services_nm" => $value['services_nm'], "flight_no" => $value['flight_no'], "selisih_hari" => $value['selisih_hari'], "selisih_waktu" => $value['selisih_waktu']);
}
$this->smarty->assign("rs_id", $rs_id);
$this->smarty->assign("total", count($rs_id));
// notification
$this->tnotification->display_notification();
$this->tnotification->display_last_field();
// output
parent::display();
}
public function index()
{
// 基础信息
$phone = M('webinfo')->where(array('type' => C('电话')))->field('content')->find();
$middle = explode(' ', $phone['content']);
$this->phone = $middle['0'];
$banquan = M('webinfo')->where(array('type' => C('版权')))->field('content')->find();
$this->banquan = $banquan['content'];
// 明星师资
$teacher = M('teacher')->order('sort')->field('controller,created_time,sort', ture)->select();
for ($i = 0; $i < COUNT($teacher); $i++) {
$teacher[$i]['content'] = mb_substr($teacher[$i]['content'], 0, 78, 'utf-8');
$teacher[$i]['content'] = $teacher[$i]['content'] . "...";
}
$this->teacher = $teacher;
// 历届成绩
$achievement = M('achievement')->order('sort')->field('controller,created_time,sort', ture)->select();
// 遍历取录入情况
for ($i = 0; $i < COUNT($achievement); $i++) {
$str = "";
$data = M('achievement_status')->where(array('achievement_id' => $achievement[$i]['id']))->field('achievement_id', ture)->select();
for ($j = 0; $j < COUNT($data); $j++) {
$str = $str . $data[$j]['school'] . $data[$j]['number'] . '人;';
}
$achievement[$i]['status'] = $str;
}
$this->achievement = $achievement;
// 1977作品
$this->works = M('picture')->where(array('type' => C('作品展示')))->field('controller,created_time,type', ture)->find();
// 教学环境
$this->environment = M('picture')->where(array('type' => C('教学环境')))->field('controller,created_time,type', ture)->find();
$this->display();
}
public static function track($file, $rs = '')
{
$db = Database::getDatabase();
if (SITE_CONFIG_STATS_ONLY_COUNT_UNIQUE == 'yes') {
// check whether the user has already visited today
$sql = "SELECT * FROM stats WHERE ip = " . $db->quote(self::getIP()) . " AND page_title = " . $file->id . " AND DATE(dt) = " . $db->quote(date('Y-m-d'));
$row = $db->getRows($sql);
if (COUNT($row)) {
return false;
}
}
$file->updateVisitors();
$dt = date("Y-m-d H:i:s");
$referer = getenv('HTTP_REFERER');
$referer_is_local = self::refererIsLocal($referer);
$url = full_url();
$img_search = '';
$ip = self::getIP();
$info = self::browserInfo();
$browser_family = $info['browser'];
$browser_version = $info['version'];
$os = $info['platform'];
$os_version = '';
$user_agent = $info['useragent'];
$country = self::getCountry($ip);
$base_url = self::getBaseUrl($referer);
$sql = "INSERT INTO stats (dt, referer, referer_is_local, url, page_title, country, img_search, browser_family, browser_version, os, os_version, ip, user_agent, base_url)\n VALUES (:dt, :referer, :referer_is_local, :url, :page_title, :country, :img_search, :browser_family, :browser_version, :os, :os_version, :ip, :user_agent, :base_url)";
$vals = array('dt' => $dt, 'referer_is_local' => $referer_is_local, 'referer' => $referer, 'url' => $url, 'page_title' => $file->id, 'country' => $country, 'img_search' => $img_search, 'ip' => $ip, 'browser_family' => $browser_family, 'browser_version' => $browser_version, 'os_version' => $os_version, 'os' => $os, 'user_agent' => $user_agent, 'base_url' => $base_url);
$db->query($sql, $vals);
return true;
}
public function getQuestionsFromBD()
{
$str = "";
$str .= "<center>";
$str .= "<table border = '1' id='hor-minimalist-b'><thead><tr><th scope='col'>Libelle</th><th scope='col'>Type</th><th scope='col'>Actions</th></tr></thead>";
$str .= "<tbody>";
for ($i = 0; $i < COUNT($this->mesQuestions); $i++) {
$str .= "<tr id = 'ligne'>";
$str .= "<td>" . $this->mesQuestions[$i]->getLibelle() . "</td>";
if ($this->mesQuestions[$i]->getType() == 0) {
$str .= "<td>OUVERTE</td>";
} else {
if ($this->mesQuestions[$i]->getType() == 1) {
$str .= "<td>FERMEE</td>";
} else {
$str .= "<td>NUMERIQUE</td>";
}
}
$str .= "<td><input type='button' id = 'suppr' value='SUPPRIMER' name='supprimer' onclick ='supprimerQuestion(" . $i . ");'/></td>";
$str .= "</tr>";
}
$str .= "</tbody>";
$str .= "</table>";
$str .= "</center>";
return $str;
}
public function getProduction($type)
{
$classify_id = $_GET['classify'];
if ($classify_id == "" || $classify_id == 0 || $classify_id == null || $classify_id == 'all') {
// 条件
$where = array('type' => $type);
} else {
// 条件
$where = array('type' => $type, 'classify_id' => $classify_id);
}
// 获得当前页数
$pageNumber = $_GET['p'];
if ($pageNumber == "") {
$pageNumber = 0;
}
// 进行分页数据查询 注意page方法的参数的前面部分是当前的页数使用 $_GET[p]获取
$production = M('production')->where($where)->order('sort')->page($pageNumber, C('分页'))->select();
// 查询满足要求的总记录数
$count = M('production')->where($where)->count();
for ($i = 0; $i < COUNT($production); $i++) {
$rebate = $production[$i]['rebate'];
$production[$i]['deduction'] = $rebate / 100 * $production[$i]['price_now'];
}
$perPage = $count / C('分页');
// 数据映射
$this->production = $production;
$this->count = $count;
$this->perPage = $perPage;
$this->classify_id = $classify_id;
}
function count_objects($value)
{
$cart = explode(',', $value);
if (is_null($value)) {
return '0';
}
return COUNT($cart);
}
/**
* Loads the entire menu table into memory.
*
* @return array
*/
public function load()
{
// Initialise variables.
$db = JFactory::getDbo();
$app = JApplication::getInstance('site');
$query = $db->getQuery(true);
$query->select('m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language');
$query->select('m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id');
$query->select('e.element as component');
$query->from('#__menu AS m');
$query->leftJoin('#__extensions AS e ON m.component_id = e.extension_id');
$query->where('m.published = 1');
$query->where('m.parent_id > 0');
$query->where('m.client_id = 0');
$query->order('m.lft');
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// OSE Added - OSE and Open Source Excellence is the registered trade mark of the Open Source Excellence PTE LTD.
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$where = null;
if (file_exists(JPATH_SITE.DS.'components'.DS.'com_osemsc'.DS.'init.php') && file_exists(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_ose_cpu'.DS.'define.php') && !file_exists(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_osemsc'.DS.'installer.dummy.ini'))
{
require_once(JPATH_SITE.DS.'components'.DS.'com_osemsc'.DS.'init.php');
$content_ids = oseRegistry::call('content')->getRestrictedContent('joomla','menu');
$where = (COUNT($content_ids) > 0)?$query->where(' m.id NOT IN ('.implode(',',$content_ids).')'):null;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// OSE Added - OSE and Open Source Excellence is the registered trade mark of the Open Source Excellence PTE LTD.
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Set the query
$db->setQuery($query);
if (!($this->_items = $db->loadObjectList('id'))) {
JError::raiseWarning(500, JText::sprintf('JERROR_LOADING_MENUS', $db->getErrorMsg()));
return false;
}
foreach($this->_items as &$item) {
// Get parent information.
$parent_tree = array();
if (isset($this->_items[$item->parent_id])) {
$parent_tree = $this->_items[$item->parent_id]->tree;
}
// Create tree.
$parent_tree[] = $item->id;
$item->tree = $parent_tree;
// Create the query array.
$url = str_replace('index.php?', '', $item->link);
$url = str_replace('&', '&', $url);
parse_str($url, $item->query);
}
}
function bin2text($bin_str)
{
$text_str = '';
$chars = EXPLODE("\n", CHUNK_SPLIT(STR_REPLACE("\n", '', $bin_str), 8));
$_I = COUNT($chars);
for ($i = 0; $i < $_I; $text_str .= CHR(BINDEC($chars[$i])), $i) {
}
return $text_str;
}
/**
* check user facebook in db
*/
public function checkUserFacebook($iFacebookUserId)
{
$iCount = (int) $this->database()->select(COUNT('*'))->from($this->_sTable)->where('fb_user_id = \'' . $this->database()->escape($iFacebookUserId) . '\'')->execute('getField');
if ($iCount > 0) {
return true;
} else {
return false;
}
}
function __construct($options = null)
{
// get accepted file types
$acceptedFileTypes = getAcceptedFileTypes();
$this->options = array('script_url' => $_SERVER['PHP_SELF'], 'upload_dir' => _CONFIG_FILE_STORAGE_PATH, 'upload_url' => dirname($_SERVER['PHP_SELF']) . '/files/', 'param_name' => 'files', 'delete_hash' => '', 'max_file_size' => $this->get_max_upload_size(), 'min_file_size' => 1, 'accept_file_types' => COUNT($acceptedFileTypes) ? '/(\\.|\\/)(' . str_replace(".", "", implode("|", $acceptedFileTypes)) . ')$/i' : '/.+$/i', 'max_number_of_files' => null, 'discard_aborted_uploads' => true, 'image_versions' => array('thumbnail' => array('upload_dir' => dirname(__FILE__) . '/thumbnails/', 'upload_url' => dirname($_SERVER['PHP_SELF']) . '/thumbnails/', 'max_width' => 80, 'max_height' => 80)));
if ($options) {
$this->options = array_replace_recursive($this->options, $options);
}
}
public function getShopScroll()
{
// 取商铺幻灯片
$where = array('type' => 'SHOP');
$scroll_shop = M('scroll')->where($where)->order('sort')->select();
while (COUNT($scroll_shop) < 16) {
$scroll_shop = array_merge($scroll_shop, $scroll_shop);
}
$this->scroll_shop = $scroll_shop;
}
public function alter_admission_handle()
{
$content = $_POST['content'];
$data = M('admission')->select();
for ($i = 0; $i < COUNT($content); $i++) {
$data[$i] = array('id' => $data[$i]['id'], 'content' => $content[$i], 'controller' => $_SESSION['loginname'], 'created_time' => Date('Y-m-d H:i:s'));
M('admission')->data($data[$i])->save();
}
$this->success('修改成功');
}
public function edit($id)
{
$sql = \DB::select("select s.id,s.consecutive, s.label, s.level, w.watersource_name as name, s.created_at from sampling s\n inner join watersource w on w.id = s.watersource_id\n inner join concession_watersource cw on cw.watersource_id = w.id\n inner join concession c on c.id = cw.concession_id\n inner join entity e on e.id = c.agent_id \n where s.analysis_id = " . $id);
if (COUNT($sql) < 0) {
$sql = \DB::select("select s.id, s.consecutive, s.label, s.level, ss.name, s.created_at from sampling s\n inner join sampling_site ss on ss.id = s.sampling_site_id\n inner join entity e on e.id = ss.agent_id\n where s.analysis_id = " . $id);
}
$view = Auth::user()->getView();
$analysis = Analysis::findOrFail($id);
$entities = Entity::getEntities();
return view('analysis.edit', compact('view', 'analysis', 'entities', 'sql'));
}
static function updateAllLanguageContent($languageId)
{
$db = Database::getDatabase();
/* make sure we have all content records populated */
$getMissingRows = $db->getRows("SELECT id, languageKey, defaultContent FROM language_key WHERE id NOT IN (SELECT languageKeyId FROM language_content WHERE languageId = " . (int) $languageId . ")");
if (COUNT($getMissingRows)) {
foreach ($getMissingRows as $getMissingRow) {
$dbInsert = new DBObject("language_content", array("languageKeyId", "languageId", "content"));
$dbInsert->languageKeyId = $getMissingRow['id'];
$dbInsert->languageId = (int) $languageId;
$dbInsert->content = $getMissingRow['defaultContent'];
$dbInsert->insert();
}
}
}
/**
* Used to fill the array with existing cache items
*
* @return void
*/
private function initCache()
{
// Init the cacheitems
$files = glob($this->path . '/*.val');
$expirations = glob($this->path . '/*.meta');
sort($files);
sort($expirations);
$count = COUNT($files);
for ($i = 0; $i < $count; $i++) {
$key = basename($files[$i]);
$key = preg_replace('/\\.[^.\\s]{3,4}$/', '', $key);
$expiration = unserialize(file_get_contents($expirations[$i]));
$this->cacheItems[] = new \Anax\Cache\CCacheFile($key, null, $expiration);
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new PendidikanM();
$nourut = COUNT(PendidikanM::model()->findAll()) + 1;
$model->pendidikan_urutan = $nourut;
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['PendidikanM'])) {
$model->attributes = $_POST['PendidikanM'];
if ($model->save()) {
$this->redirect(array('admin', 'id' => $model->pendidikan_id));
}
}
$this->render('create', array('model' => $model));
}
public function get_td_innerText(&$tr)
{
$cells = array();
if (IS_ARRAY($tr)) {
for ($i = 0, $n = COUNT($tr); $i < $n; $i++) {
$td = $this->get_htmltag_innerText($tr[$i], 'td');
for ($j = 0, $m = COUNT($td); $j < $m; $j++) {
$cells[$i][$j] = $td[$j];
}
}
//end for
return $cells;
} else {
return false;
}
}
protected function getData()
{
$this->_logger->log(__METHOD__ . ' $this->start_time: ' . print_r($this->start_time, 1));
$this->_logger->log(__METHOD__ . ' $this->end_time: ' . print_r($this->end_time, 1));
$result = ListenerLog::model()->getAllDataInType($this->station_type, $this->start_time, $this->end_time);
$this->_logger->log(__METHOD__ . ' $result COUNT: ' . print_r(COUNT($result), 1));
if (!is_null($result)) {
// $this->schedule_type_report->updateLastReportedMessageData($result[0]->created);
$this->data = $result;
return true;
} else {
$this->data = array();
// $this->schedule_type_report->updateLastReportedMessageData($this->end_time);
return false;
}
}
protected function structuredMatches($matches)
{
$structuredMatches = [];
foreach ($matches as $match) {
$month = date("n", strtotime($match["created_at"]));
$structuredMatches[$this->months[strval($month)]][] = $match["created_at"];
}
$matches = [];
$totalCount = 0;
foreach ($structuredMatches as $key => $structuredMatch) {
$matches[$key] = COUNT($structuredMatch);
$totalCount += $matches[$key];
}
$matches["Totalt"] = $totalCount;
return $matches;
}
protected function index()
{
$this->language->load('module/shopbycolor');
$this->data['heading_title'] = $this->language->get('heading_title');
// definice barev (background, name, search) pro product/search
$this->data['colors'] = array(array('#ffffff', 'Bílá', 'bíl'), array('#ffff00', 'Žlutá', 'žlut'), array('#fb940b', 'Oranžová', 'oranž'), array('#cc0000', 'Červená', 'červ'), array('#ff98bf', 'Růžová', 'růžo'), array('#762ca7', 'Fialová', 'fial'), array('#0000ff', 'Modrá', 'modr'), array('#03c0c6', 'Tyrkysová', 'tyrky'), array('#00cc00', 'Zelená', 'zelen'), array('#999999', 'Šedá', 'šed'), array('#885418', 'Hnědá', 'hněd'), array('#000000', 'Černá', 'čern'), array('#ffd700', 'Zlatá', 'zlat'), array('#dddddd', 'Stříbrná', 'stříb'));
// URL s parametry
$url = "";
// zobrazeni produktu pouze v aktualni kategorii (cislo vybrane kategorie)
if (!isset($_REQUEST['category_id'])) {
//zjisti cisla kategorii z cesty (path)
if (isset($this->request->get['path'])) {
$parts = explode('_', (string) $this->request->get['path']);
} else {
$parts = array();
}
$parts_end = COUNT($parts) - 1;
// posledni kategorie ve strukture
// uloz aktualni kategorii
if (isset($parts[0])) {
$this->data['category_id'] = $parts[$parts_end];
$category_id = $parts[$parts_end];
} else {
$this->data['category_id'] = 0;
$category_id = 0;
}
} else {
// aktualni kategorie
$category_id = $_REQUEST['category_id'];
}
// link pro navigaci (path) + aktualni kategorii (category_id)
if (isset($_REQUEST['path'])) {
// je otevrena nejaka kategorie = cesta
$url .= "&path=" . $_REQUEST['path'];
}
// aktualni kategorie v hierarchii
if ($category_id) {
$url .= "&category_id=" . $category_id;
}
$this->data['link_cat'] = $url;
if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/module/shopbycolor.tpl')) {
$this->template = $this->config->get('config_template') . '/template/module/shopbycolor.tpl';
} else {
$this->template = 'default/template/module/shopbycolor.tpl';
}
$this->render();
}
public function index()
{
// 基础信息
$phone = M('webinfo')->where(array('type' => C('电话')))->field('content')->find();
$this->phone = $phone['content'];
// 读取文章
$data = M('consult')->order('id desc')->field('content,controller', true)->select();
// 取年月日舍去时间
for ($i = 0; $i < COUNT($data); $i++) {
$middle = explode(' ', $data[$i]['created_time']);
$data[$i]['created_time'] = $middle['0'];
}
// 数据映射
$this->consult = $data;
// 模板显示
$this->display();
}
public function alter_contact_handle()
{
// 获取参数
$content = $_POST['content'];
// 读取数据
$data = M('contact')->select();
// 遍历数据
for ($i = 0; $i < COUNT($content); $i++) {
// 构造数据
$data[$i] = array('id' => $data[$i]['id'], 'content' => $content[$i], 'controller' => $_SESSION['loginname'], 'created_time' => Date('Y-m-d H:i:s'));
// 数据更新
if (!M('contact')->data($data[$i])->save()) {
echo 'contact表更新数据错误';
die;
}
}
$this->success('修改成功');
}
private function _loopSearch(array $table, string $method, string $requestUri) : MatchInterface
{
if (COUNT($table) > 0) {
if (!reset($table) instanceof \Hx\Route\InfoInterface) {
throw new \Hx\Route\RouteException("Mapper table's element is not type of \\Hx\\Route\\InfoInterface");
} else {
if ($this->_isMatch(reset($table), $method, $requestUri)) {
preg_match('*^' . reset($table)->getUri() . '$*', $requestUri, $args);
return new \Hx\Route\Match(reset($table), $this->shiftArray($args));
} else {
array_shift($table);
return $this->_loopSearch($table, $method, $requestUri);
}
}
} else {
throw new \Hx\Route\RouteException("No matching candidate for method <{$method}>, uri <{$requestUri}>");
}
}
public function entry()
{
$today = date("d F Y");
$dates = parent::dates();
$months = parent::months();
$years = parent::years_from();
$id = Auth::user()->emp_id();
//R-Open
$rOpen1 = COUNT(DB::table('admin_trackings')->where('completion_status', 'R-Open')->where('initial_risk', 'H-High Risk')->get());
$rOpen2 = COUNT(DB::table('admin_trackings')->where('completion_status', '=', 'R-Open')->where('initial_risk', '=', 'M-Medium Risk')->get());
$rOpen3 = COUNT(DB::table('admin_trackings')->where('completion_status', '=', 'R-Open')->where('initial_risk', '=', 'L-Low Risk')->get());
$rOpen4 = COUNT(DB::table('admin_trackings')->where('completion_status', '=', 'R-Open')->where('initial_risk', '=', 'N-No Risk')->get());
//A-All Ready In Progress
$aAll1 = COUNT(DB::table('admin_trackings')->where('completion_status', '=', 'A-All Ready In Progress')->where('initial_risk', '=', 'H-High Risk')->get());
$aAll2 = COUNT(DB::table('admin_trackings')->where('completion_status', '=', 'A-All Ready In Progress')->where('initial_risk', '=', 'M-Medium Risk')->get());
$aAll3 = COUNT(DB::table('admin_trackings')->where('completion_status', '=', 'A-All Ready In Progress')->where('initial_risk', '=', 'L-Low Risk')->get());
$aAll4 = COUNT(DB::table('admin_trackings')->where('completion_status', '=', 'A-All Ready In Progress')->where('initial_risk', '=', 'N-No Risk')->get());
return View::make('adminTracking/entry')->with('PageName', 'Admin Tracking Entry')->with('dates', $dates)->with('toDay', $today)->with('months', $months)->with('year', $years)->with('personnel', parent::getPersonnelInfo())->with('OH', $rOpen1)->with('OM', $rOpen2)->with('OL', $rOpen3)->with('ON', $rOpen4)->with('AH', $aAll1)->with('AM', $aAll2)->with('AL', $aAll3)->with('AN', $aAll4);
}
