0){ $where[] = ['is_gc', '=' ,1]; }else{ $where[] = ['is_gc', '=' ,0]; } $roof = WaterMaterialScience::where('id', $data['roof'])->find(); $roofs = WaterMaterialScience::where('type', 1)->where('th_id', $roof['th_id'])->where($where)->column('long,wide', 'id');//符合厚度的顶板 $area = $data['long'] * $data['wide'];// 面积 $roof_number = ($data['long']/1) * intval(($data['wide']/1)); // 顶板使用数量1*1 halt($roof_number); } /** * 材料列表 * @return mixed * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public function list() { $data = UtilService::getMore(['is_gc']); $list = []; if ($data['is_gc'] > 0){ $where[] = ['is_gc', '=' ,1]; }else{ $where[] = ['is_gc', '=' ,0]; } $list['warm'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 7)->where($where)->select(); // 保温 $list['channel'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 8)->where($where)->select(); // 槽钢 $list['roof'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 1)->where($where)->select();// 顶板 $list['side_plate'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 2)->where($where)->select();// 侧板 $list['lacing'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 3)->where($where)->select();// 拉筋 $list['floor'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 4)->where($where)->select(); // 底板 $list['column'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 5)->where($where)->select(); // 立柱 $list['fula'] = WaterMaterialScience::field('id,name,unit_price,company')->where('type', 6)->where($where)->select(); // 辅拉 return app('json')->success($list); } }