获取项目列表(带模块)
$condition = "module>0"; $project_list = $this->model('project')->get_all_project($this->session->val('admin_site_id'),$condition); $this->assign('project_list',$project_list);
插件列表项目显示
<div class="table"> <div class="title">项目:<span class="note">请指定项目</span></div> <div class="content"> <select id="pid" name="pid"> <option value="">请选择…</option> <!-- loop from=$project_list key=$key value=$value id=$tmpid --> <option value="{$value.id}" {if $rs.param && $rs.param.pid==$value.id} selected{/if}>{$value.space}{$value.title}</option> <!-- /loop --> </select> </div> </div>
获取支付方案列表
$condition = "p.status=1"; $paylist = $this->model('payment')->get_all('p.status=1','id'); $this->assign('paylist',$paylist);
获取网关路由
$glist = $this->model('gateway')->get_all(0); $this->assign('gateway_sms_list',$glist['sms']['list']);//短信网关列表 $this->assign('gateway_email_list',$glist['email']['list']);//邮件网关列表
通过网关发送邮件
$this->gateway('type','email'); $this->gateway('param','网关ID'); //使用default自动调用默认网关,不使用默认,请填写网关ID,数字 //基于通知模板ID来获取相应的模板信息 $tpl = $this->model('email')->get_one('通知模板ID'); //基于标识来获取模板信息,两者选其一就可以了 $tpl = $this->model('email')->get_tpl('通知模板标识'); //邮件标题,支持变量 $title = $this->fetch($tpl['title'],'msg'); //邮件内容,支持变量(注意,不支持相对路径,要写全部网址,不然收到的邮件可能看到不图片) $content = $this->fetch($tpl['content'],'msg'); $array = array('email'=>'目标邮箱','fullname'=>'称呼','title'=>$title,'content'=>$content); $this->gateway('exec',$array);
通过网关发送短信
$this->gateway('type','sms'); $this->gateway('param','网关ID'); //使用default自动调用默认网关,不使用默认,请填写网关ID,数字 //基于通知模板ID来获取相应的模板信息 $tpl = $this->model('email')->get_one('通知模板ID'); //基于标识来获取模板信息,两者选其一就可以了 $tpl = $this->model('email')->get_tpl('通知模板标识'); //短信标题,无效,不发送 $title = $this->fetch($tpl['title'],'msg'); //短信内容,支持变量。 $content = $this->fetch($tpl['content'],'msg'); $array = array('mobile'=>'手机号','identifier'=>$tpl['identifier'],'title'=>$title,'content'=>$content); $this->gateway('exec',$array);
常用分页代码
$string = "home=首页&prev=上一页&next=下一页&last=尾页&half=5&add=(total)/(psize)&always=1"; $pagelist = phpok_page($pageurl,$total,$pageid,$psize,$string); $this->assign('pagelist',$pagelist); $this->assign('pageurl',$pageurl); $this->assign('total',$total); $this->assign('pageid',$pageid); $this->assign('psize',$psize); $this->assign('offset',$offset);
手动加减积分
$this->model('wealth')->save_val($wid,$uid,$val,$note)
其中:
$wid,表示财富ID,是数值
$uid,表示会员ID,是数值
$val,要增加或扣除的积分,扣除前写加 - 号,例如加10分,就写 10,扣10分,就写 -10
$note,备注
获取短信模板,邮件模板
$elist = $this->model('email')->simple_list($this->session->val('admin_site_id')); if($elist){ $smslist = $emailist = array(); foreach($elist as $key=>$value){ $tmp = strtolower($value['identifier']); if(strpos($tmp,'sms_') !== false){ $smslist[] = $value; }else{ $emailist[] = $value; } } $this->assign('smslist',$smslist); $this->assign('emailist',$emailist); }
<!-- if $smslist --> <div class="table"> <div class="title"> 短信模板:<span class="note">设置通知会员的短信模板</span> </div> <div class="content"> <select name="tpl_sms" id="tpl_sms"> <option value="">请选择…</option> <!-- loop from=$smslist key=$key value=$value id=$tmpid --> <option value="{$value.id}"{if $rs.param && $rs.param.tpl_sms == $value.id} selected{/if}>{$value.title}<!-- if $value.note -->_{$value.note}<!-- /if --></option> <!-- /loop --> </select> </div> </div> <!-- /if --> <!-- if $emailist --> <div class="table"> <div class="title"> 邮件模板:<span class="note">设置通知会员的邮件模板</span> </div> <div class="content"> <select name="tpl_email" id="tpl_email"> <option value="">请选择…</option> <!-- loop from=$emailist key=$key value=$value id=$tmpid --> <option value="{$value.id}"{if $rs.param && $rs.param.tpl_email == $value.id} selected{/if}>{$value.title}<!-- if $value.note -->_{$value.note}<!-- /if --></option> <!-- /loop --> </select> </div> </div> <!-- /if -->
会员组列表
$group_list = $this->model('usergroup')->get_all(); $this->assign("group_list",$group_list);
生成列表
$pageid = $this->get($this->config['pageid'],'int'); if(!$pageid){ $pageid = 1; } $psize = $this->config['psize'] ? $this->config['psize'] : 30; $offset = ($pageid-1) * $psize; $condition = "1=1"; $keywords = $this->get('keywords'); $pageurl = $this->url('plugin','exec','_phpokid=[插件标识]&exec=elist'); if($keywords){ $condition .= " AND goods_title LIKE '%".$keywords."%'"; $pageurl .= "&keywords=".rawurlencode($keywords); $this->assign('keywords',$keywords); } //查询数量 $sql = "SELECT count(id) FROM ".$this->db->prefix."plugins_[表名] WHERE ".$condition; $total = $this->db->count($sql); if($total>0){ //读取列表数据 $sql = "SELECT * FROM ".$this->db->prefix."plugins_[表名] WHERE ".$condition." ORDER BY id DESC LIMIT ".$offset.",".$psize; $rslist = $this->db->get_all($sql); $string = P_Lang("home=首页&prev=上一页&next=下一页&last=尾页&half=5&add=数量:(total)/(psize),页码:(num)/(total_page)&always=1"); $pagelist = phpok_page($pageurl,$total,$pageid,$psize,$string); $this->assign('total',$total); $this->assign('pageid',$pageid); $this->assign('psize',$psize); $this->assign('pageurl',$pageurl); $this->assign("pagelist",$pagelist); $this->assign("rslist",$rslist); } $this->_view('[模板名称]');
涉及到导入SQL文件
if(file_exists($this->me['path'].'install.sql')){ phpok_loadsql($this->db,$this->me['path'].'install.sql',true); }
函数:phpok_loadsql
参数1:$this->db,连接数据库的类
参数2:SQL文件或是SQL语句
参数3:当为SQL文件时设置为true,为false或不设置,表示参数2是SQL语句