function stepCounter($file) { if (file_exists($file)) { $value = getCount($file); file_put_contents($file, ++$value); } }
protected function _initialize() { parent::_initialize(); $this->openuid = I('get.openuid'); if (getUidByOpenuid($this->openuid)) { $this->uid = getUidByOpenuid($this->openuid); } else { $this->error('您无权访问当前页面!'); } $this->assign('openuid', $this->openuid); //会员信息 $this->memberDetail = D('Home/User')->find($this->uid); //烘焙作品数 $this->hbworksnum = getCount('Works', array('userid' => $this->uid, 'type' => 1)); //随拍作品 $this->spworksnum = getCount('Copy', array('userid' => $this->uid)); //关注数 $this->attentionnum = getCount('UserFans', array('myid' => $this->uid)); //被关注数 $this->fansnum = getCount('UserFans', array('userid' => $this->uid)); //是否关注 $this->isfans = getCount('UserFans', array('myid' => $this->userid, 'userid' => $this->uid, 'status' => true)); //中间广告 $this->midad = parent::getAdvert(9, 1, 0, 1); }
function discuss($ID) { global $comments_disabled_after; $preview = ps('preview'); extract(safe_row("Annotate,AnnotateInvite,unix_timestamp(Posted) as uPosted", "textpattern", "ID='{$ID}'")); $darr = !$preview ? fetchComments($ID) : array(psas(array('name', 'email', 'web', 'message', 'parentid', 'remember'))); $out = n . '<h3 style="margin-top:2em" id="comment">' . $AnnotateInvite . '</h3>' . n; if ($darr) { $out .= '<ol>' . n; $out .= formatComments($darr); $out .= n . '</ol>'; } $wasAnnotated = !$Annotate ? getCount('txp_discuss', "parentid={$ID}") : ''; if (!$Annotate) { $out .= graf(gTxt("comments_closed")); } else { if ($comments_disabled_after) { $lifespan = $comments_disabled_after * 86400; $timesince = time() - $uPosted; if ($lifespan > $timesince) { $out .= commentForm($ID); } else { $out .= graf(gTxt("comments_closed")); } } else { $out .= commentForm($ID); } } return $out; }
function createTables() { $division = $_SESSION['division']; $date = $_SESSION['date']; $count = getCount(); global $conn; //check if import.csv is a new carrier or existing, create tableset if new $getDivisionAll = mysqli_query($conn, "SELECT division from Division_All"); $getDivisionCount = mysqli_query($conn, "SELECT division, countImported, importDate from Division_Metadata"); $results = array(); while ($row = mysqli_fetch_array($getDivisionAll)) { $results[] = $row[0]; } if (!in_array($division, $results)) { createTableSet($division, $conn); mysqli_query($conn, "INSERT INTO Division_All VALUES (id, '{$division}')"); mysqli_query($conn, "INSERT INTO Division_Metadata VALUES (id, '{$division}', '{$date}', {$count})"); return $count; } else { $exists = mysqli_query($conn, "SELECT * from Division_Metadata where division = '{$division}'\n and countImported = {$count} and importDate = '{$date}'"); $row_cnt = $exists->num_rows; if ($row_cnt < 1) { mysqli_query($conn, "INSERT INTO Division_Metadata VALUES (id, '{$division}', '{$date}', {$count})"); return $count; } else { header("location:index.php?status=duplicate&division={$division}&count={$count}"); } } }
function list_list($message = "", $post = '') { extract(get_prefs()); $lvars = array("page", "sort", "dir", "crit", 'method'); extract(gpsa($lvars)); global $statuses, $step; pagetop("Textpattern", $message); $total = getCount('textpattern', "1"); $limit = $article_list_pageby ? $article_list_pageby : 25; $numPages = ceil($total / $limit); $page = !$page ? 1 : $page; $offset = ($page - 1) * $limit; if (!$sort) { $sort = "Posted"; } if (!$dir) { $dir = "desc"; } if ($dir == "desc") { $linkdir = "asc"; } else { $linkdir = "desc"; } if ($crit) { $critsql = array('title_body' => "Title rlike '{$crit}' or Body rlike '{$crit}'", 'author' => "AuthorID rlike '{$crit}'", 'categories' => "Category1 rlike '{$crit}' or Category2 rlike '{$crit}'", 'section' => "Section rlike '{$crit}'", 'status' => "Status rlike '{$crit}'"); $criteria = $critsql[$method]; $limit = 500; } else { $criteria = 1; } $rs = safe_rows("*, unix_timestamp(Posted) as uPosted", "textpattern", "{$criteria} order by {$sort} {$dir} limit {$offset},{$limit}"); echo !$crit ? list_nav_form($page, $numPages, $sort, $dir) : '', list_searching_form($crit, $method); if ($rs) { echo '<form action="index.php" method="post" onsubmit="return verify(\'' . gTxt('are_you_sure') . '\')">', startTable('list'), '<tr>', column_head('posted', 'Posted', 'list', 1, $linkdir), column_head('title', 'Title', 'list', 1, $linkdir), $use_sections ? column_head('section', 'Section', 'list', 1, $linkdir) : '', $use_categories ? column_head('category1', 'Category1', 'list', 1, $linkdir) . column_head('category2', 'Category2', 'list', 1, $linkdir) : '', hCell(gTxt('Author')), column_head(gTxt('status'), 'Status', 'list', 1, $linkdir), td(), '</tr>'; foreach ($rs as $a) { extract($a); if ($use_categories == 1) { $cat1 = $Category1; $cat2 = $Category2; } $stat = !empty($Status) ? $statuses[$Status] : ''; if ($use_sections == 1) { $sect = $Section; } $adate = date("d M y", $uPosted + $timeoffset); $alink = eLink('article', 'edit', 'ID', $ID, $adate); $tlink = eLink('article', 'edit', 'ID', $ID, $Title); $modbox = fInput('checkbox', 'selected[]', $ID); echo "<tr>" . n, td($alink), td($tlink, 200), $use_sections ? td($sect, 75) : '', $use_categories ? td($cat1, 75) . td($cat2, 75) : '', td($AuthorID), td($stat, 45), td($modbox), '</tr>' . n; } echo tr(tda(list_multiedit_form(), ' colspan="8" style="text-align:right;border:0px"')); echo "</table></form>"; echo pageby_form('list', $article_list_pageby); unset($sort); } }
/** * 文章属性调用标签 * * @version $Id: getarcattr.lib.php netman * @package Stourweb.Taglib * @copyright Copyright (c) 2007 - 2011, Stourweb, Inc. * @link http://www.stourweb.com */ function lib_getarcattr(&$ctag, &$refObj) { global $dsql; $attlist = "row|8,limit|0,flag|"; FillAttsDefault($ctag->CAttribute->Items, $attlist); extract($ctag->CAttribute->Items, EXTR_SKIP); $innertext = trim($ctag->GetInnertext()); $revalue = ''; $kindid = $refObj->Fields['kindid']; $sql = "select * from #@__article_attr where isopen=1 and pid!=0 order by displayorder asc limit {$limit},{$row}"; if ($flag == 'mdd') { $sql = "select a.*,count(b.id) as num from #@__article_attr as a inner join #@__article as b on find_in_set(a.id,b.attrid) where find_in_set({$kindid},b.kindlist) group by a.id limit {$limit},{$row}"; } $dsql->SetQuery($sql); $dsql->Execute(); $ctp = new STTagParse(); $ctp->SetNameSpace("field", "[", "]"); $ctp->LoadSource($innertext); $GLOBALS['autoindex'] = 0; while ($row = $dsql->GetArray()) { if (checkExist($row['id'])) { $destid = isset($GLOBALS['destid']) ? $GLOBALS['destid'] : 0; $py = Helper_Archive::getDestPinyin($destid); $py = !empty($py) ? $py : 'all'; //$row['url'] = $GLOBALS['cfg_cmsurl']."/raiders/search.php?attrid={$row['id']}&destid={$destid}"; $row['url'] = $GLOBALS['cfg_cmsurl'] . "/raiders/" . $py . '-' . $row['id']; $row['title'] = $row['attrname']; $row['number'] = getCount($row['id']); if ($flag == 'mdd') { $row['number'] = $row['num']; } foreach ($ctp->CTags as $tagid => $ctag) { if ($ctag->GetName() == 'array') { $ctp->Assign($tagid, $row); } else { if (!empty($row[$ctag->GetName()])) { $ctp->Assign($tagid, $row[$ctag->GetName()]); } } } $revalue .= $ctp->GetResult(); $GLOBALS['autoindex']++; } else { continue; } } return $revalue; }
function action() { if ($_SERVER["REQUEST_METHOD"] != "POST") { die("You can only reach this page by posting from the web page."); } $where = isset($_GET["where"]) ? $_GET["where"] : "home"; if (isset($_GET["mode"])) { if ($_GET["mode"] == "add") { addNew($where); } if ($_GET["mode"] == "getCount") { echo json_encode(array("count" => getCount($where))); } } exit; }
function getBestSeller($count = 4) { $getOrder = DB::query("SELECT order_content FROM `" . PREFIX . 'order' . "`"); if (DB::numRows($getOrder) != 0) { $product = new Models_Product(); while ($row = DB::fetchArray($getOrder)) { $orderData[] = unserialize(stripslashes($row['order_content'])); } $res = array(); foreach ($orderData as $k => $v) { foreach ($v as $key => $val) { $res[] = $product->getProduct($val['id']); } } $goodsSale = getCount($res); return array_slice($goodsSale, 0, $count); } }
function log_list() { pagetop(gTxt('visitor_logs')); extract(get_prefs()); safe_delete("txp_log", "`time` < date_sub(now(),interval " . $expire_logs_after . " day)"); safe_optimize("txp_log"); safe_repair("txp_log"); $page = gps('page'); $total = getCount('txp_log', "1"); $limit = 50; $numPages = ceil($total / $limit); $page = !$page ? 1 : $page; $offset = ($page - 1) * $limit; $nav[] = $page > 1 ? PrevNextLink("log", $page - 1, gTxt('prev'), 'prev') : ''; $nav[] = sp . small($page . '/' . $numPages) . sp; $nav[] = $page != $numPages ? PrevNextLink("log", $page + 1, gTxt('next'), 'next') : ''; $rs = safe_rows_start("*, unix_timestamp(time) as stamp", "txp_log", "1 order by time desc limit {$offset},{$limit}"); if ($rs) { echo startTable('list'), assHead('time', 'host', 'page', 'referrer'); $stamp = ''; while ($a = nextRow($rs)) { extract($a); if ($refer) { $referprint = preg_replace("/^www\\./", "", chunk(htmlspecialchars($refer), 50)); $referprint = '<a href="http://' . htmlspecialchars($refer) . '">' . $referprint . '</a>'; } else { $referprint = ' '; } $pageprint = preg_replace('/\\/$/', '', htmlspecialchars(substr($page, 1))); $pageprint = $pageprint == '' ? '' : '<a href="' . htmlspecialchars($page) . '" target="_blank">' . chunk($pageprint, 50) . '</a>'; if ($method == 'POST') { $pageprint = '<b>' . $pageprint . '</b>'; } $fstamp = date("n/j g:i a", $stamp + tz_offset()); $hostprint = chunk($host, 40); echo tr(td($fstamp) . td($hostprint) . td($pageprint) . td($referprint)); unset($refer, $referprint, $page, $pageprint); } echo '<tr><td colspan="4" align="right" style="padding:10px">', join('', $nav), "</td></tr>", endTable(); } else { echo graf(gTxt('no_refers_recorded'), ' align="center"'); } }
public function index() { //测试用,清空缓存 cache('', null); //幻灯片推荐作品 $workModel = D('Home/Works'); $this->assign('indextjwork', $workModel->indextjwork()); //新闻模块 //单条新闻 $firstnews = M('News')->field('title,id')->where(array('iftj' => true, 'status' => true))->order('sort DESC')->limit(1)->find(); $this->assign('firstnews', $firstnews); $this->assign('indextjnews', D('Home/News')->indextjnews()); //每日新秀 $this->assign('indexxinxiu', $workModel->worksxinxiu()); //中间广告位 $this->assign('indexmidad', parent::getAdvert(1, 1, 0, 5)); //左侧广告位 $this->assign('indexleftad', parent::getAdvert(1, 2, 0, 1)); //类别每日一荐 $this->assign('indexcatetj', $workModel->cateonework()); //焙友动态 $this->userDynamicData = D('Home/User')->userDynamic(5); //热门活动 $this->assign('activitytj', D('Home/Activity')->activitytj(2)); //右边上侧 $this->assign('rightopad', parent::getAdvert(1, 3, 0, 1)); //右边广告 $this->assign('indexrightad', parent::getAdvert(1, 3, 1, 3)); //分享达人 $this->assign('sharedaren', D('Home/User')->sharedaren(5, $this->userid)); //判断是否签到 $stime = strtotime(date('Y-m-d 00:00:00')); $etime = strtotime(date('Y-m-d 23:59:59')); $where['userid'] = array('EQ', $this->userid); $where['create_time'] = array(array('GT', $stime), array('LT', $etime), 'and'); $where['action'] = array('EQ', 'sign'); $map['create_time'] = array(array('GT', $stime), array('LT', $etime), 'and'); $map['action'] = array('EQ', 'sign'); $this->mysign = getCount('UserDynamic', $where); $this->signcount = getCount('UserDynamic', $map); $this->display(); }
/** *根据初始字符串来获得下面的字符串 *@param string $str 初始字符串 *@param integer $n 输出多少行 *@return void */ function lookSee($str, $n) { $result[0] = $str; for ($m = 0; $m < $n; $m++) { $str3 = ''; for ($k = 0; $k < strlen($result[$m]); $k++) { var_dump($str[$k]); $str1 = $str[$k]; var_dump($str1); if (!($str2 = getCount($str1, $str))) { break; } var_dump($str2); $str3 .= $str2 . $str1; //var_dump($str3); } $result[$m] = $str3; } return $result; }
/** * 会员登录页显示 */ public function index() { if (IS_POST) { //更新用户资料 $post = I('post.'); if (empty($post)) { $this->error('信息更新失败!'); } $result = M('User')->where(array('userid' => $this->userid))->save($post); if ($result !== false) { $this->success('您的资料更新成功!'); } else { $this->error('您的资料更新失败'); } } else { //省份 $this->province = M('Province')->field('province_id,province_name')->select(); if (!empty($this->userinfo['ucity']) && !empty($this->userinfo['uprovince'])) { $this->ucity = M('City')->where(array('province_id' => $this->userinfo['uprovince']))->select(); } if (!empty($this->userinfo['ucity']) && !empty($this->userinfo['uarea'])) { $this->uarea = M('Area')->where(array('city_id' => $this->userinfo['ucity']))->select(); } //数量统计 //烘焙作品数 $this->hbworksnum = getCount('Works', array('userid' => $this->userid, 'status' => true)); //随拍作品 $this->spworksnum = getCount('Suipai', array('userid' => $this->userid, 'status' => true)); //留言数 $this->msgnum = getCount('UserMessage', array('userid' => $this->userid, 'status' => true)); //试用报告数 $this->reportnum = getCount('TryReport', array('userid' => $this->userid, 'status' => true)); //收藏作品数 $this->favoritenum = getCount('UserFavorite', array('userid' => $this->userid, 'status' => true)); //修改头像密钥 $this->auth_key = urlencode(\Libs\Util\Encrypt::authcode($this->userid, '')); } $this->display(); }
function image_list($message = '') { global $txpcfg, $extensions, $path_from_root, $img_dir; $pfr = $path_from_root; extract($txpcfg); extract(get_prefs()); pagetop(gTxt('image'), $message); echo pageby_form('image', $article_list_pageby); echo startTable('list'), tr(tda(upload_form(gTxt('upload_file'), gTxt('upload'), 'image_insert'), ' colspan="4" style="border:0"')), tr(hCell(ucfirst(gTxt('name'))) . hCell(gTxt('image_category')) . hCell(gTxt('tags')) . hCell(gTxt('author')) . hCell(gTxt('thumbnail')) . hCell()); $page = gps('page'); $total = getCount('txp_image', "1"); $limit = 15; $numPages = ceil($total / $limit); $page = !$page ? 1 : $page; $offset = ($page - 1) * $limit; $nav[] = $page > 1 ? PrevNextLink("image", $page - 1, gTxt('prev'), 'prev') : ''; $nav[] = sp . small($page . '/' . $numPages) . sp; $nav[] = $page != $numPages ? PrevNextLink("image", $page + 1, gTxt('next'), 'next') : ''; $rs = safe_rows("*", "txp_image", "1 order by category,name limit {$offset},{$limit}"); if ($rs) { foreach ($rs as $a) { extract($a); $thumbnail = $thumbnail ? '<img src="' . $pfr . $img_dir . '/' . $id . 't' . $ext . '" />' : gTxt('no'); $elink = eLink('image', 'image_edit', 'id', $id, $name); $txtilelink = '<a target="_blank" href="?event=tag' . a . 'name=image' . a . 'id=' . $id . a . 'ext=' . $ext . a . 'alt=' . $alt . a . 'h=' . $h . a . 'w=' . $w . a . 'type=textile" onclick="window.open(this.href, \'popupwindow\', \'width=400,height=400,scrollbars,resizable\'); return false;">Textile</a>'; $txplink = '<a target="_blank" href="?event=tag' . a . 'name=image' . a . 'id=' . $id . a . 'type=textpattern" onclick="window.open(this.href, \'popupwindow\', \'width=400,height=400,scrollbars,resizable\'); return false;">Textpattern</a>'; $xhtmlink = '<a target="_blank" href="?event=tag' . a . 'name=image' . a . 'id=' . $id . a . 'ext=' . $ext . a . 'h=' . $h . a . 'w=' . $w . a . 'type=xhtml" onclick="window.open(this.href, \'popupwindow\', \'width=400,height=400,scrollbars,resizable\'); return false;">XHTML</a>'; $dlink = dLink('image', 'image_delete', 'id', $id); echo tr(td($elink) . td($category) . td($txtilelink . ' / ' . $txplink . ' / ' . $xhtmlink) . td($author) . td($thumbnail) . td($dlink, 10)); } echo tr(tdcs(graf(join('', $nav)), 4)); } echo endTable(); $imgdir = $doc_root . $path_from_root . $img_dir; if (!is_dir($imgdir) or !is_writeable($imgdir)) { echo graf(str_replace("{imgdir}", $imgdir, gTxt('img_dir_not_writeable')), ' style="text-align:center;color:red"'); } }
function link_list($message = "") { global $step, $link_list_pageby; extract(get_prefs()); $page = gps('page'); $total = getCount('txp_link', "1"); $limit = $link_list_pageby; $numPages = ceil($total / $limit); $page = !$page ? 1 : $page; $offset = ($page - 1) * $limit; $sort = gps('sort'); $dir = gps('dir'); $sort = $sort ? $sort : 'linksort'; $dir = $dir ? $dir : 'asc'; if ($dir == "desc") { $dir = "asc"; } else { $dir = "desc"; } $nav[] = $page > 1 ? PrevNextLink("link", $page - 1, gTxt('prev'), 'prev') : ''; $nav[] = sp . small($page . '/' . $numPages) . sp; $nav[] = $page != $numPages ? PrevNextLink("link", $page + 1, gTxt('next'), 'next') : ''; $rs = safe_rows("*", "txp_link", "1 order by {$sort} {$dir} limit {$offset},{$limit}"); if ($rs) { echo '<form action="index.php" method="post" onsubmit="return verify(\'' . gTxt('are_you_sure') . '\')">', startTable('list'), tr(column_head('link_name', 'linksort', 'link', 1, $dir) . column_head('description', 'description', 'link', 1, $dir) . column_head('link_category', 'category', 'link', 1, $dir) . td()); foreach ($rs as $a) { extract($a); $elink = eLink('link', 'link_edit', 'id', $id, $linkname); $cbox = fInput('checkbox', 'selected[]', $id); echo tr(td($elink) . td($description) . td($category) . td($cbox)); } echo tr(tda(link_multiedit_form(), ' colspan="4" style="border:0px;text-align:right"')); echo endTable(), '</form>'; echo pageby_form('link', $link_list_pageby); echo graf(join('', $nav), ' align="center"'); } }
/** * The main author list. * * @param string|array $message The activity message */ function author_list($message = '') { global $txp_user, $author_list_pageby; pagetop(gTxt('tab_site_admin'), $message); if (is_disabled('mail')) { echo graf(span(null, array('class' => 'ui-icon ui-icon-alert')) . ' ' . gTxt('warn_mail_unavailable'), array('class' => 'alert-block warning')); } echo hed(gTxt('tab_site_admin'), 1, array('class' => 'txp-heading')); echo n . '<div id="users_control" class="txp-control-panel">'; $buttons = array(); // Change password button. $buttons[] = sLink('admin', 'new_pass_form', gTxt('change_password')); if (!has_privs('admin.edit')) { // Change email address button. $buttons[] = sLink('admin', 'change_email_form', gTxt('change_email_address')); } else { // New author button. $buttons[] = sLink('admin', 'author_edit', gTxt('add_new_author')); } echo graf(join(n, $buttons), array('class' => 'txp-buttons')); // User list. if (has_privs('admin.list')) { extract(gpsa(array('page', 'sort', 'dir', 'crit', 'search_method'))); if ($sort === '') { $sort = get_pref('admin_sort_column', 'name'); } if ($dir === '') { $dir = get_pref('admin_sort_dir', 'asc'); } $dir = $dir == 'desc' ? 'desc' : 'asc'; if (!in_array($sort, array('name', 'RealName', 'email', 'privs', 'last_login'))) { $sort = 'name'; } $sort_sql = $sort . ' ' . $dir; set_pref('admin_sort_column', $sort, 'admin', 2, '', 0, PREF_PRIVATE); set_pref('admin_sort_dir', $dir, 'admin', 2, '', 0, PREF_PRIVATE); $switch_dir = $dir == 'desc' ? 'asc' : 'desc'; $criteria = 1; if ($search_method and $crit != '') { $verbatim = preg_match('/^"(.*)"$/', $crit, $m); $crit_escaped = $verbatim ? doSlash($m[1]) : doLike($crit); $critsql = $verbatim ? array('id' => "user_id in ('" . join("','", do_list($crit_escaped)) . "')", 'login' => "name = '{$crit_escaped}'", 'real_name' => "RealName = '{$crit_escaped}'", 'email' => "email = '{$crit_escaped}'", 'privs' => "convert(privs, char) in ('" . join("','", do_list($crit_escaped)) . "')") : array('id' => "user_id in ('" . join("','", do_list($crit_escaped)) . "')", 'login' => "name like '%{$crit_escaped}%'", 'real_name' => "RealName like '%{$crit_escaped}%'", 'email' => "email like '%{$crit_escaped}%'", 'privs' => "convert(privs, char) in ('" . join("','", do_list($crit_escaped)) . "')"); if (array_key_exists($search_method, $critsql)) { $criteria = $critsql[$search_method]; } else { $search_method = ''; $crit = ''; } } else { $search_method = ''; $crit = ''; } $criteria .= callback_event('admin_criteria', 'author_list', 0, $criteria); $total = getCount('txp_users', $criteria); if ($total < 1) { if ($criteria != 1) { echo n . author_search_form($crit, $search_method) . graf(gTxt('no_results_found'), ' class="indicator"') . '</div>'; } return; } $limit = max($author_list_pageby, 15); list($page, $offset, $numPages) = pager($total, $limit, $page); $use_multi_edit = has_privs('admin.edit') && safe_count('txp_users', '1=1') > 1; echo author_search_form($crit, $search_method) . '</div>'; $rs = safe_rows_start('*, unix_timestamp(last_access) as last_login', 'txp_users', "{$criteria} order by {$sort_sql} limit {$offset}, {$limit}"); if ($rs) { echo n . tag_start('div', array('id' => 'users_container', 'class' => 'txp-container')) . n . tag_start('form', array('action' => 'index.php', 'id' => 'users_form', 'class' => 'multi_edit_form', 'method' => 'post', 'name' => 'longform')) . n . tag_start('div', array('class' => 'txp-listtables')) . n . tag_start('table', array('class' => 'txp-list')) . n . tag_start('thead') . tr(($use_multi_edit ? hCell(fInput('checkbox', 'select_all', 0, '', '', '', '', '', 'select_all'), '', ' scope="col" title="' . gTxt('toggle_all_selected') . '" class="txp-list-col-multi-edit"') : hCell('', '', ' scope="col" class="txp-list-col-multi-edit"')) . column_head('login_name', 'name', 'admin', true, $switch_dir, '', '', ('name' == $sort ? "{$dir} " : '') . 'txp-list-col-login-name name') . column_head('real_name', 'RealName', 'admin', true, $switch_dir, '', '', ('RealName' == $sort ? "{$dir} " : '') . 'txp-list-col-real-name name') . column_head('email', 'email', 'admin', true, $switch_dir, '', '', ('email' == $sort ? "{$dir} " : '') . 'txp-list-col-email') . column_head('privileges', 'privs', 'admin', true, $switch_dir, '', '', ('privs' == $sort ? "{$dir} " : '') . 'txp-list-col-privs') . column_head('last_login', 'last_login', 'admin', true, $switch_dir, '', '', ('last_login' == $sort ? "{$dir} " : '') . 'txp-list-col-last-login date')) . n . tag_end('thead') . n . tag_start('tbody'); while ($a = nextRow($rs)) { extract(doSpecial($a)); echo tr(td((has_privs('admin.edit') and $txp_user != $a['name']) ? fInput('checkbox', 'selected[]', $a['name'], 'checkbox') : '', '', 'txp-list-col-multi-edit') . hCell(has_privs('admin.edit') ? eLink('admin', 'author_edit', 'user_id', $user_id, $name) : $name, '', ' scope="row" class="txp-list-col-login-name name"') . td($RealName, '', 'txp-list-col-real-name name') . td(href($email, 'mailto:' . $email), '', 'txp-list-col-email') . td(get_priv_level($privs), '', 'txp-list-col-privs') . td($last_login ? safe_strftime('%b %Y', $last_login) : '', '', 'txp-list-col-last-login date')); } echo n . tag_end('tbody') . n . tag_end('table') . n . tag_end('div') . ($use_multi_edit ? author_multiedit_form($page, $sort, $dir, $crit, $search_method) : '') . tInput() . n . tag_end('form') . n . tag_start('div', array('id' => 'users_navigation', 'class' => 'txp-navigation')) . pageby_form('admin', $author_list_pageby) . nav_form('admin', $page, $numPages, $sort, $dir, $crit, $search_method) . n . tag_end('div') . n . tag_end('div'); } } else { echo n . tag_end('div'); } }
function rss() { global $prefs, $thisarticle; extract($prefs); ob_start(); extract(doSlash(gpsa(array('category', 'section', 'limit', 'area')))); $area = gps('area'); $sitename .= $section ? ' - ' . $section : ''; $sitename .= $category ? ' - ' . $category : ''; $out[] = tag(doSpecial($sitename), 'title'); $out[] = tag(hu, 'link'); $out[] = tag(doSpecial($site_slogan), 'description'); $articles = array(); if (!$area or $area == 'article') { $sfilter = $section ? "and Section = '" . $section . "'" : ''; $cfilter = $category ? "and (Category1='" . $category . "' or Category2='" . $category . "')" : ''; $limit = $limit ? $limit : '5'; $frs = safe_column("name", "txp_section", "in_rss != '1'"); if ($frs) { foreach ($frs as $f) { $query[] = "and Section != '" . $f . "'"; } } $query[] = $sfilter; $query[] = $cfilter; $rs = safe_rows_start("*, unix_timestamp(Posted) as uPosted, ID as thisid", "textpattern", "Status = 4 " . join(' ', $query) . "and Posted < now() order by Posted desc limit {$limit}"); if ($rs) { while ($a = nextRow($rs)) { extract($a); populateArticleData($a); $a['posted'] = $uPosted; $Body = !$syndicate_body_or_excerpt ? $thisarticle['body'] : $thisarticle['excerpt']; $Body = !trim($Body) ? $thisarticle['body'] : $Body; $Body = str_replace('href="/', 'href="' . hu, $Body); $Body = preg_replace("/href=\\\"#(.*)\"/", "href=\"" . permlinkurl($a) . "#\\1\"", $Body); $Body = safe_hed($Body); $Body = preg_replace(array('/</', '/>/', "/'/", '/"/'), array('<', '>', ''', '"'), $Body); // encode bare ampersands $Body = preg_replace("/&(?![#0-9]+;|\\w+;)/i", '&', $Body); $uTitle = $url_title ? $url_title : stripSpace($Title); $uTitle = htmlspecialchars($uTitle, ENT_NOQUOTES); if ($show_comment_count_in_feed) { $dc = getCount('txp_discuss', "parentid={$ID} and visible=1"); $count = $dc > 0 ? ' [' . $dc . ']' : ''; } else { $count = ''; } $Title = doSpecial($Title) . $count; $permlink = permlinkurl($a); $item = tag(strip_tags($Title), 'title') . n . tag($Body, 'description') . n . tag($permlink, 'link'); $articles[$ID] = tag($item, 'item'); $etags[$ID] = strtoupper(dechex(crc32($articles[$ID]))); $dates[$ID] = $uPosted; } } } elseif ($area == 'link') { $cfilter = $category ? "category='{$category}'" : '1'; $limit = $limit ? $limit : 15; $rs = safe_rows_start("*", "txp_link", "{$cfilter} order by date desc limit {$limit}"); if ($rs) { while ($a = nextRow($rs)) { extract($a); $item = tag(doSpecial($linkname), 'title') . n . tag(doSpecial($description), 'description') . n . tag(doSpecial($url), 'link'); $articles[$id] = tag($item, 'item'); $etags[$id] = strtoupper(dechex(crc32($articles[$id]))); $dates[$id] = $date; } } } //turn on compression if we aren't using it already if (extension_loaded('zlib') && ini_get("zlib.output_compression") == 0 && ini_get('output_handler') != 'ob_gzhandler' && !headers_sent()) { ob_start("ob_gzhandler"); } $last = fetch('unix_timestamp(val)', 'txp_prefs', 'name', 'lastmod'); $last = gmdate("D, d M Y H:i:s \\G\\M\\T", $last); header("Last-Modified: {$last}"); $expires = gmdate('D, d M Y H:i:s \\G\\M\\T', time() + 3600 * 1); header("Expires: {$expires}"); $hims = serverset('HTTP_IF_MODIFIED_SINCE'); if ($hims == $last) { header("HTTP/1.1 304 Not Modified"); exit; } $imsd = @strtotime($hims); if (is_callable('apache_request_headers')) { $headers = apache_request_headers(); if (isset($headers["A-IM"])) { $canaim = strpos($headers["A-IM"], "feed"); } else { $canaim = false; } } else { $canaim = false; } $hinm = stripslashes(serverset('HTTP_IF_NONE_MATCH')); $cutarticles = false; if ($canaim !== false) { foreach ($articles as $id => $thing) { if (strpos($hinm, $etags[$id]) !== false) { unset($articles[$id]); $cutarticles = true; $cut_etag = true; } if ($dates[$id] < $imsd) { unset($articles[$id]); $cutarticles = true; $cut_time = true; } } } if (isset($cut_etag) && isset($cut_time)) { header("Vary: If-None-Match, If-Modified-Since"); } else { if (isset($cut_etag)) { header("Vary: If-None-Match"); } else { if (isset($cut_time)) { header("Vary: If-Modified-Since"); } } } $etag = @join("-", $etags); if (strstr($hinm, $etag)) { header("HTTP/1.1 304 Not Modified"); exit; } if ($cutarticles) { //header("HTTP/1.1 226 IM Used"); //This should be used as opposed to 200, but Apache doesn't like it. //http://intertwingly.net/blog/2004/09/11/Vary-ETag/ says that the status code should be 200. header("Cache-Control: no-store, im"); header("IM: feed"); } $out = array_merge($out, $articles); header("Content-Type: application/rss+xml; charset=utf-8"); if ($etag) { header('ETag: "' . $etag . '"'); } return '<rss version="0.92">' . tag(join(n, $out), 'channel') . '</rss>'; }
function author_list() { global $txp_user, $author_list_pageby; extract(gpsa(array('page', 'sort', 'dir', 'crit', 'search_method'))); if (!in_array($sort, array('name', 'RealName', 'email', 'privs', 'last_login'))) { $sort = 'name'; } $dir = $dir == 'desc' ? 'desc' : 'asc'; $sort_sql = $sort . ' ' . $dir; $switch_dir = $dir == 'desc' ? 'asc' : 'desc'; $total = getCount('txp_users', '1=1'); $limit = max($author_list_pageby, 15); list($page, $offset, $numPages) = pager($total, $limit, $page); $rs = safe_rows_start('*, unix_timestamp(last_access) as last_login', 'txp_users', '1 = 1 order by ' . $sort_sql . ' limit ' . $offset . ', ' . $limit); if ($rs) { echo '<form action="index.php" method="post" name="longform" onsubmit="return verify(\'' . gTxt('are_you_sure') . '\')">' . startTable('list') . tr(column_head('login_name', 'name', 'admin', true, $switch_dir, '', '', 'name' == $sort ? $dir : '') . column_head('real_name', 'RealName', 'admin', true, $switch_dir, '', '', 'RealName' == $sort ? $dir : '') . column_head('email', 'email', 'admin', true, $switch_dir, '', '', 'email' == $sort ? $dir : '') . column_head('privileges', 'privs', 'admin', true, $switch_dir, '', '', 'privs' == $sort ? $dir : '') . column_head('last_login', 'last_login', 'admin', true, $switch_dir, '', '', 'last_login' == $sort ? $dir : '') . hCell() . hCell()); while ($a = nextRow($rs)) { extract(doSpecial($a)); echo tr(td($name) . td($RealName) . td('<a href="mailto:' . $email . '">' . $email . '</a>') . td(get_priv_level($privs)) . td($last_login ? safe_strftime('%b %Y', $last_login) : '') . td(has_privs('admin.edit') ? eLink('admin', 'author_edit', 'user_id', $user_id, gTxt('edit')) : '') . td((has_privs('admin.edit') and $txp_user != $a['name']) ? fInput('checkbox', 'selected[]', $a['name']) : '')); } echo n . n . tr(tda(select_buttons() . author_multiedit_form($page, $sort, $dir, $crit, $search_method), ' colspan="6" style="text-align: right; border: none;"')) . endTable() . '</form>' . nav_form('admin', $page, $numPages, $sort, $dir, $crit, $search_method) . pageby_form('admin', $author_list_pageby); } }
function link_list($message = '') { global $step, $link_list_pageby; extract(gpsa(array('page', 'sort', 'dir', 'crit', 'search_method'))); $dir = $dir == 'desc' ? 'desc' : 'asc'; switch ($sort) { case 'id': $sort_sql = 'id ' . $dir; break; case 'description': $sort_sql = 'description ' . $dir . ', id asc'; break; case 'category': $sort_sql = 'category ' . $dir . ', id asc'; break; case 'date': $sort_sql = 'date ' . $dir . ', id asc'; break; default: $sort = 'name'; $sort_sql = 'linksort ' . $dir . ', id asc'; break; } $switch_dir = $dir == 'desc' ? 'asc' : 'desc'; $criteria = 1; if ($search_method and $crit) { $crit_escaped = doSlash($crit); $critsql = array('id' => "ID in ('" . join("','", do_list($crit_escaped)) . "')", 'name' => "linkname like '%{$crit_escaped}%'", 'description' => "description like '%{$crit_escaped}%'", 'category' => "category like '%{$crit_escaped}%'"); if (array_key_exists($search_method, $critsql)) { $criteria = $critsql[$search_method]; } else { $search_method = ''; $crit = ''; } } else { $search_method = ''; $crit = ''; } $total = getCount('txp_link', $criteria); if ($total < 1) { if ($criteria != 1) { echo n . link_search_form($crit, $search_method) . n . graf(gTxt('no_results_found'), ' class="indicator"'); } else { echo n . graf(gTxt('no_links_recorded'), ' class="indicator"'); } return; } $limit = max($link_list_pageby, 15); list($page, $offset, $numPages) = pager($total, $limit, $page); echo link_search_form($crit, $search_method); $rs = safe_rows_start('*, unix_timestamp(date) as uDate', 'txp_link', "{$criteria} order by {$sort_sql} limit {$offset}, {$limit}"); if ($rs) { echo n . n . '<form action="index.php" method="post" name="longform" onsubmit="return verify(\'' . gTxt('are_you_sure') . '\')">', startTable('list') . n . tr(column_head('ID', 'id', 'link', true, $switch_dir, $crit, $search_method, 'id' == $sort ? $dir : '') . hCell() . column_head('link_name', 'name', 'link', true, $switch_dir, $crit, $search_method, 'name' == $sort ? $dir : '') . column_head('description', 'description', 'link', true, $switch_dir, $crit, $search_method, 'description' == $sort ? $dir : '') . column_head('link_category', 'category', 'link', true, $switch_dir, $crit, $search_method, 'category' == $sort ? $dir : '') . column_head('date', 'date', 'link', true, $switch_dir, $crit, $search_method, 'date' == $sort ? $dir : '') . hCell()); while ($a = nextRow($rs)) { extract($a); $edit_url = '?event=link' . a . 'step=link_edit' . a . 'id=' . $id . a . 'sort=' . $sort . a . 'dir=' . $dir . a . 'page=' . $page . a . 'search_method=' . $search_method . a . 'crit=' . $crit; echo tr(n . td($id, 20) . td(n . '<ul>' . n . t . '<li>' . href(gTxt('edit'), $edit_url) . '</li>' . n . t . '<li>' . href(gTxt('view'), $url) . '</li>' . n . '</ul>', 35) . td(href(htmlspecialchars($linkname), $edit_url), 125) . td(htmlspecialchars($description), 150) . td('<span title="' . htmlspecialchars(fetch_category_title($category, 'link')) . '">' . $category . '</span>', 125) . td(gTime($uDate), 75) . td(fInput('checkbox', 'selected[]', $id))); } echo n . n . tr(tda(select_buttons() . link_multiedit_form($page, $sort, $dir, $crit, $search_method), ' colspan="7" style="text-align: right; border: none;"')) . endTable() . '</form>' . n . nav_form('link', $page, $numPages, $sort, $dir, $crit, $search_method, $total, $limit) . pageby_form('link', $link_list_pageby); } }
} /** Get the number of results by using the google API */ function getCount($fp, $obj) { $url = "http://ajax.googleapis.com/ajax/services/search/web?v=1.0&q=" . $obj; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_REFERER, 'http://blog.Stackr.fr'); $body = curl_exec($ch); curl_close($ch); // Decode the JSON string to an associative array $json = json_decode($body, true); // Fetch the number of results fprintf($fp, $obj . '; ' . $json['responseData']['cursor']['estimatedResultCount'] . "\n"); } /** * Main part of the code : words generation & getCount calls */ $letters = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"); foreach ($letters as $fLetter) { foreach ($letters as $sLetter) { foreach ($letters as $tLetter) { foreach ($letters as $foLetter) { getCount($fp, $fLetter . $sLetter . $tLetter . $foLetter); } } } }
function link_list($message = '') { global $event, $step, $link_list_pageby, $txp_user; pagetop(gTxt('tab_link'), $message); extract(gpsa(array('page', 'sort', 'dir', 'crit', 'search_method'))); if ($sort === '') { $sort = get_pref('link_sort_column', 'name'); } if ($dir === '') { $dir = get_pref('link_sort_dir', 'asc'); } $dir = $dir == 'desc' ? 'desc' : 'asc'; switch ($sort) { case 'id': $sort_sql = 'id ' . $dir; break; case 'description': $sort_sql = 'description ' . $dir . ', id asc'; break; case 'url': $sort_sql = 'url ' . $dir . ', id asc'; break; case 'category': $sort_sql = 'category ' . $dir . ', id asc'; break; case 'date': $sort_sql = 'date ' . $dir . ', id asc'; break; case 'author': $sort_sql = 'author ' . $dir . ', id asc'; break; default: $sort = 'name'; $sort_sql = 'linksort ' . $dir . ', id asc'; break; } set_pref('link_sort_column', $sort, 'link', 2, '', 0, PREF_PRIVATE); set_pref('link_sort_dir', $dir, 'link', 2, '', 0, PREF_PRIVATE); $switch_dir = $dir == 'desc' ? 'asc' : 'desc'; $criteria = 1; if ($search_method and $crit != '') { $verbatim = preg_match('/^"(.*)"$/', $crit, $m); $crit_escaped = doSlash($verbatim ? $m[1] : str_replace(array('\\', '%', '_', '\''), array('\\\\', '\\%', '\\_', '\\\''), $crit)); $critsql = $verbatim ? array('id' => "ID in ('" . join("','", do_list($crit_escaped)) . "')", 'name' => "linkname = '{$crit_escaped}'", 'description' => "description = '{$crit_escaped}'", 'url' => "url = '{$crit_escaped}'", 'category' => "category = '{$crit_escaped}'", 'author' => "author = '{$crit_escaped}'") : array('id' => "ID in ('" . join("','", do_list($crit_escaped)) . "')", 'name' => "linkname like '%{$crit_escaped}%'", 'description' => "description like '%{$crit_escaped}%'", 'url' => "url like '%{$crit_escaped}%'", 'category' => "category like '%{$crit_escaped}%'", 'author' => "author like '%{$crit_escaped}%'"); if (array_key_exists($search_method, $critsql)) { $criteria = $critsql[$search_method]; } else { $search_method = ''; $crit = ''; } } else { $search_method = ''; $crit = ''; } $criteria .= callback_event('admin_criteria', 'link_list', 0, $criteria); $total = getCount('txp_link', $criteria); echo '<h1 class="txp-heading">' . gTxt('tab_link') . '</h1>'; echo '<div id="' . $event . '_control" class="txp-control-panel">'; if (has_privs('link.edit')) { echo graf(sLink('link', 'link_edit', gTxt('add_new_link')), ' class="txp-buttons"'); } if ($total < 1) { if ($criteria != 1) { echo n . link_search_form($crit, $search_method) . n . graf(gTxt('no_results_found'), ' class="indicator"') . '</div>'; } else { echo n . graf(gTxt('no_links_recorded'), ' class="indicator"') . '</div>'; } return; } $limit = max($link_list_pageby, 15); list($page, $offset, $numPages) = pager($total, $limit, $page); echo link_search_form($crit, $search_method) . '</div>'; $rs = safe_rows_start('*, unix_timestamp(date) as uDate', 'txp_link', "{$criteria} order by {$sort_sql} limit {$offset}, {$limit}"); if ($rs) { $show_authors = !has_single_author('txp_link'); echo n . '<div id="' . $event . '_container" class="txp-container">'; echo n . n . '<form action="index.php" id="links_form" class="multi_edit_form" method="post" name="longform">', n . '<div class="txp-listtables">' . n . startTable('', '', 'txp-list') . n . '<thead>' . n . tr(n . hCell(fInput('checkbox', 'select_all', 0, '', '', '', '', '', 'select_all'), '', ' title="' . gTxt('toggle_all_selected') . '" class="multi-edit"') . n . column_head('ID', 'id', 'link', true, $switch_dir, $crit, $search_method, ('id' == $sort ? "{$dir} " : '') . 'id') . n . column_head('link_name', 'name', 'link', true, $switch_dir, $crit, $search_method, ('name' == $sort ? "{$dir} " : '') . 'name') . n . column_head('description', 'description', 'link', true, $switch_dir, $crit, $search_method, ('description' == $sort ? "{$dir} " : '') . 'links_detail description') . n . column_head('link_category', 'category', 'link', true, $switch_dir, $crit, $search_method, ('category' == $sort ? "{$dir} " : '') . 'category') . n . column_head('url', 'url', 'link', true, $switch_dir, $crit, $search_method, ('url' == $sort ? "{$dir} " : '') . 'url') . n . column_head('date', 'date', 'link', true, $switch_dir, $crit, $search_method, ('date' == $sort ? "{$dir} " : '') . 'links_detail date created') . ($show_authors ? n . column_head('author', 'author', 'link', true, $switch_dir, $crit, $search_method, ('author' == $sort ? "{$dir} " : '') . 'author') : '')) . n . '</thead>'; echo '<tbody>'; $validator = new Validator(); while ($a = nextRow($rs)) { extract($a, EXTR_PREFIX_ALL, 'link'); $edit_url = '?event=link' . a . 'step=link_edit' . a . 'id=' . $link_id . a . 'sort=' . $sort . a . 'dir=' . $dir . a . 'page=' . $page . a . 'search_method=' . $search_method . a . 'crit=' . $crit; $validator->setConstraints(array(new CategoryConstraint($link_category, array('type' => 'link')))); $vc = $validator->validate() ? '' : ' error'; $can_edit = has_privs('link.edit') || $link_author == $txp_user && has_privs('link.edit.own'); $view_url = txpspecialchars($link_url); echo tr(n . td(fInput('checkbox', 'selected[]', $link_id), '', 'multi-edit') . n . td($can_edit ? href($link_id, $edit_url, ' title="' . gTxt('edit') . '"') : $link_id, '', 'id') . td($can_edit ? href(txpspecialchars($link_linkname), $edit_url, ' title="' . gTxt('edit') . '"') : txpspecialchars($link_linkname), '', 'name') . td(txpspecialchars($link_description), '', 'links_detail description') . td('<span title="' . txpspecialchars(fetch_category_title($link_category, 'link')) . '">' . $link_category . '</span>', '', 'category' . $vc) . td('<a rel="external" target="_blank" href="' . $view_url . '">' . $view_url . '</a>', '', 'url') . td(gTime($link_uDate), '', 'links_detail date created') . ($show_authors ? td('<span title="' . txpspecialchars(get_author_name($link_author)) . '">' . txpspecialchars($link_author) . '</span>', '', 'author') : '')); } echo '</tbody>', n, endTable(), n, '</div>', n, link_multiedit_form($page, $sort, $dir, $crit, $search_method), n, tInput(), n, '</form>', n, graf(toggle_box('links_detail'), ' class="detail-toggle"'), n, '<div id="' . $event . '_navigation" class="txp-navigation">', n, nav_form('link', $page, $numPages, $sort, $dir, $crit, $search_method, $total, $limit), n, pageby_form('link', $link_list_pageby), n, '</div>', n, '</div>'; } }
} ?> <b>Agent Seal No.</b> <?php echo $agent_seal_no; ?> <br/> </td> <td valign="top"><b><?php echo $no_pkg; ?> </b> STANDARD EXPORT SEAWORTHY PALLENTS </td> <td valign="top" style="border-right:#000000 solid thin;" class="print_text"> <?php echo getCount('Count', 'rec_id', $row_detail['CountId']); ?> <?php echo getProduct('ProductName', 'rec_id', $row_detail['ProductId']); ?> <br/><br/> <b>H.S. CODE :</b> <?php echo $hs_code; ?> </td> <td valign="top" style="border-right:#000000 solid thin;" class="print_text"><?php echo $row_detail['NowOfferedQty']; ?> </td> <td valign="top" style="border-right:#000000 solid thin;" align="center"><span class="print_text"><?php echo $row_detail['Price'];
<td align="center" style="border-bottom:#000000 solid 1px;"><span class="print_text">AMOUNT (Rs.)</span></td> </tr> <? $sql_detail = "select * from ".$mysql_adm_table_prefix."pi_detail where PiId = '$rec_id'"; $result_detail = mysql_query($sql_detail) or die("Error in Query : ".$sql_detail."<br/>".mysql_error()."<br/>".mysql_errno()); $i = 1; $total_qty = 0; $total_amount = 0; $no_pck = 0; while($row_detail = mysql_fetch_array($result_detail)) { ?> <tr style="vertical-align:top"> <td align="center" style="border-right:#000000 solid 1px;"><span class="print_text"><?=$i?></span></td> <td class="print_text" style="border-right:#000000 solid 1px;"><?=getCount('Count','rec_id',$row_detail['CountId'])?> <?=getProduct('ProductName','rec_id',$row_detail['ProductId'])?></td> <td align="center" style="border-right:#000000 solid 1px;"><span class="print_text"><?=$no_pck?> </span></td> <td align="center" style="border-right:#000000 solid 1px;"><span class="print_text"><?=$row_detail['Quantity']?></span></td> <td align="right" style="border-right:#000000 solid 1px;padding-right:5px;"><span class="print_text"><?=$row_detail['Price']?></span></td> <td align="right" style="padding-right:5px;"><span class="print_text"><? $amount = round($row_detail['Quantity']*$row_detail['Price']);echo $amount;?></span></td> </tr> <? $i++; $total_qty = $total_qty+$row_detail['Quantity']; $total_amount = $total_amount+$amount; } ?> <tr style="height:30px;"> <td class="print_text" style="border-right:#000000 solid 1px;padding-top:10px;"> </td> <td align="right" style="border-right:#000000 solid 1px;padding-right:5px;padding-top:10px;"><span class="print_text"><b>Total</b></span></td> <td align="center" style="border-right:#000000 solid 1px;padding-top:10px;"><span class="print_text"><?=$no_pck?></span> </td>
<td class="gredBg"> <strong>Closing Bags</strong> </td> </tr>--> <? $sno = 1; while($row = mysql_fetch_array($result)) { $CountId = $row["CountId"]; ?> <tr <? if ($sno%2==1) { ?> bgcolor="#F5F2F1" <? } ?>> <td class="text_1"> <?php echo getCount('Count', 'rec_id', $CountId); ?> </td> <td class="text_1"> <?php echo $row["LotNumber"]; ?> </td> <td class="text_1"> <?php echo $row["StockInKgs"]; ?> </td> <td class="text_1">
function getHeadHunters($logos = 0, $random = 0) { global $objDb; $head_hunters = array(); if ($logos == 1) { $sqlRec = "select * from job_recruiter where rec_status=1 and comp_logo!='' order by rand()"; } else { $sqlRec = "select * from job_recruiter where rec_status=1 order by rand()"; } $resultRec = $objDb->ExecuteQuery($sqlRec); while ($rsRec = mysql_fetch_object($resultRec)) { $rec_id = $rsRec->rec_id; //get last invoice details $sqlLastInvoice = "select * from job_rec_invoices i where i.invoice_type=1 and i.rec_id=" . $rec_id . " and (select count(*) from job_rec_payments where invoice_id=i.invoice_id)>0 order by i.invoice_id desc"; $resultLastInvoice = $objDb->ExecuteQuery($sqlLastInvoice); if ($rsLastInvoice = mysql_fetch_object($resultLastInvoice)) { //get first payment details for last invoice of plan purchased. $sqlFirstPay = "select * from job_rec_payments where invoice_id=" . $rsLastInvoice->invoice_id . " and pay_status=1 order by pay_id"; $resultFirstPay = $objDb->ExecuteQuery($sqlFirstPay); if ($rsFirstPay = mysql_fetch_object($resultFirstPay)) { $first_pay_date = $rsFirstPay->pay_date; //get the shortlisted jobseekers count $cntShortlisted = getCount("select * from job_shortlisted_jobseekers j, job_rec_invoices i, job_rec_payments p where p.invoice_id=i.invoice_id and i.invoice_id=j.invoice_id and i.invoice_date>=" . $first_pay_date . " and i.invoice_id>" . $rsLastInvoice->invoice_id . " and i.rec_id=" . $rec_id); //check account expired or not $activated_before = 1; $date2 = date("Y-m-d"); $date1 = $rsFirstPay->pay_date; $difference = abs(strtotime($date2) - strtotime($date1)); //calculate the number of days $days = round($difference / 60 / 60 / 24, 0); if ($days <= 30) { $expired = 0; $head_hunters[$rec_id] = $cntShortlisted; } } } } if ($random == 0) { arsort($head_hunters); } return $head_hunters; }
/** * 作品详情展示 */ public function detail() { $workid = I('get.workid'); if (empty($workid)) { $this->error('您访问的页面不存在'); } //增加点击数 M('Works')->where(array('workid' => $workid))->setInc('clicknum'); $detail = D('Works')->relation(true)->find($workid); if (!$detail) { $this->error('您访问的作品不存在'); } //start yf $yf_thumb = array(); $yf_pic = array(); if (!empty($detail['all_pic'])) { $yf_arr = json_decode($detail['all_pic'], true); $yf_temp = array(); foreach ($yf_arr as $k => $v) { $yf_thumb[] = $v; $yf_ex = explode("/", $v); $yf_ex[count($yf_ex) - 1] = str_replace("yf_", "", $yf_ex[count($yf_ex) - 1]); $yf_pic[] = implode("/", $yf_ex); } } else { $yf_arr = array(); $yf_thumb[] = $yf_pic[] = $detail['image']; } $detail['pic_num'] = count($yf_thumb); $detail['thumb'] = implode(",", $yf_thumb); $detail['pic'] = implode(",", $yf_pic); $detail['WorksMaterials_count'] = count($detail['WorksMaterials']); //end $this->assign('data', $detail); //点赞总数 $this->digallnum = $detail['goodnum'] + $detail['badnum']; //综合评价 if ($detail['goodnum'] == 0 && $detail['badnum'] == 0) { $dig['digavg'] = 0; $dig['goodprecent'] = 50; $dig['badprecent'] = 50; } else { $digavg = round($detail['goodnum'] / ($detail['goodnum'] + $detail['badnum']), 2); $dig['digavg'] = $digavg * 10; $dig['goodprecent'] = $digavg * 100; $dig['badprecent'] = (1 - $digavg) * 100; } $this->dig = $dig; //点赞判断 $this->digtype = M('Dig')->field('digtype,id')->where(array('userid' => $this->userid, 'status' => true, 'infoid' => $workid))->find(); //收藏判断 $this->favoritenum = getCount('UserFavorite', array('userid' => $this->userid, 'status' => true, 'infoid' => $workid)); //右侧广告 $this->rightad = parent::getAdvert(8, 3, 0, 2); //点赞人员列表 $diguser = new Model(); $diguerlist = $diguser->table(array(C('DB_PREFIX') . 'dig' => 'D', C('DB_PREFIX') . 'user' => 'U'))->where('D.userid=U.userid and D.status=true and D.digtype=1 and D.infoid=' . $workid . '')->field('U.uavatar,U.openuid')->select(); $this->assign('diglist', $diguerlist); //评论 $where['infoid'] = $workid; $where['type'] = 1; $where['parent_id'] = 0; $count = M('UserMessage')->where($where)->count(); // $limitRows = 5; // 设置每页记录数 $limitRows = C('YF_PAGE'); $page = $this->ajaxpage($count, $limitRows, '#msg', 'ajax_div', 'ajax_page_div'); $Model = new Model(); $message = $Model->table(array(C('DB_PREFIX') . 'user_message' => 'M', C('DB_PREFIX') . 'user' => 'U'))->where('M.userid=U.userid and M.status=true and M.infoid=' . $workid . ' and M.type=1 and M.parent_id=0')->field('M.create_time,M.content,U.nickname,U.uavatar,U.openuid,U.uprovince,U.ucity,U.userid,M.id,M.touserid,U.ifrz')->order('M.create_time DESC')->limit($page->firstRow . ',' . $page->listRows)->select(); foreach ($message as $k => $v) { $child_temp = array(); $child_temp = $Model->table(C('DB_PREFIX') . 'user_message')->field('*')->where(array('parent_id' => $v['id']))->order('create_time ASC')->select(); $message[$k]['childlist'] = array(); if ($child_temp) { foreach ($child_temp as $yk => $yv) { if ($yv['userid'] == 0) { $child_temp[$yk]['nickname'] = "烘焙圈"; $child_temp[$yk]['openuid'] = 0; } else { $yf_user = array(); $yf_user = M('User')->field('openuid, nickname, uprovince, ucity, uavatar, ifrz')->where(array('userid' => $yv['userid']))->find(); $child_temp[$yk]['nickname'] = $yf_user['nickname']; $child_temp[$yk]['openuid'] = $yf_user['openuid']; $child_temp[$yk]['uprovince'] = $yf_user['uprovince']; $child_temp[$yk]['ucity'] = $yf_user['ucity']; $child_temp[$yk]['uavatar'] = $yf_user['uavatar']; $child_temp[$yk]['ifrz'] = $yf_user['ifrz']; } if ($yv['touserid'] != 0) { $child_temp[$yk]['touser'] = M('User')->field('openuid,nickname')->where(array('userid' => $yv['touserid']))->find(); } else { $child_temp[$yk]['touser']['nickname'] = "烘焙圈"; $child_temp[$yk]['touser']['openuid'] = 0; } } $message[$k]['childlist'] = $child_temp; } $message[$k]['tempname'] = hy_substr($v['nickname'], 4, true); //$message[$k]['tempname'] = $v['nickname']; $message[$k]['touser'] = array(); if (!empty($v['touserid'])) { $message[$k]['touser'] = M('User')->field('openuid,nickname')->where(array('userid' => $v['touserid']))->find(); } } unset($where['parent_id']); $this->msgcount = M('UserMessage')->where($where)->count(); $this->msgtype = 1; $this->assign('msglist', $message); $this->assign('page', $page->show()); if (IS_AJAX) { exit($this->fetch('msglist')); } //参照做出的作品 $copylist = $Model->table(array(C('DB_PREFIX') . 'works' => 'W', C('DB_PREFIX') . 'user' => 'U'))->where('W.userid=U.userid and W.status=true and W.type=2 and W.copyid=' . $workid)->field('U.openuid,U.nickname,U.uavatar,W.title,W.image,W.workid,W.create_time,W.title')->order('W.workid DESC')->limit(2)->select(); $this->copylist = $copylist; $this->display(); }
function get_pref($thing, $default = '', $from_db = 0) { global $prefs; if ($from_db) { $name = doSlash($thing); $exists = getCount('txp_prefs', "name='{$name}'"); if ($exists) { $prefs[$thing] = safe_field('val', 'txp_prefs', "name='{$name}'"); } } return isset($prefs[$thing]) ? $prefs[$thing] : $default; }
if ($sno % 2 == 1) { ?> bgcolor="#F5F2F1" <?php } ?> > <td align="center" class="tableText"><?php echo $sno; ?> </td> <td align="center" class="tableText"><?php echo getProduct('ProductName', 'rec_id', getCount("ProductId", "rec_id", $row["CountId"])); ?> </td> <td align="center" class="tableText"><?php echo getCount("Count", "rec_id", $row["CountId"]); ?> </td> <td align="center" class="tableText"><?php echo $row['StockInKgs']; ?> Kg</td> <td align="center" class="tableText"><?php echo $row['StockInBale']; ?> Bale</td> <td align="center" class="tableText"><?php echo $row["Date"]; ?> </td> <td align="center" class="tableText"><?php
function rss() { global $prefs, $txpac; extract($prefs); ob_start(); extract(doSlash(gpsa(array('category', 'section', 'limit', 'area')))); // send a 304 if nothing has changed since the last visit $last = fetch('unix_timestamp(val)', 'txp_prefs', 'name', 'lastmod'); $last = gmdate("D, d M Y H:i:s \\G\\M\\T", $last); header("Last-Modified: {$last}"); $hims = serverset('HTTP_IF_MODIFIED_SINCE'); if ($hims == $last) { header("HTTP/1.1 304 Not Modified"); exit; } $area = gps('area'); $sitename .= $section ? ' - ' . $section : ''; $sitename .= $category ? ' - ' . $category : ''; $out[] = tag(doSpecial($sitename), 'title'); $out[] = tag('http://' . $siteurl . $path_from_root, 'link'); $out[] = tag(doSpecial($site_slogan), 'description'); if (!$area or $area == 'article') { $sfilter = $section ? "and Section = '" . $section . "'" : ''; $cfilter = $category ? "and (Category1='" . $category . "' or Category2='" . $category . "')" : ''; $limit = $limit ? $limit : '5'; $frs = safe_column("name", "txp_section", "in_rss != '1'"); if ($frs) { foreach ($frs as $f) { $query[] = "and Section != '" . $f . "'"; } } $query[] = $sfilter; $query[] = $cfilter; $rs = safe_rows("*", "textpattern", "Status = 4 " . join(' ', $query) . "and Posted < now() order by Posted desc limit {$limit}"); if ($rs) { foreach ($rs as $a) { extract($a); $Body = !$txpac['syndicate_body_or_excerpt'] ? $Body_html : $Excerpt; $Body = !trim($Body) ? $Body_html : $Body; $Body = str_replace('href="/', 'href="http://' . $siteurl . '/', $Body); $Body = htmlspecialchars($Body, ENT_NOQUOTES); $link = $url_mode == 0 ? 'http://' . $siteurl . $path_from_root . 'index.php?id=' . $ID : 'http://' . $siteurl . $path_from_root . $Section . '/' . $ID . '/'; if ($txpac['show_comment_count_in_feed']) { $dc = getCount('txp_discuss', "parentid={$ID} and visible=1"); $count = $dc > 0 ? ' [' . $dc . ']' : ''; } else { $count = ''; } $Title = doSpecial($Title) . $count; $item = tag(strip_tags($Title), 'title') . n . tag($Body, 'description') . n . tag($link, 'link'); $out[] = tag($item, 'item'); } header("Content-Type: text/xml"); return '<rss version="0.92">' . tag(join(n, $out), 'channel') . '</rss>'; } } elseif ($area == 'link') { $cfilter = $category ? "category='{$category}'" : '1'; $limit = $limit ? $limit : 15; $rs = safe_rows("*", "txp_link", "{$cfilter} order by date desc limit {$limit}"); if ($rs) { foreach ($rs as $a) { extract($a); $item = tag(doSpecial($linkname), 'title') . n . tag(doSpecial($description), 'description') . n . tag($url, 'link'); $out[] = tag($item, 'item'); } header("Content-Type: text/xml"); return '<rss version="0.92">' . tag(join(n, $out), 'channel') . '</rss>'; } } return 'no articles recorded yet'; }
<?php include "inc/check_session.php"; include "inc/dbconnection.php"; include "inc/adm_function.php"; $StockId = $_GET["id"]; $i = $_GET["i"]; $CountId = $_GET["CountId"]; $Date = $_GET["Date"]; $CountName = getCount("Count", "rec_id", $CountId); $sql_count = "select * from " . $mysql_adm_table_prefix . "count_master where Count = '{$CountName}' and rec_id != '{$CountId}'"; //echo "<br><br>"; $result_count = mysql_query($sql_count) or die("Error in query:" . $sql_count . "<br>" . mysql_error() . ":" . mysql_errno()); $SwitchCountId = ""; if (mysql_num_rows($result_count) > 0) { $row_count = mysql_fetch_array($result_count); $SwitchCountId = $row_count["rec_id"]; $sql_update = "update " . $mysql_adm_table_prefix . "stock_master set CountId = '{$SwitchCountId}' where rec_id = '{$StockId}'"; mysql_query($sql_update) or die("Error in Query:" . $sql_update . "<br>" . mysql_errno() . ":" . mysql_error()); } $sql_stock = "SELECT * FROM " . $mysql_adm_table_prefix . "stock_master where CountId = '{$CountId}' and Date = '{$Date}' order by Date "; $result_stock = mysql_query($sql_stock) or die("Error in Query:" . $sql_stock . "<br>" . mysql_errno() . ":" . mysql_error()); if (mysql_num_rows($result_stock) > 0) { ?> <table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" class="border"> <tr> <td colspan="7" class="blackHead">Stock Detail</td> </tr> <tr> <td align="center"> <span class="text_1"><b>Lot Number</b></span>
/** * 随拍作品详情 */ public function detail() { $workid = I('get.workid'); if (empty($workid)) { $this->error('您访问的页面不存在'); } //增加点击数 M('Works')->where(array('workid' => $workid))->setInc('clicknum'); $detail = D('Works')->relation(true)->find($workid); if (!$detail) { $this->error('您访问的作品不存在'); } $img_temp = explode("/", $detail['image']); $img_temp[count($img_temp) - 1] = str_replace("yf_", "", $img_temp[count($img_temp) - 1]); $detail['image'] = implode("/", $img_temp); $this->assign('data', $detail); $user = M('User')->where(array('userid' => $detail['userid']))->field("openuid, nickname, uavatar")->find(); //print_r($user); $this->assign("user", $user); $copyinfo = M('Works')->where(array('workid' => $detail['copyid']))->field("title, image, userid")->find(); $mname = M('WorksMaterials')->where(array('workid' => $detail['copyid']))->field("mname")->select(); //print_r($mname); //print_r($copyinfo); $copyinfo['materials'] = array(); if ($mname) { $temp_mater = array(); foreach ($mname as $mk => $mv) { $temp_mater[] = $mv['mname']; } $copyinfo['materials'] = implode("、", $temp_mater); //$copyinfo['materials'] = "高筋粉(金像,焙食尚各一半)、细砂糖、可可粉、盐、干酵母、水(我们"; $copyinfo['materials'] = hy_substr($copyinfo['materials'], 32, true); } $copyinfo['donum'] = M('Works')->where(array('copyid' => $detail['copyid']))->count(); $seven = time() - 7 * 24 * 60 * 60; $copyinfo['nownum'] = M('Works')->where("copyid=%d and create_time > %s", array($detail['copyid'], $seven))->count(); $this->assign("copyinfo", $copyinfo); $copyuser = M('User')->where(array('userid' => $copyinfo['userid']))->field("nickname, openuid")->find(); $this->assign("copyuser", $copyuser); //点赞总数 $this->digallnum = $detail['goodnum'] + $detail['badnum']; //点赞判断 $this->dignum = M('Dig')->where(array('userid' => $this->userid, 'status' => true, 'infoid' => $workid))->count(); //收藏判断 $this->favoritenum = getCount('UserFavorite', array('userid' => $this->userid, 'status' => true, 'infoid' => $workid)); //右侧广告 $this->rightad = parent::getAdvert(8, 3, 0, 2); //点赞人员列表 $diguser = new Model(); $diguerlist = $diguser->table(array(C('DB_PREFIX') . 'dig' => 'D', C('DB_PREFIX') . 'user' => 'U'))->where('D.userid=U.userid and D.status=true and D.digtype=1 and D.infoid=' . $workid . '')->field('U.uavatar,U.openuid')->select(); $this->assign('diglist', $diguerlist); //评论 // $where['infoid']=$workid; // $where['type']=1; // $count = M('UserMessage')->where($where)->count(); // $limitRows = 10; // 设置每页记录数 // $page = $this->ajaxpage($count,$limitRows,'type=msg','ajax_div','ajax_page_div'); // $msgModel=new Model(); // $message=$msgModel // ->table(array( // C('DB_PREFIX').'user_message'=>'M', // C('DB_PREFIX').'user'=>'U', // ) // ) // ->where('M.userid=U.userid and M.status=true and M.infoid='.$workid.' and M.type=1') // ->field('M.create_time,M.content,U.nickname,U.uavatar,U.openuid,U.uprovince,U.ucity,U.userid,M.id,M.touserid') // ->order('M.create_time DESC') // ->limit($page->firstRow . ',' . $page->listRows) // ->select(); // foreach($message as $k=>$v){ // $message[$k]['touser']=M('User')->field('openuid,nickname')->where(array('userid'=>$v['touserid']))->find(); // } $where['infoid'] = $workid; $where['type'] = 1; $where['parent_id'] = 0; $count = M('UserMessage')->where($where)->count(); // $limitRows = 5; // 设置每页记录数 $limitRows = C('YF_PAGE'); $page = $this->ajaxpage($count, $limitRows, '#msg', 'ajax_div', 'ajax_page_div'); $Model = new Model(); $message = $Model->table(array(C('DB_PREFIX') . 'user_message' => 'M', C('DB_PREFIX') . 'user' => 'U'))->where('M.userid=U.userid and M.status=true and M.infoid=' . $workid . ' and M.type=1 and M.parent_id=0')->field('M.create_time,M.content,U.nickname,U.uavatar,U.openuid,U.uprovince,U.ucity,U.userid,M.id,M.touserid,U.ifrz')->order('M.create_time DESC')->limit($page->firstRow . ',' . $page->listRows)->select(); foreach ($message as $k => $v) { $child_temp = array(); $child_temp = $Model->table(C('DB_PREFIX') . 'user_message')->field('*')->where(array('parent_id' => $v['id']))->order('create_time ASC')->select(); $message[$k]['childlist'] = array(); if ($child_temp) { foreach ($child_temp as $yk => $yv) { if ($yv['userid'] == 0) { $child_temp[$yk]['nickname'] = "烘焙圈"; $child_temp[$yk]['openuid'] = 0; } else { $yf_user = array(); $yf_user = M('User')->field('openuid, nickname, uprovince, ucity, uavatar, ifrz')->where(array('userid' => $yv['userid']))->find(); $child_temp[$yk]['nickname'] = $yf_user['nickname']; $child_temp[$yk]['openuid'] = $yf_user['openuid']; $child_temp[$yk]['uprovince'] = $yf_user['uprovince']; $child_temp[$yk]['ucity'] = $yf_user['ucity']; $child_temp[$yk]['uavatar'] = $yf_user['uavatar']; $child_temp[$yk]['ifrz'] = $yf_user['ifrz']; } if ($yv['touserid'] != 0) { $child_temp[$yk]['touser'] = M('User')->field('openuid,nickname')->where(array('userid' => $yv['touserid']))->find(); } else { $child_temp[$yk]['touser']['nickname'] = "烘焙圈"; $child_temp[$yk]['touser']['openuid'] = 0; } } $message[$k]['childlist'] = $child_temp; } $message[$k]['tempname'] = hy_substr($v['nickname'], 4, true); //$message[$k]['tempname'] = $v['nickname']; $message[$k]['touser'] = array(); if (!empty($v['touserid'])) { $message[$k]['touser'] = M('User')->field('openuid,nickname')->where(array('userid' => $v['touserid']))->find(); } } unset($where['parent_id']); $this->msgcount = M('UserMessage')->where($where)->count(); $this->msgtype = 1; // $this->msgcount=$count; $this->assign('msglist', $message); $this->assign('page', $page->show()); if (IS_AJAX) { exit($this->fetch('msglist')); //list为list.html模版 } //获取会员烘焙作品数 $this->hbworksnum = getCount('Works', array('status' => true, 'type' => 1, 'userid' => $detail['userid'])); //获取会员随拍作品数 $this->spworksnum = getCount('Works', array('status' => true, 'type' => 2, 'userid' => $detail['userid'])); //是否关注 $this->isfans = getCount('UserFans', array('myid' => $this->userid, 'userid' => $detail['userid'], 'status' => true)); //更多随拍作品 $map['status'] = array('EQ', true); $map['userid'] = array('EQ', $detail['userid']); $map['workid'] = array('NEQ', $workid); $this->moresp = M('Works')->field('image,workid,type,title')->where($map)->limit(9)->select(); $this->display(); }