$param['master_worker_id'], 'worker_number' => $param['worker_number'], 'engineer_name' => $param['engineer_name'], 'original_balance' => $param['original_balance'], 'total_settlement_amount' => $param['total_settlement_amount'], 'deduction_amount' => $param['deduction_amount'], 'final_settlement_amount' => $param['final_settlement_amount'], 'settlement_time' => $param['settlement_time'], 'settlement_details_remarks' => $param['settlement_details_remarks'], ]); } Db::commit(); return true; } catch (\Exception $e) { Db::rollback(); self::setError($e->getMessage()); return false; } } /** * @notes 编辑 * @param array $params * @return bool * @author likeadmin * @date 2024/11/15 17:21 */ public static function edit(array $params): bool { Db::startTrans(); try { EngineerSettlement::where('id', $params['id'])->update([ 'master_worker_id' => $params['master_worker_id'], 'worker_number' => $params['worker_number'], 'engineer_name' => $params['engineer_name'], 'original_balance' => $params['original_balance'], 'total_settlement_amount' => $params['total_settlement_amount'], 'deduction_amount' => $params['deduction_amount'], 'final_settlement_amount' => $params['final_settlement_amount'], 'settlement_time' => $params['settlement_time'], 'settlement_details_remarks' => $params['settlement_details_remarks'], ]); Db::commit(); return true; } catch (\Exception $e) { Db::rollback(); self::setError($e->getMessage()); return false; } } /** * @notes 删除 * @param array $params * @return bool * @author likeadmin * @date 2024/11/15 17:21 */ public static function delete(array $params): bool { return EngineerSettlement::destroy($params['id']); } /** * @notes 获取详情 * @param $params * @return array * @author likeadmin * @date 2024/11/15 17:21 */ public static function detail($params): array { return EngineerSettlement::findOrEmpty($params['id'])->toArray(); } public static function downloadLists(): array { return EngineerSettlement::where('id','>',0) ->field(['id', 'master_worker_id', 'worker_number', 'engineer_name', 'original_balance', 'total_settlement_amount', 'deduction_amount', 'final_settlement_amount', 'settlement_time', 'settlement_details_remarks']) ->order(['id' => 'desc']) ->select() ->toArray(); } }