tp6常用笔记整理

// 	解析textarea
<div style="white-space: pre-line"> {$setting.jc|raw}</div>
//返回role_id列对各用,隔开
$admin_role = Db::name('admin_role')->order('id', 'desc')->where('admin_id', $admin_id)->column('role_id');
$admin_role = Db::name('admin_role')->order('id', 'desc')->where('admin_id', $admin_id)->field('id,title,content,role_id')->select();
//或者条件查询
$list=$OrderModel->where(function ($query) use ($where) {
    $query->where('uid_user',$where['uid_user'])->where('status',$where['status']);
   })->whereOr(function ($query) use ($where) {
       $query->where('uid',$where['uid'])->where('sta',$where['sta']);
   })->order('id','desc')->select();
//计算数组里面某个值的和
array_sum(array_column($HouseholdModel_list,'house_area'));
//插入多条数据,分每次100
Db::name('user')->limit(100)->insertAll($data); 
dump(bcmul(10,0.2,2));//乘
dump(bcdiv(10,2,2));//除
dump(bcadd(10,2,2));//加
dump(bcsub(10,2,2));//减
//两个集合的差集 ， 做删除和添加。
$add = array_diff($departments_id, $permission_list); //待添加
$del = array_diff($permission_list, $departments_id); //待删除
//数组转json
json_encode()
//数组合并
$ids=array_merge($ids,$uids);
//插入数据返回id
Db::name('user')->insertGetId($data);
//多表联查
//模型一对多查询
public function UserModel(){
     return $this->hasMany('UserModel' , 'id','uid');
  }
  //查询
  $OrderModel=new OrderModel;
  $datas=$OrderModel->withJoin(['UserModel'])->where($where)->order($order)->select();
  
//一对多 把多个数据合并成一个字符串 GROUP_CONCAT() 
//查询1,2,3 ->where('FIND_IN_SET(:id,fid)',['id' => $id]])
//$where[]=['','EXP',Db::raw("FIND_IN_SET(".input('expertise').",expertise)")];

$text=Db::name('text')->alias('t')->join('text_con tc','t.id=tc.tid')->join('user u','t.uid=u.id')
		->field('t.*,u.nickname,u.headimgurl,GROUP_CONCAT(tc.h) as tc_h')->where([
			['t.id','=',input('id')]
		])->find();
//----------------------------------------------查询经纬度亮点之间的距离

$lat='35.054637';
        $lgt='110.986184';
        if(isset($this->getlat['lat'])){
            $lat=$this->getlat['lat']; //经度
        }
        if(isset($this->getlat['lgt'])){
            $lgt=$this->getlat['lgt']; //经度
        }
        $EARTH=6378.137; //固定参数 地球半径
        $PI=3.1415926535898; //固定参数 圆周率
        
        $goods=$GoodsModel->where($w)->alias('g')
        ->join('user u','u.id= g.uid')->with(['GoodsMealModel','User'])
        ->field("g.id,g.uid,u.lat,u.lgt,(2 * $EARTH* ASIN(SQRT(POW(SIN($PI*(".$lat."-u.lat)/360),2)+COS($PI*".$lat."/180)* COS(u.lat * $PI/180)*POW(SIN($PI*(".$lgt."-u.lgt)/360),2)))) as juli")
        ->order($order)->select();
//-----------------------------------------------------------------------
//查询1,2,3,数据
->where('FIND_IN_SET(:id,fid)',['id' => $id]])
//60秒缓存
Db::name('user')->cache(true,60)->find();
$this->view->assign(array('info'=>$info));
return $this->view->fetch();
//数组k从0开始
$item = array_merge($item);
//url加码
urldecode
//url解码
urldecode
//判断是否是post提交
if(request()->isPost()){}
//事务回滚
Db::startTrans();
try{
$creBool = Db::name('order')->insert($data);
if(!$creBool){
throw new \Exception('订单创建失败');
}
// 提交事务
Db::commit();
} catch (\Exception $e) {
// 回滚事务
Db::rollback();
}

//js跳转
window.location.href="";
//js提交数据
layer.load();
   $.post("{:url('statement/edit')}",data.field,function(res){
   layer.closeAll();
		if(res.code=='200'){
			layer.alert("操作成功", {icon: 6},function () {
                // 获得frame索引
                var index = parent.layer.getFrameIndex(window.name);
                //关闭当前frame
                parent.layer.close(index);
                parent.location.reload()
            });
        }else{
			layer.msg(res.msg, {time: 2000});
		}
	},'json');

//模板输出
{$client->elapsed_time|default=""}
//模板判断
 {if isset($or.uid)}
            {if $or.ff}
            <span style="color: blue;"> {$or.f['order']}</span>
            {else/}
            <a href="javascript:;" onclick="or({$goods.id},{$or.id})"><span class="button-normal amazon ">Ordered, please submit an order</span></a>
            {/if}
            {else/}
            <a href="javascript:;" onclick="ors({$goods.id},{$review.id})"><span class="button-normal amazon ">CLAIM IT NOW!</span></a>
            {/if}
{{# if (d.status=== 1) { }}  
 <a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>
 {{# } else { }}  
 <a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>
 {{# } }}  
 //layui监听select选中
 <select name="cid" lay-verify="required" lay-search="" lay-filter="demo">
   <option value="1">所有人</option>
    <option value="2">部分人</option>
    <option value="3">单独</option>
  </select>
   form.on('select(demo)', function(data){
        console.log(data.value);
         
      });