486 lines
17 KiB
PHP
486 lines
17 KiB
PHP
<?php
|
||
// +----------------------------------------------------------------------
|
||
// | likeshop100%开源免费商用商城系统
|
||
// +----------------------------------------------------------------------
|
||
// | 欢迎阅读学习系统程序代码，建议反馈是我们前进的动力
|
||
// | 开源版本可自由商用，可去除界面版权logo
|
||
// | 商业版本务必购买商业授权，以免引起法律纠纷
|
||
// | 禁止对系统程序代码以任何目的，任何形式的再发布
|
||
// | gitee下载：https://gitee.com/likeshop_gitee
|
||
// | github下载：https://github.com/likeshop-github
|
||
// | 访问官网：https://www.likeshop.cn
|
||
// | 访问社区：https://home.likeshop.cn
|
||
// | 访问手册：http://doc.likeshop.cn
|
||
// | 微信公众号：likeshop技术社区
|
||
// | likeshop团队 版权所有 拥有最终解释权
|
||
// +----------------------------------------------------------------------
|
||
// | author: likeshopTeam
|
||
// +----------------------------------------------------------------------
|
||
|
||
|
||
namespace app\api\logic;
|
||
|
||
use app\common\model\Ad;
|
||
use app\common\server\UrlServer;
|
||
use think\Db;
|
||
|
||
class AdLogic
|
||
{
|
||
public static function lists($pid, $client)
|
||
{
|
||
$ad_list = Db::name('ad a')
|
||
->join('ad_position ap', 'a.pid = ap.id')
|
||
->where(['pid' => $pid, 'ap.client' => $client, 'a.status' => 1, 'a.del' => 0, 'ap.status' => 1, 'ap.del' => 0])
|
||
->field('a.*')
|
||
->select();
|
||
|
||
$list = [];
|
||
foreach ($ad_list as $key => $ad) {
|
||
$url = $ad['link'];
|
||
$is_tab = 0;
|
||
$params = [];
|
||
switch ($ad['link_type']) {
|
||
case 1:
|
||
|
||
$page = Ad::getLinkPage($ad['client'], $ad['link']);
|
||
$url = $page['path'];
|
||
$is_tab = $page['is_tab'] ?? 0;
|
||
break;
|
||
case 2:
|
||
$goods_path = Ad::getGoodsPath($ad['client']);
|
||
$url = $goods_path;
|
||
$params = [
|
||
'id' => $ad['link'],
|
||
];
|
||
break;
|
||
}
|
||
$list[] = [
|
||
'image' => UrlServer::getFileUrl($ad['image']),
|
||
'link' => $url,
|
||
'link_type' => $ad['link_type'],
|
||
'params' => $params,
|
||
'is_tab' => $is_tab,
|
||
];
|
||
}
|
||
return $list;
|
||
}
|
||
|
||
public static function list_comost($get){
|
||
$staff=Db::name('staff')->where('id',$get['staff_id'])->find();
|
||
$admin=Db::name('admin')->where('phone',$staff['mobile'])->find();
|
||
$result = Db::name('user_address')->where('admin_id',$admin['id'])->select();
|
||
foreach ($result as $key => $k) {
|
||
if(is_null($result[$key]['brand_id'])){
|
||
$result[$key]['brand_name']='-';
|
||
}else{
|
||
$brand=Db::name('staffchannel')->where('id',$result[$key]['brand_id'])->find();
|
||
$result[$key]['brand_name']=$brand['name'];
|
||
}
|
||
if(is_null($result[$key]['label_id'])){
|
||
$result[$key]['label_name']='-';
|
||
}else{
|
||
$brand=Db::name('user_label')->where('id',$result[$key]['label_id'])->find();
|
||
if($brand){
|
||
$result[$key]['label_name']=$brand['name'];
|
||
}
|
||
|
||
}
|
||
|
||
}
|
||
|
||
return $result;
|
||
}
|
||
|
||
//增加跟进的内容
|
||
public static function follow_comost($get){
|
||
$result = Db::name('custom')
|
||
->where('custom_id',$get['id'])
|
||
->page($get['page'], $get['limit'])
|
||
->order('id desc')
|
||
->select();
|
||
foreach ($result as $key => $k) {
|
||
$result[$key]['time']=date('Y-m-d H:i:s',$result[$key]['create_time']);
|
||
$admin=Db::name('admin')->where('id',$result[$key]['admin_id'])->find();
|
||
if($admin){
|
||
$result[$key]['admin_name']=$admin['name'];
|
||
}
|
||
}
|
||
return $result;
|
||
|
||
}
|
||
|
||
public static function comost_add($get){
|
||
$staff=Db::name('staff')->where('id',$get['staff_id'])->find();
|
||
$admin=Db::name('admin')->where('phone',$staff['mobile'])->find();
|
||
$data=[
|
||
'admin_id'=>$admin['id'],
|
||
'connect' =>$get['reak'],
|
||
'custom_id'=>$get['orderid'],
|
||
'create_time'=>time()
|
||
];
|
||
return Db::name('custom')->data($data)->insert();
|
||
}
|
||
|
||
public static function notice(){
|
||
$lists=Db::name('staff_notice')->order('id asc')->limit(2)->select();
|
||
foreach ($lists as &$item){
|
||
$time1=time();
|
||
$daysDiff = abs(($time1 - $item['time']) / 86400);
|
||
if($daysDiff>10){
|
||
$item['date']=10;
|
||
}else{
|
||
$item['date']=intval($daysDiff);
|
||
}
|
||
}
|
||
return $lists;
|
||
}
|
||
|
||
public static function position(){
|
||
return Db::name('recruitype')->select();
|
||
}
|
||
|
||
public static function vode_type(){
|
||
return Db::name('video_type')->select();
|
||
}
|
||
|
||
public static function position_list($get){
|
||
|
||
$where=[];
|
||
|
||
if (isset($get['title']) && $get['title']) {
|
||
$where[] = ['name', 'like', '%' . $get['title'] . '%'];
|
||
}
|
||
|
||
if (isset($get['value']) && $get['value'] != '') {
|
||
$where[] = ['type_id', '=', $get['value']];
|
||
}
|
||
$data=Db::name('recrui')
|
||
->where($where)
|
||
->page($get['page'], $get['limit'])
|
||
->order('id desc')
|
||
->select();
|
||
|
||
foreach ($data as &$item) {
|
||
|
||
$type=Db::name('recruitype')->where('id',$item['type_id'])->find(); //获取岗位
|
||
$item['type_name']=$type['zpname'];
|
||
$salary=Db::name('recrui_salary')->where('id',$item['tment_id'])->find();
|
||
$item['salary_name']=$salary['name'];
|
||
|
||
$branch=Db::name('staff_group')->where('id',$item['branch_id'])->find();
|
||
$item['branch_name']=$branch['name'];
|
||
|
||
}
|
||
return $data;
|
||
|
||
}
|
||
|
||
public static function video_list($get){
|
||
$where=[];
|
||
if (isset($get['title']) && $get['title']) {
|
||
$where[] = ['name', 'like', '%' . $get['title'] . '%'];
|
||
}
|
||
if (isset($get['value']) && $get['value'] != '') {
|
||
$where[] = ['type_id', '=', $get['value']];
|
||
}
|
||
$data=Db::name('video')
|
||
->where($where)
|
||
->page($get['page'], $get['limit'])
|
||
->order('id desc')
|
||
->select();
|
||
foreach ($data as &$item) {
|
||
$type=Db::name('video_type')->where('id',$item['type_id'])->find(); //获取岗位
|
||
$item['type_name']=$type['title'];
|
||
$item['images']= UrlServer::getFileUrl($item['image']);
|
||
}
|
||
return $data;
|
||
}
|
||
|
||
public static function video_info($get){
|
||
return Db::name('video')->where('id',$get['id'])->find();
|
||
}
|
||
|
||
public static function user_wages($get){
|
||
|
||
$now = time();
|
||
$start_of_last_month = strtotime(date('Y-m-01 00:00:00', strtotime('-1 month', $now)));
|
||
$end_of_last_month = strtotime("last day of last month",$now); //上一个月结束时间搓
|
||
|
||
//总订单统计
|
||
$data['order']=Db::name('order_exe')
|
||
->where('staff_id',$get['user_id'])
|
||
->where('staff_status',3)
|
||
->whereTime('autotime','last month')
|
||
->count();
|
||
//上午的订单
|
||
$data['sw_orders']=Db::name('order_exe')
|
||
->where('staff_id',$get['user_id'])
|
||
->where('addtime',2)
|
||
->where('staff_status',3)
|
||
->whereTime('autotime','last month')
|
||
->count();
|
||
//下午的订单
|
||
$data['xw_orders']=Db::name('order_exe')
|
||
->where('staff_id',$get['user_id'])
|
||
->where('addtime',2)
|
||
->where('staff_status',3)
|
||
->whereTime('autotime','last month')
|
||
->count();
|
||
//报销的金额
|
||
$data['sement']=Db::name('finance')
|
||
->where('user_id',$get['user_id'])
|
||
->where('status',2)
|
||
->whereTime('create_time','last month')
|
||
->sum('pay');
|
||
|
||
//上午加时
|
||
|
||
$data['swaddtime']=Db::name('order_exe a')
|
||
->join('order_timeadd u','u.orderid=a.id')
|
||
->where('a.staff_id',$get['user_id'])
|
||
->where('a.autotime','>=',$start_of_last_month)
|
||
->where('a.autotime','<=',$end_of_last_month)
|
||
->where('u.status',2)
|
||
->where('a.addtime',1)
|
||
->sum('minute');
|
||
|
||
//下午加时
|
||
$data['xwaddtime']=Db::name('order_exe a')
|
||
->join('order_timeadd u','u.orderid=a.id')
|
||
->where('a.staff_id',$get['user_id'])
|
||
->where('a.autotime','>=',$start_of_last_month)
|
||
->where('a.autotime','<=',$end_of_last_month)
|
||
->where('u.status',2)
|
||
->where('a.addtime',2)
|
||
->sum('minute');
|
||
|
||
|
||
//请假代码
|
||
|
||
$data['leave']=Db::name('leavesd')
|
||
->where('staff_id',$get['user_id'])
|
||
->whereTime('time','last month')
|
||
|
||
->where('addtime','<>',2)
|
||
->count();
|
||
$number=Db::name('leavesd')
|
||
->where('staff_id',$get['user_id'])
|
||
->whereTime('time','last month')
|
||
->where('addtime',2)
|
||
->count();
|
||
$data['leaves']= $data['leave']/2+$number;
|
||
|
||
|
||
|
||
|
||
$data['fine']=Db::name('fine')
|
||
->where('staff_id',$get['user_id'])
|
||
->whereTime('create_time','last month')
|
||
->sum('score');
|
||
$data['abnormal']=Db::name('order_exe')
|
||
->where('staff_id',$get['user_id'])
|
||
->where('staff_status',3)
|
||
->where('abnormal',1)
|
||
->whereTime('autotime','last month')
|
||
->count();
|
||
|
||
|
||
|
||
$data['annual']=Db::name('order_abnormal')
|
||
->where('staff_id',$get['user_id'])
|
||
->whereTime('create_time','last month')
|
||
->count();
|
||
|
||
// 假设当前日期是2023-03-15
|
||
$current_date = date('Y-m-d');
|
||
|
||
// 获取上个月的第一天
|
||
$first_day_of_last_month = date('Y-m-01', strtotime($current_date . ' -1 month'));
|
||
|
||
// 获取上个月的最后一天
|
||
$last_day_of_last_month = date('Y-m-t', strtotime($first_day_of_last_month));
|
||
|
||
// 计算天数
|
||
$days_in_last_month = date('j', strtotime($last_day_of_last_month)) - date('j', strtotime($first_day_of_last_month)) + 1;
|
||
|
||
$data['lastdate']=$days_in_last_month-$data['leaves'];
|
||
|
||
return $data;
|
||
}
|
||
|
||
public static function user_wages_add($get){
|
||
$now = time();
|
||
// 获取上个月的时间戳
|
||
$lastMonthTimestamp = strtotime('-1 month', $now);
|
||
$staff=Db::name('staff')->where('id',$get['user_id'])->find();
|
||
|
||
$staff_uages=Db::name('staff_wages')
|
||
->where('staff_id',$get['user_id'])
|
||
->whereTime('last_addtime','last month')
|
||
->find();
|
||
if($staff_uages){
|
||
return -1;
|
||
}
|
||
|
||
$last_month_month = date('m') - 1;
|
||
if($last_month_month==0){
|
||
$last_month_month =12;
|
||
}
|
||
|
||
|
||
$data=[
|
||
'staff_name' => $staff['name'],
|
||
'staff_phone' => $staff['mobile'],
|
||
'total_orders' => $get['total_orders'],
|
||
'sw_orders' =>$get['sw_orders'],
|
||
'xw_orders' => $get['xw_orders'],
|
||
'finance' => $get['finance'],
|
||
'sw_addtime' =>$get['sw_addtime']/60,
|
||
'xw_addtime' => $get['xw_addtime']/60,
|
||
'leave' =>$get['leave']/2,
|
||
'attendance' =>$get['attendance'],
|
||
'staff_id' => $get['user_id'],
|
||
'status' =>$get['status'],
|
||
'break' =>$get['reake'],
|
||
'month' => $last_month_month,
|
||
'last_addtime' =>$lastMonthTimestamp,
|
||
'annual' =>$get['annual'],
|
||
'abnormal' =>$get['abnormal'],
|
||
'fine' =>$get['fine'],
|
||
|
||
'create_time' =>$now
|
||
];
|
||
return Db::name('staff_wages')->data($data)->insert();
|
||
}
|
||
|
||
public static function user_leave($get){
|
||
|
||
$lists=Db::name('leavesd')
|
||
->where('staff_id',$get['staff_id'])
|
||
->page($get['page'], $get['pageSize'])
|
||
->order('id desc')
|
||
->select();
|
||
foreach ($lists as &$item) {
|
||
if($item['addtime']==0){
|
||
$item['addtime']="上午";
|
||
$item['uration']=4;
|
||
}else if($item['addtime']==2){
|
||
$item['addtime']="全天";
|
||
$item['uration']=8;
|
||
}
|
||
|
||
else{
|
||
$item['addtime']="下午";
|
||
$item['uration']=4;
|
||
}
|
||
$item['create_time']=date('Y-m-d',$item['create_time']);
|
||
$item['time']=date('Y-m-d',$item['time']);
|
||
}
|
||
return $lists;
|
||
|
||
}
|
||
public static function last_leave($get){
|
||
$lists=Db::name('leave')
|
||
->where('user_id',$get['staff_id'])
|
||
->whereTime('time', 'last month')
|
||
->page($get['page'], $get['pageSize'])
|
||
->order('id desc')
|
||
->select();
|
||
foreach ($lists as &$item) {
|
||
$type=Db::name('leave_type')->where('id',$item['type'])->find(); //获取岗位
|
||
if($type){
|
||
$item['type_name']=$type['name'];
|
||
$item['create_time']=date('Y-m-d',$item['create_time']);
|
||
$item['time']=date('Y-m-d',$item['time']);
|
||
if($item['addtime']==1){
|
||
$item['addtime']="上午";
|
||
}else{
|
||
$item['addtime']="下午";
|
||
}
|
||
}
|
||
|
||
|
||
}
|
||
return $lists;
|
||
}
|
||
|
||
public static function fine($get){
|
||
$lists=Db::name('fine')
|
||
->where('staff_id',$get['staff_id'])
|
||
->page($get['page'], $get['pageSize'])
|
||
->order('id desc')
|
||
->select();
|
||
foreach ($lists as &$item) {
|
||
$type=Db::name('staff_fine')->where('id',$item['type_id'])->find(); //获取岗位
|
||
$item['type_name']=$type['name'];
|
||
$item['create_time']=date('Y-m-d',$item['create_time']);
|
||
|
||
|
||
}
|
||
return $lists;
|
||
|
||
}
|
||
public static function last_fine($get){
|
||
$lists=Db::name('fine')
|
||
->where('staff_id',$get['staff_id'])
|
||
->whereTime('create_time', 'last month')
|
||
->page($get['page'], $get['pageSize'])
|
||
->order('id desc')
|
||
->select();
|
||
foreach ($lists as &$item) {
|
||
$type=Db::name('staff_fine')->where('id',$item['type_id'])->find(); //获取岗位
|
||
$item['type_name']=$type['name'];
|
||
$item['create_time']=date('Y-m-d',$item['create_time']);
|
||
|
||
|
||
}
|
||
return $lists;
|
||
}
|
||
|
||
public static function addrecruit($get){
|
||
$get['crem_time']=time();
|
||
return Db::name('user_recruit')->data($get)->insert();
|
||
}
|
||
|
||
public static function notice_list($get){
|
||
$list=Db::name('staff_notice')
|
||
->page($get['page'], $get['pageSize'])
|
||
->order('id desc')
|
||
->select();
|
||
foreach ($list as &$item) {
|
||
$item['time']=date('Y-m-d',$item['time']);
|
||
}
|
||
return $list;
|
||
}
|
||
|
||
public static function addleave($get){
|
||
|
||
$staff=Db::name('staff')->where('id',$get['staff_id'])->find();
|
||
$data=[
|
||
'staff_id' =>$get['staff_id'],
|
||
'time' =>strtotime($get['time']),
|
||
'type' =>$get['type'],
|
||
'addtime' =>$get['after'],
|
||
'reak' =>$get['reak'],
|
||
'name' =>$staff['name'],
|
||
'phone' =>$staff['mobile'],
|
||
'create_time'=>time(),
|
||
];
|
||
return Db::name('leavesd')->data($data)->insert();
|
||
}
|
||
//获取员工的权限
|
||
public static function auth($param){
|
||
$role=Db::name('staff')->alias('s')
|
||
->join('staff_group g', 's.group_id = g.id')
|
||
->where('s.id',$param['staff_id'])
|
||
->field('g.rloe')
|
||
->find();
|
||
$roleArray = explode(',', $role['rloe']);
|
||
$data=Db::name('dev_staffauth')
|
||
->where('id','in', $roleArray)
|
||
->select();
|
||
return linear_to_tree($data);
|
||
|
||
}
|
||
|
||
} |