<?php
// +----------------------------------------------------------------------
// | likeadmin快速开发前后端分离管理后台（PHP版）
// +----------------------------------------------------------------------
// | 欢迎阅读学习系统程序代码，建议反馈是我们前进的动力
// | 开源版本可自由商用，可去除界面版权logo
// | gitee下载：https://gitee.com/likeshop_gitee/likeadmin
// | github下载：https://github.com/likeshop-github/likeadmin
// | 访问官网：https://www.likeadmin.cn
// | likeadmin团队 版权所有 拥有最终解释权
// +----------------------------------------------------------------------
// | author: likeadminTeam
// +----------------------------------------------------------------------


namespace app\adminapi\controller\master_worker;


use app\adminapi\controller\BaseAdminController;
use app\adminapi\lists\master_worker\EngineerBillLists;
use think\facade\Db;

/**
 * EngineerSettlement控制器
 * Class EngineerSettlementController
 * @package app\adminapi\controller
 */
class EngineerBillController extends BaseAdminController
{
    public array $notNeedLogin = ['download'];

    /**
     * @notes 获取列表
     * @return \think\response\Json
     * @author likeadmin
     * @date 2024/11/15 17:21
     */
    public function lists()
    {
        return $this->dataLists(new EngineerBillLists());
    }

    public function download()
    {
        $firstDay = date('Y-m-01 00:00:00', strtotime('first day of last month'));
        $lastDay = date('Y-m-t 23:59:59', strtotime('last day of last month'));
        $lists =  Db::name('master_worker')->alias('a')->field([
            'a.id','a.real_name','a.nickname','a.worker_number','e.account_holder','e.bank_name','e.opening_branch','e.account as bank_account',
            Db::raw("IFNULL(c.maxid,0) as maxid"),Db::raw("IFNULL(d.left_amount,0) as left_amount")
        ])
            ->leftJoin([Db::name('master_worker_account_log')
                ->where('create_time','between',[strtotime($firstDay),strtotime($lastDay)])
                ->field('worker_id as master_worker_id, max(id) as maxid')
                ->group('worker_id')
                ->buildSql() => 'c'], 'a.id = c.master_worker_id')
            ->leftJoin('master_worker_account_log d', 'c.maxid = d.id')
            ->leftJoin('bank_account e', 'a.id = e.worker_id')
            //->where('d.left_amount', '>', 0)
            ->select()->toArray();
        //$lists = $lists['lists'];
        header('Content-Type: text/csv; charset=utf-8');
        header('Content-Disposition: attachment; filename=engineer_settlement.csv');
        $output = fopen('php://output', 'w');
        fputcsv($output, array('工程师ID', '工程师编号', '工程师姓名', '工程师银行卡号', '工程师开户行及支行信息','上月最后结算余额'));
        foreach ($lists as $row) {
            fputcsv($output, array(
                $row['id'],
                $row['worker_number'],
                $row['nickname'],
                $row['bank_account'],
                $row['bank_name'].$row['opening_branch'],
                $row['left_amount']
            ));
        }
        fclose($output);
    }

}