public function getComment($article_id, $size) { $comment_model = D('message'); $condition = !empty($article_id) ? array('article_id' => $article_id) : array(); $count = $comment_model->where($condition)->count(); $page = new \Think\Page($count, $size); $show = $page->show(); $list = $comment_model->where($condition)->order('addtime desc')->limit($page->firstRow . ',' . $page->listRows)->select(); foreach ($list as $k => $v) { $list[$k]['formatTime'] = timeFormat($v['addtime']); } $data['list'] = $list; $data['page'] = $show; return $data; }
public function json_user_list() { global $_M; $groupid = $_M['form']['groupid']; $keyword = $_M['form']['keyword']; $search = $groupid ? "and groupid = '{$groupid}'" : ''; $search .= $keyword ? "and (username like '%{$keyword}%' || email like '%{$keyword}%' || tel like '%{$keyword}%')" : ''; $table = load::sys_class('tabledata', 'new'); $order = "login_time DESC,register_time DESC"; $where = "lang='{$_M['lang']}' {$search}"; $userlist = $table->getdata($_M['table']['user'], '*', $where, $order); $user_group = array(); $group = DB::get_all("SELECT * FROM {$_M[table][user_group]} WHERE lang = '{$_M[form][lang]}'"); foreach ($group as $key => $val) { $user_group[$val['id']] = $val['name']; } foreach ($userlist as $key => $val) { switch ($val['source']) { case 'weixin': $val['source'] = '微信登录'; break; case 'weibo': $val['source'] = '微博登录'; break; case 'qq': $val['source'] = 'QQ登录'; break; default: $val['source'] = '注册'; break; } if (!$val['login_time']) { $val['login_time'] = $val['register_time']; } $list = array(); $list[] = "<input name=\"id\" type=\"checkbox\" value=\"{$val[id]}\">"; $list[] = $val['username']; $list[] = $user_group[$val['groupid']]; $list[] = timeFormat($val['register_time']); $list[] = timeFormat($val['login_time']); $list[] = $val['login_count']; $list[] = $val['valid'] ? '已激活' : '未激活'; $list[] = $val['source']; $list[] = "<a href=\"{$_M[url][own_form]}a=doeditor&id={$val['id']}\" class=\"edit\">编辑</a><span class=\"line\">|</span><a href=\"{$_M[url][own_form]}a=dodellist&allid={$val['id']}\" class=\"delet\" data-confirm='{$_M[word][js7]}'>删除</a>"; $rarray[] = $list; } $table->rdata($rarray); }
public function fav_job_list($uid, $limit) { $sql = "select * from stj_job_collection job where uid={$uid} and status=1 order by created_at desc limit {$limit}"; $return_data = $this->table('stj_job_collection job')->query($sql); //echo "<pre>";var_dump($return_data);echo"</pre>"; //得到岗位名称信息 foreach ($return_data as $k => $v) { $return_data[$k]['id'] = $return_data[$k]['j_id']; $com_sql = "select com.cpname,com.id cpid from stj_company com where com.id=" . $v['cpid']; //关联公司信息 $recommended_sql = "select count(*) as num from stj_record where stj_record.j_id = {$v['j_id']}"; //查找该职位已推荐人数 ///echo $cas_sql; $return_data_com = $this->table('stj_company com')->query($com_sql); $recommendedArr = $this->table('stj_record')->query($recommended_sql); foreach ($return_data_com[0] as $k1 => $v1) { $return_data[$k][$k1] = $v1; } $return_data[$k]['recommendednum'] = $recommendedArr[0]['num']; $return_data[$k]['starttimedata'] = timeFormat($return_data[$k]['starttime'], $format = 'Y-m-d'); $return_data[$k]['posttimedata'] = timeFormat($return_data[$k]['posttime'], $format = 'Y-m-d'); $return_data[$k]['posttimedata'] = $return_data[$k]['checktime'] != 0 ? timeFormat($return_data[$k]['checktime'], $format = 'Y-m-d') : timeFormat($return_data[$k]['starttime'], $format = 'Y-m-d'); //查找审核状态和是否被删除状态是否有变动 $job_sql = "select * from stj_job job where job.id=" . $return_data[$k]['id']; $return_data_job = $this->table('stj_job job')->query($job_sql); $audstart_sql = "select count(*) as num from stj_record where stj_record.j_id = {$v['j_id']} and audstart=6"; //查找该职位已招到人数 $audstartArr = $this->table('stj_record')->query($audstart_sql); //得到 薪资待遇 数据 $arTreatmentdata = explode("-", str_replace("元", "", $return_data[$k]['treatmentdata'])); if (count($arTreatmentdata) == 1) { $return_data[$k]['treatmentdata'] = "80K以上"; } else { $return_data[$k]['treatmentdata'] = $arTreatmentdata[0] / 1000 . "K-" . $arTreatmentdata[1] / 1000 . "K"; } //$return_data[$k]['treatmentdata'] = ($arTreatmentdata[0] / 1000) . "K-" . ($arTreatmentdata[1] / 1000) . "K"; //判断是否已经过期或者已经招满或者变成审核失败或者已经删除 if ($audstartArr[0]['num'] >= $return_data[$k]['employ'] || $return_data[$k]['endtime'] < time() || $return_data_job[0]['checkinfo'] == "false" || $return_data_job[0]['is_deleted'] == "1" || $return_data_job[0]['Tariff'] == null) { $return_data[$k]['deadline'] = 1; } } //var_dump($return_data); return $return_data; }
public function view_usersearch() { $username = isset($_POST['username']) ? trim($_POST['username']) : ''; if (empty($username)) { //没有指定用户名 报错 $urldata = array('msg' => array('请输入要查找的用户名'), 'link' => 'index.php?mod=poweruser&act=list'); $urldata = urlencode(json_encode($urldata)); header('location:index.php?mod=showerror&act=showerror&data=' . $urldata); exit; } $usermanager = new localUserManageModel(); $seuserlist = $usermanager->searchUserByUserName($username); //搜索结果 $location_ar = array('<a href="index.php?mod=poweruser&act=list" class="navhref">授权系统</a>', '>', '用户搜索', '>', $username); $this->tp_obj->set_var('module', '用户搜索列表--权限管理'); $this->tp_obj->set_file('header', 'header.html'); $this->tp_obj->set_file('footer', 'footer.html'); $this->tp_obj->set_file('navbar', 'transmanagernav.html'); $this->tp_obj->set_file('powerleftmenu', 'powerleftmenu.html'); $this->tp_obj->set_file('powerpage', 'powerusersearchresult.html'); $this->tp_obj->set_block('navbar', 'navlist', 'locationlist'); //导航 foreach ($location_ar as $lval) { $this->tp_obj->set_var('location', $lval); $this->tp_obj->parse('locationlist', 'navlist', TRUE); } $this->tp_obj->set_var('keywords', $username); $this->tp_obj->set_block('powerpage', 'userlist', 'user_l'); foreach ($seuserlist as $value) { $this->tp_obj->set_var('uid', $value['uid']); $this->tp_obj->set_var('username', $value['username']); $this->tp_obj->set_var('powertype', $usermanager->powerTypeMapping($value['powertype'])); $this->tp_obj->set_var('updatetime', timeFormat($value['updatetime'])); $this->tp_obj->parse('user_l', 'userlist', TRUE); } $this->tp_obj->set_var('username', $_SESSION['userName']); $this->tp_obj->parse('header', 'header'); $this->tp_obj->parse('footer', 'footer'); $this->tp_obj->parse('powerleftmenu', 'powerleftmenu'); $this->tp_obj->parse('powerpage', 'powerpage'); $this->tp_obj->p('powerpage'); }
<div class="col-lg-6"> <div class="panel panel-default"> <div class="panel-heading">Top Records</div> <div class="panel-body"> <div class="table-responsive"> <table class="table table-striped table-bordered table-hover" id="dataTables-example"> <thead> <tr> <th>Rank</th> <th>Map</th> <th>Time</th> <th>Style</th> <th>Track</th> </tr> </thead> <tbody> <?php $sql = "SELECT `rank`, `map`, `time`, `style`, `track` FROM `round` WHERE (`auth` = " . $ex . $steamid . $ex . " OR `auth` = " . $ex . $steamfix . $ex . ") ORDER BY `rank`, `time`, `map` LIMIT 10;"; $players = $link->query($sql); while ($array = mysqli_fetch_array($players)) { echo "<tr class=\"odd gradeX\">\n\t\t\t\t\t\t <td>" . $array[0] . "</td>\n\t\t\t\t\t\t <td>" . $array[1] . "</td>\n\t\t\t\t\t\t <td>" . timeFormat($array[2]) . "</td>\n\t\t\t\t\t\t <td>" . getKeyByArrayValue($array[3], $style_list) . "</td>\n\t\t\t\t\t\t <td>" . getKeyByArrayValue($array[4], $track_list) . "</td>\n\t\t\t\t\t\t </tr>"; } ?> </tbody> </table> </div> </div> </div> </div> </div>
function getRevertById($nMsgId) { $aRs = $this->db->select('SELECT subject,message,date_line FROM sdb_message WHERE for_id=' . $nMsgId); if ($aRs) { foreach ($aRs as $key => $val) { $aRs[$key]['date_line'] = timeFormat($val['date_line']); } } return $aRs; }
<div class="box280"> <div class="tit"><strong>当季旅游推荐</strong></div> <div class="zhuti"> <a href="" title="亲子游专题" target="_blank"><img src="http://s.cncnimg.cn/images/a/2014/250x195_qinziyou_140528.png" alt="亲子游专题"></a> </div> </div> <div class="box280"> <div class="tit"> <strong>最新预订</strong> </div> <div class="txt_order"> <?php if(!empty($output['orderList'])){foreach($output['orderList'] as $v){?> <dl> <i class="i1"></i> <dt><span class="time"><?php echo timeFormat($v['add_time']);?></span><em><?php echo $v['buyer_name']?></em> <span>预定一张订单</span></dt> <dd clss="title"><a href="<?php echo $v['url']?>" target="_blank"><?php echo $v['store_name']?></a></dd> </dl> <?php }}?> </div> </div> </div> <div class="clearfix"></div> </div> <!-- [//主体部分] --> <!-- [//列表页] -->
<div class="post-container" alt="<?php echo $user['uname']; ?> "> <div class="post-wall"> <?php date_default_timezone_set('America/New_York'); $enddate = date('Y-m-d H:i:s', time()); if (!$posts) { echo '<div style="text-align:center; margin-top: 30px;color: #A32824"><h1>The user has no post yet.</h1></div>'; } else { foreach ($posts as $post) { if ($post['visible'] == 0) { $startdate = $post['addtime']; $time_pass = timeFormat($enddate, $startdate); if ($time_pass['year'] > 0) { $show_time_pass = array('number' => $time_pass['year'], 'unit' => 'year'); } else { if ($time_pass['month'] > 0) { $show_time_pass = array('number' => $time_pass['month'], 'unit' => 'month'); } else { if ($time_pass['day'] > 0) { $show_time_pass = array('number' => $time_pass['day'], 'unit' => 'day'); } else { if ($time_pass['hour'] > 0) { $show_time_pass = array('number' => $time_pass['hour'], 'unit' => 'hour'); } else { if ($time_pass['minute'] > 0) { $show_time_pass = array('number' => $time_pass['minute'], 'unit' => 'minute'); } else {
<?php include './common/db.php'; $user = $common['user']; $sql = 'select toid, username, authorid, max(dateline) as timeline, count(*) as msgcount from message,user where delstatus=0 and message.toid=1 and message.authorid=user.userid group by authorid order by dateline desc limit 0,10'; $sqljoin = 'select toid, authorid, content, max(dateline) as timeline, count(*) as msgcount, username from message,user where delstatus=0 and message.toid=' . $user['userid'] . ' and authorid=userid group by authorid order by timeline desc;'; $result = mysql_query($sqljoin); $msg_arr = array(); if ($result) { while ($row = mysql_fetch_array($result)) { $msg_arr[] = array('userid' => $row['authorid'], 'username' => $row['username'], 'content' => getLatestMsg($row['authorid'], $user['userid'], $con), 'dateline' => timeFormat($row['timeline']), 'realtime' => $row['timeline'], 'avator' => getAvator(), 'newcount' => mt_rand(0, 10)); } } ?> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <?php include './common/meta.php'; ?> <title>纸条</title> </head> <body> <?php $mod = 'at'; $doc_title = '@提到我的'; include './common/header.php'; ?>
function parent_login_log($parent_id) { $parent_login_logs = $this->parents_model->order_by('date_time', 'DESC')->getWhere(array('parent_id' => $parent_id), IMS_DB_PREFIX . 'parent_login_log'); if (!$parent_login_logs) { echo json_encode(array('status' => 'false')); } else { $new_parent_login_logs = array(); foreach ($parent_login_logs as $k => $parent_login_log) { $new_parent_login_logs[$k] = $parent_login_log; $new_parent_login_logs[$k]->date = dateFormat($parent_login_log->date_time); $new_parent_login_logs[$k]->time = timeFormat($parent_login_log->date_time); } echo json_encode(array('status' => 'true', 'parent_login_logs' => $new_parent_login_logs)); } }
<div class="uk-width-1-6"><?php echo ucwords($val); ?> </div> <div class="uk-width-1-6"> <?php echo CHtml::textField("stores_open_starts[{$key}]", array_key_exists($key, (array) $stores_open_starts) ? timeFormat($stores_open_starts[$key], true) : "", array('placeholder' => Yii::t("default", "Start"), 'class' => "timepick")); ?> </div> <div class="uk-width-1-6" style="width:5%;"><?php echo Yii::t("default", "To"); ?> </div> <div class="uk-width-1-6"> <?php echo CHtml::textField("stores_open_ends[{$key}]", array_key_exists($key, (array) $stores_open_ends) ? timeFormat($stores_open_ends[$key], true) : "", array('placeholder' => Yii::t("default", "End"), 'class' => "timepick")); ?> </div> <div class="uk-width-1-6"> <?php echo CHtml::textField("stores_open_custom_text[{$key}]", array_key_exists($key, (array) $stores_open_custom_text) ? $stores_open_custom_text[$key] : "", array('placeholder' => Yii::t("default", "Custom text"))); ?> </div> </div> </li> <?php } ?> </ul> </div>
} else { $query = $link->query("SELECT COUNT(*) FROM `round` WHERE `map` LIKE '" . $map . "' AND `track` = '" . $track . "' AND `style` = '" . $style . "'"); } } $array2 = mysqli_fetch_array($query); $totalplayers = $array2[0]; if ($style == -1) { if ($track == -1) { $sql = "SELECT `rank`, `name`, `auth`, `time`, `style`, `track`, `date` FROM `round` WHERE `map` LIKE '" . $map . "' ORDER BY `time` ASC LIMIT 25"; } else { $sql = "SELECT `rank`, `name`, `auth`, `time`, `style`, `track`, `date` FROM `round` WHERE `map` LIKE '" . $map . "' AND `track` = '" . $track . "' ORDER BY `time` ASC LIMIT 25"; } } else { if ($track == -1) { $sql = "SELECT `rank`, `name`, `auth`, `time`, `style`, `track`, `date` FROM `round` WHERE `map` LIKE '" . $map . "' AND `style` = '" . $style . "' ORDER BY `time` ASC LIMIT 25"; } else { $sql = "SELECT `rank`, `name`, `auth`, `time`, `style`, `track`, `date` FROM `round` WHERE `map` LIKE '" . $map . "' AND `track` = '" . $track . "' AND `style` = '" . $style . "' ORDER BY `time` ASC LIMIT 25"; } } $players = $link->query($sql); while ($array = mysqli_fetch_array($players)) { echo "<tr class=\"odd gradeX\">\n\t\t\t\t\t\t\t\t<td>" . $array[0] . "</td>\n\t\t\t\t\t\t\t\t<td><a href='index.php?site=player&auth=" . $array[2] . "'>" . $array[1] . "</a></td>\n\t\t\t\t\t\t\t\t<td>" . timeFormat($array[3]) . "</td>\n\t\t\t\t\t\t\t\t<td>" . getKeyByArrayValue($array[4], $style_list) . "</td>\n\t\t\t\t\t\t\t\t<td>" . getKeyByArrayValue($array[5], $track_list) . "</td>\n\t\t\t\t\t\t\t\t<td>" . $array[6] . "</td>\n\t\t\t\t\t\t\t\t</tr>"; } ?> </tbody> </table> </div> </div> </div> </div> </div>
function consoleLog($content) { echo timeFormat(time()) . ' ' . strval($content) . "\n"; }
public function getOperationalHours($merchant_id = '') { $stores_open_day = Yii::app()->functions->getOption("stores_open_day", $merchant_id); $stores_open_starts = Yii::app()->functions->getOption("stores_open_starts", $merchant_id); $stores_open_ends = Yii::app()->functions->getOption("stores_open_ends", $merchant_id); $stores_open_custom_text = Yii::app()->functions->getOption("stores_open_custom_text", $merchant_id); $stores_open_day = !empty($stores_open_day) ? (array) json_decode($stores_open_day) : false; $stores_open_starts = !empty($stores_open_starts) ? (array) json_decode($stores_open_starts) : false; $stores_open_ends = !empty($stores_open_ends) ? (array) json_decode($stores_open_ends) : false; $stores_open_custom_text = !empty($stores_open_custom_text) ? (array) json_decode($stores_open_custom_text) : false; $tip = ''; $open_starts = ''; $open_ends = ''; $open_text = ''; $tip .= "<ul class=\"hr_op rounded2\"><i class=\"fa fa-caret-up\"></i>"; if (is_array($stores_open_day) && count($stores_open_day) >= 1) { foreach ($stores_open_day as $val_open) { if (array_key_exists($val_open, (array) $stores_open_starts)) { $open_starts = timeFormat($stores_open_starts[$val_open], true); } if (array_key_exists($val_open, (array) $stores_open_ends)) { $open_ends = timeFormat($stores_open_ends[$val_open], true); } if (array_key_exists($val_open, (array) $stores_open_custom_text)) { $open_text = $stores_open_custom_text[$val_open]; } $tip .= '<li><span>' . ucwords(Yii::t("default", $val_open)) . '</span><value>' . $open_starts . " - " . $open_ends . " " . ucfirst($open_text) . '</value></li>'; $open_starts = ''; $open_ends = ''; $open_text = ''; } } else { $tip .= "<li>" . Yii::t("default", "Not available.") . "</li>"; } $tip .= "<div class=\"clear\"></div>"; $tip .= "</ul>"; $tips = "<a class=\"opening-hours-wrap\" href=\"javascript:;\">" . Yii::t("default", "Hours of Operation") . "{$tip}</a>"; return $tips; }
public function searchArea() { $resto_cuisine = ''; $rating = ''; $minimum = ''; $pay_by = ''; $minus_has_delivery_rates = 0; $cuisine_list = Yii::app()->functions->Cuisine(true); $country_list = Yii::app()->functions->CountryList(); $this->data['s'] = isset($this->data['s']) ? $this->data['s'] : ""; $search_str = explode(",", $this->data['s']); if (is_array($search_str) && count($search_str) >= 2) { $city = isset($search_str[1]) ? trim($search_str[1]) : ''; $state = isset($search_str[2]) ? trim($search_str[2]) : ''; } else { $city = trim($this->data['s']); $state = trim($this->data['s']); } $from_address = $this->data['s']; if (empty($from_address)) { $from_address = isset($this->data['st']) ? $this->data['st'] : ''; if (!empty($this->data['st'])) { $_SESSION['kr_search_address'] = $this->data['st']; } } if ($res = Yii::app()->functions->searchByArea($city, $state)) { if (is_array($res) && count($res) >= 1) { $total = Yii::app()->functions->search_result_total; $feed_datas['sEcho'] = $this->data['sEcho']; $feed_datas['iTotalRecords'] = $total; $feed_datas['iTotalDisplayRecords'] = $total; /*dump($feed_datas); die();*/ foreach ($res as $val) { $merchant_address = $val['street'] . " " . $val['city'] . " " . $val['post_code']; $miles = 0; $kms = 0; $ft = false; $new_distance_raw = 0; if ($distance = getDistance($from_address, $merchant_address, $val['country_code'], false)) { $miles = $distance->rows[0]->elements[0]->distance->text; //dump($miles); if (preg_match("/ft/i", $miles)) { $ft = true; $miles_raw = $miles; $new_distance_raw = str_replace("ft", '', $miles); $new_distance_raw = ft2kms(trim($new_distance_raw)); } else { $miles_raw = str_replace(array(" ", "mi"), "", $miles); $kms = miles2kms(unPrettyPrice($miles_raw)); $new_distance_raw = $kms; $kms = standardPrettyFormat($kms); } } /*get merchant distance */ $mt_delivery_miles = Yii::app()->functions->getOption("merchant_delivery_miles", $val['merchant_id']); $merchant_distance_type = Yii::app()->functions->getOption("merchant_distance_type", $val['merchant_id']); /*dump($mt_delivery_miles); dump($miles_raw);*/ $resto_cuisine = ''; $cuisine = !empty($val['cuisine']) ? (array) json_decode($val['cuisine']) : false; if ($cuisine != false) { foreach ($cuisine as $valc) { if (array_key_exists($valc, (array) $cuisine_list)) { $resto_cuisine .= $cuisine_list[$valc] . ", "; } } $resto_cuisine = !empty($resto_cuisine) ? substr($resto_cuisine, 0, -2) : ''; } $resto_info = "<h5><a href=\"" . baseUrl() . "/store/menu/merchant/" . $val['restaurant_slug'] . "\">" . $val['restaurant_name'] . "</a></h5>"; //$resto_cuisine="<span class=\"cuisine-list\">".$resto_cuisine."</span>"; $resto_cuisine = wordwrap($resto_cuisine, 50, "<br />\n"); $resto_info .= "<p class=\"uk-text-muted\">" . $val['street'] . " " . $val['city'] . " " . $val['post_code'] . "</p>"; if (array_key_exists($val['country_code'], (array) $country_list)) { $resto_info .= "<p class=\"uk-text-bold\">" . $country_list[$val['country_code']] . "</p>"; } $resto_info .= "<p class=\"uk-text-bold\">" . Yii::t('default', "Cuisine") . " - " . $resto_cuisine . "</p>"; $delivery_est = Yii::app()->functions->getOption("merchant_delivery_estimation", $val['merchant_id']); $distancesya = $miles_raw; $unit_distance = $merchant_distance_type; if (!empty($from_address)) { if ($ft == TRUE) { $resto_info .= "<p><span class=\"uk-text-bold\">" . Yii::t("default", "Distance") . ": </span> {$miles_raw} </p>"; if ($merchant_distance_type == "km") { $distance_type = Yii::t("default", "km"); } else { $distance_type = Yii::t("default", "miles"); } } else { if ($merchant_distance_type == "km") { $distance_type = Yii::t("default", "km"); $resto_info .= "<p><span class=\"uk-text-bold\">" . Yii::t("default", "Distance") . ": </span> {$kms} " . Yii::t("default", "km") . "</p>"; $distancesya = $kms; } else { $resto_info .= "<p><span class=\"uk-text-bold\">" . Yii::t("default", "Distance") . ": </span> {$miles_raw} " . Yii::t("default", "miles") . "</p>"; $distance_type = Yii::t("default", "miles"); } } } $resto_info .= "<p><span class=\"uk-text-bold\">" . Yii::t("default", "Delivery Est") . ": </span> " . $delivery_est . "</p>"; if (is_numeric($mt_delivery_miles)) { $resto_info .= "<p><span class=\"uk-text-bold\">" . Yii::t("default", "Delivery Distance") . ": </span> " . $mt_delivery_miles . " " . $distance_type . "</p>"; } $shipping_enabled = Yii::app()->functions->getOption("shipping_enabled", $val['merchant_id']); //delivery rates table $delivery_fee = $val['delivery_charges']; if ($shipping_enabled == 2) { $FunctionsK = new FunctionsK(); //$distancesya=round($distancesya); //dump($distancesya); $delivery_fee = $FunctionsK->getDeliveryChargesByDistance($val['merchant_id'], $distancesya, $unit_distance, $delivery_fee); if ($delivery_fee >= 0.01) { if (isset($_GET['filter_promo'])) { if (preg_match("/free-delivery/i", $_GET['filter_promo'])) { $minus_has_delivery_rates++; continue; } } } } if (is_numeric($delivery_fee) && $delivery_fee >= 1) { $resto_info .= "<p><span class=\"uk-text-bold\">" . Yii::t("default", "Delivery Fee") . ":</span> " . displayPrice(getCurrencyCode(), prettyFormat($delivery_fee)) . "</p>"; } else { $resto_info .= "<p><span class=\"uk-text-bold\">" . Yii::t("default", "Delivery Fee") . ":</span> " . "<span class=\"uk-text-success\">" . Yii::t("default", "Free Delivery") . "</span>" . "</p>"; } $image = ''; $merchant_photo = Yii::app()->functions->getOption("merchant_photo", $val['merchant_id']); if (!empty($merchant_photo)) { $image .= "<a href=\"" . baseUrl() . "/store/menu/merchant/" . $val['restaurant_slug'] . "\">"; $image .= "<img class=\"uk-thumbnail uk-thumbnail-mini\" src=\"" . baseUrl() . "/upload/" . $merchant_photo . "\" alt=\"\" title=\"\">"; $image .= "</a>"; } if (empty($image)) { $image .= "<a href=\"" . baseUrl() . "/store/menu/merchant/" . $val['restaurant_slug'] . "\">"; $image .= "<img class=\"uk-thumbnail uk-thumbnail-mini\" src=\"" . baseUrl() . "/assets/images/thumbnail-medium.png\" alt=\"\" title=\"\">"; $image .= "</a>"; } $ratings = Yii::app()->functions->getRatings($val['merchant_id']); $rating_meanings = ''; if ($ratings['ratings'] >= 1) { $rating_meaning = Yii::app()->functions->getRatingsMeaning($ratings['ratings']); $rating_meanings = ucwords($rating_meaning['meaning']); } $rating = "<div class=\"rate-wrap\">\r\n\t \t\t\t\t<h6 class=\"rounded2\" data-uk-tooltip=\"{pos:'bottom-left'}\" title=\"{$rating_meanings}\" >" . number_format($ratings['ratings'], 1) . "</h6>\r\n\t \t\t\t\t<span>" . $ratings['votes'] . " " . Yii::t("default", "Votes") . "</span>\r\n\t \t\t\t\t</div>"; $stores_open_day = Yii::app()->functions->getOption("stores_open_day", $val['merchant_id']); $stores_open_starts = Yii::app()->functions->getOption("stores_open_starts", $val['merchant_id']); $stores_open_ends = Yii::app()->functions->getOption("stores_open_ends", $val['merchant_id']); $stores_open_custom_text = Yii::app()->functions->getOption("stores_open_custom_text", $val['merchant_id']); $stores_open_day = !empty($stores_open_day) ? (array) json_decode($stores_open_day) : false; $stores_open_starts = !empty($stores_open_starts) ? (array) json_decode($stores_open_starts) : false; $stores_open_ends = !empty($stores_open_ends) ? (array) json_decode($stores_open_ends) : false; $stores_open_custom_text = !empty($stores_open_custom_text) ? (array) json_decode($stores_open_custom_text) : false; $tip = ''; $open_starts = ''; $open_ends = ''; $open_text = ''; $tip .= "<ul class=\"hr_op rounded2\"><i class=\"fa fa-caret-up\"></i>"; if (is_array($stores_open_day) && count($stores_open_day) >= 1) { foreach ($stores_open_day as $val_open) { if (array_key_exists($val_open, (array) $stores_open_starts)) { $open_starts = timeFormat($stores_open_starts[$val_open], true); } if (array_key_exists($val_open, (array) $stores_open_ends)) { $open_ends = timeFormat($stores_open_ends[$val_open], true); } if (array_key_exists($val_open, (array) $stores_open_custom_text)) { $open_text = $stores_open_custom_text[$val_open]; } $tip .= '<li><span>' . ucwords(Yii::t("default", $val_open)) . '</span><value>' . $open_starts . " - " . $open_ends . " " . ucfirst($open_text) . '</value></li>'; $open_starts = ''; $open_ends = ''; $open_text = ''; } } else { $tip .= '<li>' . Yii::t("default", "Not available.") . '</li>'; } $tip .= "<div class=\"clear\"></div>"; $tip .= "</ul>"; $tips = "<a class=\"opening-hours-wrap\" href=\"javascript:;\">" . Yii::t("default", "Hours of Operation") . "{$tip}</a>"; $resto_info .= $tips; $resto_info .= "<div class=\"spacer\"></div>"; $resto_info .= "<div>\r\n\t\t\t\t\t\t<a class=\"uk-button uk-button-success uk-width-1-2\" href=\"" . baseUrl() . "/store/menu/merchant/" . $val['restaurant_slug'] . "\">"; $resto_info .= Yii::t("default", "Order Now"); $resto_info .= "</a></div>"; $resto_info .= "<div class=\"spacer\"></div>"; $table_book = Yii::app()->functions->getOption("merchant_table_booking", $val['merchant_id']); if ($table_book == "") { $resto_info .= "<div>\r\n\t\t\t\t\t\t<a class=\"uk-button uk-button-success uk-width-1-2\" href=\"" . baseUrl() . "/store/menu/merchant/" . $val['restaurant_slug'] . "/?tab=booking" . "\">"; $resto_info .= Yii::t("default", "Book a Table"); $resto_info .= "</a></div>"; } $is_sponsored = ''; if ($val['is_sponsored'] == 2) { $is_sponsored = "<br/><div class=\"uk-badge uk-badge-warning\">" . Yii::t("default", "sponsored") . "</div>"; } $is_merchant_open = Yii::app()->functions->isMerchantOpen($val['merchant_id']); $merchant_preorder = Yii::app()->functions->getOption("merchant_preorder", $val['merchant_id']); $now = date('Y-m-d'); $is_holiday = false; if ($m_holiday = Yii::app()->functions->getMerchantHoliday($val['merchant_id'])) { if (in_array($now, (array) $m_holiday)) { $is_merchant_open = false; } } $tag_open = ''; if ($is_merchant_open == TRUE) { $tag_open = '<div class="uk-badge uk-badge-success">' . t("Open") . '</div>'; } else { if ($merchant_preorder) { $tag_open = '<div class="uk-badge uk-badge-warning">' . t("Pre-Order") . '</div>'; } else { $tag_open = '<div class="uk-badge uk-badge-danger">' . t("Closed") . '</div>'; } } $is_sponsored .= $tag_open; $offers = Widgets::offers($val['merchant_id'], 2); $is_sponsored .= $offers; $merchant_latitude = Yii::app()->functions->getOption("merchant_latitude", $val['merchant_id']); $merchant_longtitude = Yii::app()->functions->getOption("merchant_longtitude", $val['merchant_id']); $merchant_latitude = !empty($merchant_latitude) ? $merchant_latitude : '0'; $merchant_longtitude = !empty($merchant_longtitude) ? $merchant_longtitude : '0'; $feed_data[] = array($image, $resto_info, $rating, !empty($val['minimum_order']) ? displayPrice(getCurrencyCode(), prettyFormat($val['minimum_order'])) . "<br/>" . $is_sponsored : "{$is_sponsored}", $miles_raw, $merchant_latitude, $merchant_longtitude, addslashes($val['restaurant_name']), $merchant_address, $val['restaurant_slug'], $image, $new_distance_raw); } $this->data['sort_filter'] = isset($this->data['sort_filter']) ? $this->data['sort_filter'] : ''; //dump($feed_data); if ($this->data['sort_filter'] == "distance") { Yii::app()->functions->arraySortByColumn($feed_data, 11); $feed_datas['aaData'] = $feed_data; } else { /** sort by distance */ if (Yii::app()->functions->getOptionAdmin('search_result_bydistance') == 2) { Yii::app()->functions->arraySortByColumn($feed_data, 11); $feed_datas['aaData'] = $feed_data; } else { $feed_datas['aaData'] = $feed_data; } } //dump("minus_has_delivery_rates->".$minus_has_delivery_rates); if ($minus_has_delivery_rates >= 1) { $feed_datas['iTotalRecords'] = $feed_datas['iTotalRecords'] - $minus_has_delivery_rates; $feed_datas['iTotalDisplayRecords'] = $feed_datas['iTotalDisplayRecords'] - $minus_has_delivery_rates; if ($feed_datas['iTotalRecords'] <= 0) { $this->otableNodata(); } } $this->otableOutput($feed_datas); } } $this->otableNodata(); }
public function save_leave_request($request_id = NULL) { if ($this->input->post()) { if ($this->_validate_leave_request()) { $data = array('leave_type_id' => $this->input->post('leave_type_id'), 'user_id' => $this->input->post('staff_id'), 'status' => '0', 'start_date' => mysqlDateFormat($this->input->post('start_date')), 'end_date' => mysqlDateFormat($this->input->post('end_date')), 'start_time' => $this->input->post('start_time'), 'end_time' => $this->input->post('end_time'), 'description' => $this->input->post('remarks'), 'is_deleted' => '0', 'applied_date' => date('Y-m-d')); $this->load->model('work_profile_model'); $work_profile_id = $this->work_profile_model->select('id')->getOneWhere(array('user_id' => $this->input->post('staff_id')), IMS_DB_PREFIX . 'work_profile'); if (empty($work_profile_id)) { die(json_encode(array('status' => 'error', 'msg' => 'Fail to take leave! Your work profile has not been set yet.'))); } else { $work_profile_id = $work_profile_id->id; } $work_profile = $this->work_profile_model->get_work_profile_by_id($work_profile_id); $time = calculate_leave_hours($this->input->post('start_date'), $this->input->post('start_time'), $this->input->post('end_date'), $this->input->post('end_time'), $work_profile); $data['hours'] = $time; if ($request_id != NULL) { $result = $this->leave_model->updateRow($request_id, $data, 'id', IMS_DB_PREFIX . 'leave_requests'); $data['request_id'] = $request_id; $result ? die(json_encode(array('status' => 'success', 'msg' => 'Leave Request Edited Successfully.', 'data' => $data))) : die(json_encode(array('status' => 'error', 'msg' => 'Cannot Edit Leave Application. Please try again later.'))); } else { $request_id = $this->leave_model->insertRow($data, IMS_DB_PREFIX . 'leave_requests'); $data['request_id'] = $request_id; $selected_year = $this->input->post('selected_year'); if ($this->input->post('leave_type_id') == 1) { $data['off_claimed'] = $this->leave_model->getUserBalance($this->input->post('staff_id'), 1, $selected_year); } $total_leave_claimed = $this->leave_model->getTotalLeaveTaken($data['user_id'], $selected_year, 1, 'not'); $total_leave_off_claimed = $this->leave_model->getTotalLeaveTaken($data['user_id'], $selected_year, 1); $total_leave_accumulated = $this->leave_model->getTotalLeaveAccumulated($data['user_id'], $selected_year); $leave_request = $this->leave_model->getLeaveRequestByID($request_id); $leave_request->start_date = dateFormat($leave_request->start_date); $leave_request->end_date = dateFormat($leave_request->end_date); $leave_request->start_time = timeFormat($leave_request->start_time); $leave_request->end_time = timeFormat($leave_request->end_time); $leave_request->applied_date = dateFormat($leave_request->applied_date); $leave_request->leave_left = $total_leave_accumulated - ($total_leave_claimed + $total_leave_off_claimed); $leave_request->leave_off_claimed = $total_leave_off_claimed; if ($request_id) { $user = $this->leave_model->getFromId($this->input->post('staff_id'), 'id', IMS_DB_PREFIX . 'user'); global $_current_centre_role; $centre_admin = centre_admin($_current_centre_role->centre_id); if (!empty($centre_admin)) { $subject = 'A new leave is requested.'; // $message = '<p>' . $centre_admin->first_name . ',</p>' // . '<p>Leave have been requested' // . 'by : ' . $user->first_name . ' ' . $user->last_name . '</p>' // . '<p>From : ' . $this->input->post('start_date') . '</p>' // . '<p>To : ' . $this->input->post('end_date') . '</p>' // . '<p>Waiting for your approval!</p>'; $leave_type_name = $this->leave_model->select('leave_type')->getOneWhere(array('id' => $this->input->post('leave_type_id')), IMS_DB_PREFIX . 'leave_types')->leave_type; $message = "<p>{name_of_superior},</p>" . "<p>{leave_type} application has been submitted by: {name_of_subordinate}</p>" . "<p>From : {from_start_date} {from_start_time}</p>" . "<p>To : {to_start_date} {to_start_time}</p>" . "<a href='{link_to_leave_application}'>Please review the leave application here</a>"; $leave_info = array('name_of_superior' => $centre_admin->first_name, 'leave_type' => $leave_type_name, 'name_of_subordinate' => $user->first_name . ' ' . $user->last_name, 'from_start_date' => $this->input->post('start_date'), 'from_start_time' => $this->input->post('start_time'), 'to_start_date' => $this->input->post('end_date'), 'to_start_time' => $this->input->post('end_time'), 'link_to_leave_application' => site_url("leave/leave_manage")); $this->load->library('parser'); $message = $this->parser->parse_string($message, $leave_info, TRUE); // die($message); $this->send_mail($centre_admin->email, 'Centre Admin', $subject, $message); } die(json_encode(array('status' => 'success', 'msg' => 'Leave Application Submitted Successfully.', 'data' => $leave_request))); } else { die(json_encode(array('status' => 'error', 'msg' => 'Cannot Submit Leave Application. Please try again later.'))); } } } else { $response = array('status' => 'validation_error', 'error' => array()); if (form_error('leave_type_id')) { $response['error']['leave_type_id'] = form_error('leave_type_id'); } if (form_error('start_date')) { $response['error']['start_date'] = form_error('start_date'); } if (form_error('end_date')) { $response['error']['end_date'] = form_error('end_date'); } if (form_error('start_time')) { $response['error']['start_time'] = form_error('start_time'); } if (form_error('end_time')) { $response['error']['end_time'] = form_error('end_time'); } die(json_encode($response)); } } }
public function new_job_list($limit, $title = '') { if (empty($title)) { $sql = "select * from stj_job where stj_job.is_show=1 and stj_job.employ>(select count(*) from stj_record where stj_record.j_id = stj_job.id and audstart=6) and checkinfo='true' and endtime>unix_timestamp(now()) and is_deleted=0 order by orderid asc, checktime desc ,starttime desc limit {$limit}"; } else { //关键词模糊查询 $keywordGroup = M("keyword_group")->where("keyword_group like '%" . $title . "%'")->getField("keyword_group"); if ($keywordGroup) { $arKeywordGroup = explode(" ", $keywordGroup); $titleTmp = ""; foreach ($arKeywordGroup as $keyword) { if ($keyword) { $titleTmp .= " or title like '%" . $keyword . "%' "; } } } if (strlen($titleTmp) > 0) { $where .= " (title like '%" . $title . "%' " . $titleTmp . ") "; } else { $where .= " (title like '%" . $title . "%') "; } $sql = "select * from stj_job where {$where} and stj_job.is_show=1 and stj_job.employ>(select count(*) from stj_record where stj_record.j_id = stj_job.id and audstart=6) and checkinfo='true' and endtime>unix_timestamp(now()) and is_deleted=0 order by orderid asc, checktime desc ,starttime desc limit {$limit}"; } $return_data = $this->table('stj_job job')->query($sql); //echo "<pre>";var_dump($return_data);echo"</pre>"; //得到岗位名称信息 foreach ($return_data as $k => $v) { $com_sql = "select com.cpname,com.id cpid from stj_company com where com.id=" . $v['cpid']; //关联公司信息 $cas_sql = "select cas.cascname from stj_casclist cas where cas.id=" . $v['jobplace']; //关联casclist $recommended_sql = "select count(*) as num from stj_record where stj_record.j_id = {$v['id']}"; //echo $recommended_sql;die; $return_data_com = $this->table('stj_company com')->query($com_sql); //echo"<pre>";var_dump($return_data_com);echo"</pre>"; $return_data_cas = $this->table('stj_casclist cas')->query($cas_sql); //echo"<pre>";var_dump($return_data_cas);echo"</pre>"; $recommendedArr = $this->table('stj_record')->query($recommended_sql); foreach ($return_data_com[0] as $k1 => $v1) { $return_data[$k][$k1] = $v1; } foreach ($return_data_cas[0] as $k1 => $v1) { $return_data[$k][$k1] = $v1; } $return_data[$k]['recommendednum'] = $recommendedArr[0]['num']; $return_data[$k]['posttimedata'] = timeFormat($return_data[$k]['posttime'], $format = 'Y-m-d'); $return_data[$k]['starttimedata'] = timeFormat($return_data[$k]['starttime'], $format = 'Y-m-d'); $return_data[$k]['posttimedata'] = $return_data[$k]['checktime'] != 0 ? timeFormat($return_data[$k]['checktime'], $format = 'Y-m-d') : timeFormat($return_data[$k]['starttime'], $format = 'Y-m-d'); //得到 职位名称 数据 if (empty($return_data[$k]['title'])) { $return_data[$k]['title'] = getCascList($return_data[$k]['Jobcate'], "信息不明"); } //得到 薪资待遇 数据 $treatmentdata = getCascData('treatment', $return_data[$k]['treatment'], "信息不明"); $arTreatmentdata = explode("-", str_replace("元", "", $treatmentdata)); //$return_data[$k]['treatmentdata'] = ($arTreatmentdata[0] / 1000) . "K-" . ($arTreatmentdata[1] / 1000) . "K"; if (count($arTreatmentdata) == 1) { $return_data[$k]['treatmentdata'] = "80K以上"; } else { $return_data[$k]['treatmentdata'] = $arTreatmentdata[0] / 1000 . "K-" . $arTreatmentdata[1] / 1000 . "K"; } //得到 工作经验 数据 $experiencedata = getCascData('experience', $return_data[$k]['experience'], "信息不明"); $return_data[$k]['experiencedata'] = $experiencedata; //招聘资费处理 if ($return_data[$k]['Tariff'] > 10) { $return_data[$k]['Tariff'] = floor($return_data[$k]['Tariff'] * 0.8 / 100) * 100; } else { $return_data[$k]['Tariff'] = floor($return_data[$k]['treatment'] * $return_data[$k]['Tariff'] * 12 * 0.8 / 100) * 100; } //发布时间 $return_data[$k]['starttime'] = $return_data[$k]['checktime'] != 0 ? date('Y-m-d', $return_data[$k]['checktime']) : date('Y-m-d', $return_data[$k]['starttime']); //echo "<pre>";var_dump($return_data);echo"</pre>"; } //echo "<pre>";var_dump($return_data[0]);echo"</pre>"; return $return_data; }
public static function debug($title, $data, $key = 'log') { $log = ['time' => timeFormat(time()), 'title' => $title, 'data' => $data]; $redis = DXUtil::redisClient(); $redis->lpush($key, json_encode($log)); }