PHP Import::basic方法代码示例

 function shoppingsn($data = array())
 {
     $rt = $this->App->find("SELECT * FROM `{$this->App->prefix()}shipping_name`");
     $this->set('rt', $rt);
     //分页
     $page = isset($_GET['page']) ? $_GET['page'] : 1;
     if (empty($page)) {
         $page = 1;
     }
     $list = 20;
     $start = ($page - 1) * $list;
     $comd = array();
     $w = "";
     if (isset($_GET['sid']) && $_GET['sid'] > 0) {
         $comd[] = "tb1.shipping_id = '" . intval($_GET['sid']) . "'";
     }
     if (isset($_GET['keyword']) && !empty($_GET['keyword'])) {
         $comd[] = "tb1.shipping_sn LIKE '%" . trim($_GET['keyword']) . "%'";
     }
     if (!empty($comd)) {
         $w = "WHERE " . implode(' AND ', $comd);
     }
     $sql = "SELECT COUNT(tb1.id) FROM `{$this->App->prefix()}shipping_sn` AS tb1 LEFT JOIN `{$this->App->prefix()}shipping_name` AS tb2 ON tb1.shipping_id = tb2.shipping_id {$w}";
     $tt = $this->App->findvar($sql);
     $rts['pages'] = Import::basic()->getpage($tt, $list, $page, '?page=', true);
     $sql = "SELECT tb1.*,tb2.shipping_name FROM `{$this->App->prefix()}shipping_sn` AS tb1 LEFT JOIN `{$this->App->prefix()}shipping_name` AS tb2 ON tb1.shipping_id = tb2.shipping_id {$w} ORDER BY tb1.id DESC LIMIT {$start},{$list}";
     $rts['lists'] = $this->App->find($sql);
     $this->set('rts', $rts);
     $this->template('shoppingsn');
 }

 function connect($params = array())
 {
     if (!isset($this->status)) {
         $obj = new Ecshop_smtp($params);
         if ($obj->connect()) {
             $obj->status = SMTP_STATUS_CONNECTED;
         }
         return $obj;
     } else {
         if (!empty($GLOBALS['LANG']['smtp_ssl'])) {
             $this->host = "ssl://" . $this->host;
         }
         $this->connection = @fsockopen($this->host, $this->port, $errno, $errstr, $this->timeout);
         if ($this->connection === false) {
             $this->errors[] = 'Access is denied.';
             return false;
         }
         @socket_set_timeout($this->connection, 0, 250000);
         $greeting = $this->get_data();
         if (is_resource($this->connection)) {
             $this->status = 2;
             return $this->auth ? $this->ehlo() : $this->helo();
         } else {
             Import::basic()->log_write($errstr, __FILE__, __LINE__);
             //记录错误信息
             $this->errors[] = 'Failed to connect to server: ' . $errstr;
             return false;
         }
     }
 }

 function ajax_select_goods($maxattr = 0, $page = 1)
 {
     $cid = isset($_COOKIE['GZ_cid']) ? $_COOKIE['GZ_cid'] : 0;
     $subcid = array();
     if ($cid > 0) {
         $subcid = $this->action('catalog', 'get_goods_sub_cat_ids', $cid);
     }
     //分类
     ///
     isset($_COOKIE['GZ_bid']) && intval($_COOKIE['GZ_bid']) > 0 ? $comd[] = "b.brand_id = '" . intval($_COOKIE['GZ_bid']) . "'" : 0;
     //品牌
     if ($maxattr > 0) {
         for ($i = 0; $i < $maxattr; $i++) {
             isset($_COOKIE['GZ_' . $i]) && !empty($_COOKIE['GZ_' . $i]) ? $comd[] = "ga.attr_value = '" . $_COOKIE['GZ_' . $i] . "'" : 0;
             //属性
         }
     }
     if (!empty($subcid)) {
         $comd[] = "gc.cat_id " . db_create_in($subcid);
     }
     $w = !empty($comd) ? " WHERE " . implode(' AND ', $comd) : "";
     $tt = $this->__get_user_goods_select_count($w);
     $rt['count'] = $tt;
     $list = 12;
     $rt['goodslist'] = $this->__get_user_goods_select($w, $page, $list);
     $rt['goodspage'] = Import::basic()->ajax_page($tt, $list, $page, 'get_select_goods_page');
     $this->set('rt', $rt);
     $con = $this->fetch('ajax_user_goods_select', true);
     die($con);
 }

 function index($page = 1)
 {
     $rt = $this->Cache->read(3600);
     if (is_null($rt)) {
         if (!isset($_GET['type'])) {
             //推荐商品
             $rt['tuijian'] = $this->tuijian_goods(10);
             //热卖前10个商品
             $rt['top10'] = $this->action('catalog', 'top10', 0, 5);
             //全站banner
             $rt['quanzhan'] = $this->action('banner', 'quanzhan');
             //热门评论商品
             $sql = "SELECT g.goods_id,g.goods_name,g.market_price,g.shop_price,g.promote_price,g.goods_thumb,g.promote_start_date, g.promote_end_date,g.is_promote,g.sale_count,COUNT(c.comment_id) AS comment_count FROM `{$this->App->prefix()}goods` AS g LEFT JOIN `{$this->App->prefix()}comment` AS c ON g.goods_id=c.id_value WHERE c.status = '1' AND (g.goods_id IS NOT NULL AND g.goods_id!='') GROUP BY c.id_value ORDER BY comment_count DESC LIMIT 4";
             $hotcommentgoods = $this->App->find($sql);
             $rt['hotcommentgoods'] = array();
             if (!empty($hotcommentgoods)) {
                 foreach ($hotcommentgoods as $k => $row) {
                     $rt['hotcommentgoods'][$k] = $row;
                     $rt['hotcommentgoods'][$k]['goods_thumb'] = SITE_URL . $row['goods_thumb'];
                     $rt['hotcommentgoods'][$k]['goods_img'] = SITE_URL . $row['goods_img'];
                     $rt['hotcommentgoods'][$k]['url'] = get_url($row['goods_name'], $row['goods_id'], SITE_URL . 'product.php?id=' . $row['goods_id'], 'goods', array('product', 'index', $row['goods_id']));
                     if ($row['is_promote'] == '1') {
                         //促销 价格
                         if ($row['promote_start_date'] < mktime() && $row['promote_end_date'] > mktime()) {
                             $row['promote_price'] = format_price($row['promote_price']);
                         } else {
                             $row['promote_price'] = "0.00";
                         }
                     } else {
                         $row['promote_price'] = "0.00";
                     }
                     $rt['hotcommentgoods'][$k]['promote_price'] = $row['promote_price'];
                 }
                 unset($hotcommentgoods);
             }
         }
         $list = 15;
         $page = !$page ? 1 : $page;
         $start = ($page - 1) * $list;
         $tt = $this->action('product', 'get_comment_count');
         $rt['pagelink'] = Import::basic()->gethtmlpage($tt, $list, $page, SITE_URL . 'comment/p%d/');
         $rt['commentlist'] = $this->action('product', 'get_comment_list', 0, $start, $list);
         $this->Cache->write($rt);
     }
     $this->set('rt', $rt);
     if (isset($_GET['type']) && $_GET['type'] == 'ajax') {
         echo $this->fetch('ajax_jifen_goods', true);
         exit;
     }
     //设置页面meta
     $title = '评论中心-用户评论';
     $this->title($title . ' - ' . $GLOBALS['LANG']['site_name']);
     $this->meta("title", $title);
     $this->meta("keywords", $title);
     $this->meta("description", $title);
     $this->template('comment_index');
 }

 function find_password($rt = array())
 {
     $datanew['name'] = '亲爱的' . $rt['user_name'];
     $datanew['email'] = $rt['email'];
     $datanew['subject'] = '密码找回，请查收！';
     $this->set('rt', $rt);
     $datanew['content'] = $this->fetch('email_tpl/find_password', true);
     $datanew['type'] = 1;
     $datanew['notification'] = false;
     Import::basic()->ecshop_sendemail($datanew);
     unset($datanew);
 }

 function add_edit($type = 'add', $id = 0)
 {
     $rt = array();
     if ($type == 'edit') {
         if (empty($id) || !Import::basic()->int_preg($id)) {
             $this->jump('friendlink.php?type=list');
             exit;
         }
         $sql = "SELECT * FROM `{$this->App->prefix()}friend_link` WHERE link_id='{$id}'";
         $rt = $this->App->findrow($sql);
     }
     $this->set('rt', $rt);
     $this->set('type', $type);
     $this->template('friendlink_edit');
 }

 function index()
 {
     //分页
     $page = isset($_GET['page']) ? $_GET['page'] : '';
     if (empty($page)) {
         $page = 1;
     }
     $list = 10;
     $start = ($page - 1) * $list;
     $sql = "SELECT COUNT(group_id) FROM `{$this->App->prefix()}goods_groupbuy`";
     $tt = $this->App->findvar($sql);
     $pagelink = Import::basic()->getpage($tt, $list, $page, '?page=', true);
     $this->set("pagelink", $pagelink);
     $sql = "SELECT tb1.*,tb2.goods_name,tb2.is_delete,tb2.is_on_sale FROM `{$this->App->prefix()}goods_groupbuy` AS tb1 LEFT JOIN `{$this->App->prefix()}goods` AS tb2 ON tb1.goods_id=tb2.goods_id ORDER BY tb1.group_id DESC LIMIT {$start},{$list}";
     $this->set('rt', $this->App->find($sql));
     $this->template('groupbuy_index');
 }

    if (empty($value)) {
        return $value;
    } else {
        return is_array($value) ? array_map('addslashes_deep', $value) : addslashes($value);
    }
}
/* 对用户传入的变量进行转义操作。*/
if (!get_magic_quotes_gpc()) {
    if (!empty($_GET)) {
        $_GET = addslashes_deep($_GET);
    }
    if (!empty($_POST)) {
        $_POST = addslashes_deep($_POST);
    }
    $_COOKIE = addslashes_deep($_COOKIE);
    $_REQUEST = addslashes_deep($_REQUEST);
}
/*if(in_array($_SERVER['HTTP_HOST'],array('127.0.0.1','127.0.0.1:8080','localhost','localhost:8080','192.168.1.189:8080'))){
    define('SITE_URL', 'http://'.$_SERVER['HTTP_HOST'].'/chaoshi/');
}else{
    define('SITE_URL', Import::basic()->siteurl());
} 
define('SITE_JS', SITE_URL.'js/');

$re = Import::route(); //入口
*/
define('SITE_URL', Import::basic()->siteurl());
//标识：相对网站根目录链接
define('ROOT_URL', SITE_URL);
//标识：运行根目录链接
$re = Import::route();

 function ajax_user_mymoney()
 {
     $page = isset($_POST['page']) && intval($_POST['page']) > 0 ? intval($_POST['page']) : 1;
     if (empty($page)) {
         $page = 1;
     }
     $uid = $_POST['uid'];
     $list = 5;
     //每页显示多少个
     $start = ($page - 1) * $list;
     $tt = $this->App->findvar("SELECT COUNT(cid) FROM `{$this->App->prefix()}user_money_change` WHERE uid='{$uid}'");
     $rt['usermoneypage'] = Import::basic()->ajax_page($tt, $list, $page, 'get_usermoney_page_list', array($uid));
     $sql = "SELECT * FROM `{$this->App->prefix()}user_money_change` WHERE uid='{$uid}' ORDER BY time DESC LIMIT {$start},{$list}";
     $rt['usermoneylist'] = $this->App->find($sql);
     $this->set('rt', $rt);
     echo $this->fetch('ajax_user_money', true);
     exit;
 }

				<div class="gehang">&nbsp;</div>
					  <div class="li_list" style="min-height:200px;">
						  <h4>相关文章</h4>
						  <ul>
						  <?php 
