获取项目列表（带模块）
$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语句