if (!empty($rt['rand_list']) && is_array($rt['rand_list'])) {
    foreach ($rt['rand_list'] as $row) {
        ?>
							  <li><a href="<?php 
        echo $row['url'];
        ?>
" title="<?php 
        echo $row['article_title'];
        ?>
"><?php 
        echo Import::basic()->wordcut($row['article_title'], 40);
        ?>
</a></li>
						  <?php 
    }
}
?>
						  </ul>
					  </div>
					  
					  <div class="gehang">&nbsp;</div>
					  <div class="li_list_goods li_list">
						  <h4>推荐商品</h4>
						  <?php 
if (!empty($rt['tuijian'])) {
    foreach ($rt['tuijian'] as $row) {

 function __category_goods_where($data = array())
 {
     if (empty($data)) {
         return "";
     }
     $cid = isset($data['cid']) && intval($data['cid']) > 0 ? intval($data['cid']) : 0;
     $bid = isset($data['bid']) && intval($data['bid']) > 0 ? intval($data['bid']) : 0;
     $price = isset($data['price']) ? $data['price'] : "";
     $keyword = isset($data['keyword']) ? $data['keyword'] : "";
     $comd[] = "g.is_on_sale = '1' AND g.is_delete = '0' AND g.is_alone_sale='1'";
     $bid > 0 ? $comd[] = "b.brand_id='{$bid}'" : "";
     //品牌
     if (!empty($price)) {
         //价格
         $p_ar = @explode('-', $price);
         if (count($p_ar) == 2) {
             if (empty($p_ar[1])) {
                 $p_ar[1] = 10000;
             }
             sort($p_ar);
             $price1 = intval(trim($p_ar[0]));
             $price2 = intval(trim($p_ar[1]));
             if ($price1 >= 0 && $price2 > 0) {
                 $comd[] = "(g.pifa_price between {$price1} and {$price2})";
             }
         }
     }
     $subsql = "";
     if ($cid > 0) {
         //子分类
         $sub_cid = $this->get_goods_sub_cat_ids_model($cid);
         //子分类id
         $comd[] = "(g.cat_id" . db_create_in($sub_cid) . " OR csg.cat_id='{$cid}')";
     }
     if (!empty($keyword)) {
         $act = array('is_best', 'is_new', 'is_hot', 'is_promote', 'is_qianggou');
         if (in_array($keyword, $act)) {
             switch ($keyword) {
                 case 'is_best':
                     $comd[] = "g.is_best='1'";
                     break;
                 case 'is_new':
                     $comd[] = "g.is_new='1'";
                     break;
                 case 'is_hot':
                     $comd[] = "g.is_hot='1'";
                     break;
                 case 'is_promote':
                     $time = mktime();
                     //	$comd[] = "AND g.is_promote = '1' AND g.promote_start_date <= '$time' AND g.promote_end_date >= '$time'";   look注释
                     $comd[] = "g.is_promote = '1' AND g.promote_start_date <= '{$time}' AND g.promote_end_date >= '{$time}'";
                     // look添加
                     break;
                 case 'is_qianggou':
                     $time = mktime();
                     //	$comd[] = "AND g.is_qianggou = '1' AND g.qianggou_start_date <= '$time' AND g.qianggou_end_date >= '$time'";
                     $comd[] = "g.is_qianggou = '1' AND g.qianggou_start_date <= '{$time}' AND g.qianggou_end_date >= '{$time}'";
                     break;
             }
         } else {
             $comd[] = "(gc.cat_name LIKE '%{$keyword}%' OR g.goods_name LIKE '%{$keyword}%' OR g.goods_bianhao LIKE '%{$keyword}%')";
             if (!isset($data['count_where'])) {
                 //如果是通过搜索进来的，那么将关键字添加到数据库表中
                 $keyid = $this->findvar("SELECT key_id FROM `{$this->prefix()}stats_keywords` WHERE keyword='{$keyword}' LIMIT 1");
                 if (empty($keyid)) {
                     //插入
                     $dd = array();
                     $n = Import::basic()->Pinyin($keyword);
                     $dd['tag_n'] = !empty($n) ? ucwords(substr($n, 0, 1)) : "NAL";
                     $dd['keyword'] = $keyword;
                     $dd['date'] = date('Y-m-d', mktime());
                     $dd['count'] = 1;
                     $this->insert('stats_keywords', $dd);
                     unset($dd);
                 } else {
                     //数量增加1
                     $sd = "UPDATE `{$this->prefix()}stats_keywords` SET `date` = '" . date('Y-m-d', mktime()) . "',`count`=`count`+1 WHERE `key_id` = '{$keyid}' LIMIT 1";
                     $this->query($sd);
                 }
             }
         }
     }
     $w = "";
     if (!empty($comd)) {
         $w = "WHERE " . implode(' AND ', $comd);
     }
     return $w;
 }

 function ajax_getcategoodslist($w = array())
 {
     $err = 0;
     $json = Import::json();
     $result = array('error' => $err, 'message' => '');
     if (empty($w)) {
         $result['error'] = 2;
         $result['message'] = '传送的数据为空！';
         die($json->encode($result));
     }
     $wobj = $json->decode($w);
     //反json ,返回值为对象
     $page = $wobj->page;
     if (!$page) {
         $page = 1;
     }
     $cid = $wobj->cid;
     if (!$cid) {
         $cid = 0;
     }
     $bid = $wobj->bid;
     if (!$bid) {
         $bid = 0;
     }
     $price = $wobj->price;
     if (!$price) {
         $price = "";
     }
     $order_type = $wobj->order;
     if (!$order_type) {
         $order_type = "goods_id";
     }
     $keyword = $wobj->keyword;
     if (!$keyword) {
         $keyword = "";
     }
     $sort_type = $wobj->sorts;
     if (empty($sort_type)) {
         $sort_type = "DESC";
     }
     $list = $wobj->limit;
     if (!$list) {
         $list = 40;
     }
     if (!empty($keyword) && !(preg_match('/^.*$/u', $keyword) > 0)) {
         $keyword = Import::gz_iconv()->ec_iconv('GB2312', 'UTF8', $keyword);
         //编码转换
     }
     $rt['thiscid'] = $cid;
     $rt['thisbid'] = $bid;
     $rt['price'] = $price;
     $rt['page'] = $page;
     $rt['sort'] = $sort_type;
     $rt['order'] = $order_type;
     $rt['limit'] = $list;
     //当前分类的基本信息
     if ($cid > 0) {
         $sql = "SELECT * FROM `{$this->App->prefix()}goods_cate` WHERE cat_id='{$cid}' LIMIT 1";
         $rt['cateinfo'] = $this->App->findrow($sql);
     } else {
         $rt['cateinfo'] = array();
         //查找时没有cid
     }
     //品牌信息
     if ($bid > 0) {
         $sql = "SELECT brand_name FROM `{$this->App->prefix()}brand` WHERE brand_id='{$bid}' LIMIT 1";
         $rt['brandinfo']['brand_name'] = $this->App->findvar($sql);
     } else {
         $rt['brandinfo']['brand_name'] = "";
     }
     //显示方式
     if (!isset($_COOKIE['DISPLAY_TYPE']) || empty($_COOKIE['DISPLAY_TYPE']) || !in_array($_COOKIE['DISPLAY_TYPE'], array('list', 'text'))) {
         $rt['display'] = 'text';
     } else {
         $rt['display'] = $_COOKIE['DISPLAY_TYPE'];
     }
     //start 当前位置
     $rt['hear'] = array();
     $perend_id = 0;
     $hear[] = '<a href="' . SITE_URL . '">首页</a>';
     $hear[] = '<a href="' . get_url('商品中心', 0, SITE_URL . "costume.php", 'goodscate', array('catalog', 'index')) . '">商品中心</a>';
     if ($cid > 0) {
         $rts_ = $this->get_goods_parent_cats($cid);
         //父类ID
         $rts = Import::basic()->array_sort($rts_, 'cat_id');
         //根据cat_id排序
         if (!empty($rts)) {
             $perend_id = $rts[count($rts) - 1]['cat_id'];
             foreach ($rts as $rows) {
                 $hear[] = '<a href="' . get_url($rows['cat_name'], $rows['cat_id'], "costume.php?cid=" . $rows["cat_id"], 'goodscate', array('catalog', 'index', $row['cat_id'])) . '">' . $rows['cat_name'] . '</a>';
             }
         }
         unset($rts, $rts_);
     } elseif ($bid > 0) {
         //品牌
         $hear[] = '<a href="' . SITEURL . 'brand/">品牌中心</a>';
         $hear[] = '<a href="' . get_url($rt['brandinfo']['brand_name'], $rt['brandinfo']['brand_id'], "costume.php?bid=" . $rt['brandinfo']['brand_id'], 'brand') . '">' . $rt['brandinfo']['brand_name'] . '</a>';
     } elseif (!empty($keyword)) {
         $perend_id = -1;
         switch ($keyword) {
//.........这里部分代码省略.........

 function ajax_del_comment($ids = 0)
 {
     if (empty($ids)) {
         die("非法删除，删除ID为空！");
     }
     $id_arr = @explode('+', $ids);
     foreach ($id_arr as $id) {
         if (Import::basic()->int_preg($id)) {
             $this->App->delete('comment', 'comment_id', $id);
         }
     }
     $this->action('system', 'add_admin_log', '删除商品评论：' . $ids);
 }

 function seo_category_content($data = array(), $type = 'new')
 {
     extract($data);
     switch ($type) {
         case 'new':
             $na = "新闻咨询";
             break;
         case 'customer':
             $na = "客户列表";
             break;
         case 'case':
             $na = "模版案例";
             break;
         case 'web':
             $na = "网站建设";
             break;
     }
     if (!empty($article_id)) {
         if (count($article_id) == count($article_title) && count($meta_keys) == count($meta_desc) && count($meta_desc) == count($article_id)) {
             foreach ($article_id as $k => $cid) {
                 if ($cid <= 0) {
                     continue;
                 }
                 if (isset($sdata)) {
                     unset($sdata);
                 }
                 $sdata = array('article_title' => $article_title[$k], 'meta_keys' => $meta_keys[$k], 'meta_desc' => $meta_desc[$k]);
                 $this->App->update('article', $sdata, 'article_id', $cid);
             }
             $this->action('system', 'add_admin_log', '批量修改' . $na . '内容SEO优化:');
             $this->action('common', 'showdiv', $this->getthisurl());
         }
     }
     unset($data);
     //分页
     $page = isset($_GET['page']) ? $_GET['page'] : '';
     if (empty($page)) {
         $page = 1;
     }
     $list = 10;
     $start = ($page - 1) * $list;
     $sql = "SELECT COUNT(tb1.article_id) FROM `{$this->App->prefix()}article` AS tb1";
     $sql .= " LEFT JOIN `{$this->App->prefix()}article_cate` AS tb2";
     $sql .= " ON tb1.cat_id = tb2.cat_id";
     $sql .= " WHERE tb2.type='{$type}'";
     $tt = $this->App->findvar($sql);
     $pagelink = Import::basic()->getpage($tt, $list, $page, '?page=', true);
     $this->set("pagelink", $pagelink);
     $sql = "SELECT tb1.article_title,tb1.article_id,tb1.meta_keys,tb1.meta_desc,tb2.cat_name FROM `{$this->App->prefix()}article` AS tb1";
     $sql .= " LEFT JOIN `{$this->App->prefix()}article_cate` AS tb2";
     $sql .= " ON tb1.cat_id = tb2.cat_id";
     $sql .= " WHERE tb2.type='{$type}' ORDER BY tb1.article_id DESC LIMIT {$start},{$list}";
     $this->set('articlelist', $this->App->find($sql));
     $this->template('seo_category_content');
 }

			<p style="padding-top:5px; padding-left:10px; font-size:14px;">配送方式：<b>快递免邮</b></p>

			</td>
		</tr>
		</table>
		<div>
			<a href="#" class="btn-buy button ui-btn ui-btn-text-only dddddd"><span class="ui-btn-text">查看订单</span></a>
		</div>
	</div>
</div>
<div class="show_zhuan" style=" display:none;width:100%; height:100%; position:absolute; top:0px; right:0px; z-index:9999999;filter:alpha(opacity=90);-moz-opacity:0.9;opacity:0.9; background:url(<?php 
echo $this->img('gz/121.png');
?>
) right top no-repeat #000;background-size:100% auto;" onclick="$(this).hide();"></div>	
<?php 
$thisurl = Import::basic()->thisurl();
$rr = explode('?', $thisurl);
$t2 = isset($rr[1]) && !empty($rr[1]) ? $rr[1] : "";
$dd = array();
if (!empty($t2)) {
    $rr2 = explode('&', $t2);
    if (!empty($rr2)) {
        foreach ($rr2 as $v) {
            $rr2 = explode('=', $v);
            if ($rr2[0] == 'from' || $rr2[0] == 'isappinstalled' || $rr2[0] == 'code' || $rr2[0] == 'state') {
                continue;
            }
            $dd[] = $v;
        }
    }
}