導入代碼 · 衍宏智慧社區開發技術文檔

導入代碼 ~~~ /* * 物業費導入實收數據 * 美麗四期 * 第一步 */ public function siqi(){ set_time_limit(0);// $list = import_excel('excel/4.xls'); unset($list[1]); // print_r($list); // exit; $successNum = 0; foreach ($list as $key => $val) { // print_r($val); exit; $data = []; $data['item_id'] = $this->item_id; $data['order_id'] = $val[0]; //訂單 $data['user_name'] = $val[1]; //姓名 $data['room'] = $val[2]; //房號 $data['building_area'] = $val[3]; //面積 $data['start_time'] = $val[4]; //起止日期 $data['end_time'] = $val[5]; //起止日期 $data['total'] = $val[6]; //合計 $data['remark'] = $val[7]; //用戶類型 $data['category'] = 1; Db::name('temp_managefee')->insertGetId($data); $successNum++; } echo '成功導入'.$successNum.'條數據'; exit; } ~~~ ~~~ /* * 物業費導入減免數據 * 美麗四期 * 第二步 */ public function jianmian_siqi(){ set_time_limit(0);// $list = import_excel('excel/4-.xls'); unset($list[1]); $successNum = 0; foreach ($list as $key => $val) { // print_r($val); exit; $data = []; $data['item_id'] = $this->item_id; $data['order_id'] = $val[0]; //訂單 $data['user_name'] = $val[1]; //姓名 $data['room'] = $val[2]; //房號 $data['building_area'] = $val[3]; //面積 $data['start_time'] = $val[4]; //起止日期 $data['end_time'] = $val[5]; //起止日期 $data['jianmian'] = $val[6]; //合計 $data['remark'] = '減免'.$val[7]; //用戶類型 $data['category'] = 0; //減免 Db::name('temp_managefee')->insertGetId($data); $successNum++; } echo '成功導入'.$successNum.'條數據'; exit; } ~~~ ~~~ /* * 物業費對接數據 * 美麗四期 * 第三步 */ public function duijie_siqi(){ set_time_limit(0);// $item_id = $this->item_id; $map = []; $worksheet = Db::name('temp_managefee')->where( $map )->order('id ASC')->select(); // Db::name('worksheet')->where( 'item_id','<>','' )->update(['item_id'=>3]); // print_r($worksheet); exit; // return json($worksheet); $successNum = 0; foreach ($worksheet as $key => $val) { $room = explode('-', $val['room']); $building_name = $room[0]; $room_number = $room[1]; //重置臨時表 $data = []; $data['item_id'] = $item_id; $data['building_name'] = $building_name; $data['room_number'] = $room_number; $data['unit_price'] = 2.2; $data['unit'] = $room[1]; $data['months'] = get_month_num($val['start_time'],$val['end_time']); // 替換房號把3A替換成4 // $room_number = preg_replace('/3A/i','4',$room_number); $data['building_id'] = Db::name('building')-> where( ['item_id'=>$item_id,'building_name'=>$data['building_name']] )->value('id'); $data['room_id'] = Db::name('room')-> where( ['item_id'=>$item_id,'building_name'=>$data['building_name'],'number'=>$data['room_number']] )->value('id'); if( empty($data['building_id']) || empty($data['room_id'])){ echo '對接失敗,編號：'.$val['id'].',房號：'.$building_name.'-'.$room_number.'<br>'; continue; } Db::name('temp_managefee')->where( 'id',$val['id'] )->update($data); $successNum++; } return '對接成功'.$successNum.'條數據'; } ~~~ ~~~ /* * 物業費入庫 * 美麗四期 * 第四步 */ public function siqi_ruku(){ set_time_limit(0);// $item_id = $this->item_id; $map = []; $worksheet = Db::name('temp_managefee')->where( $map )->order('id ASC')->select(); // Db::name('worksheet')->where( 'item_id','<>','' )->update(['item_id'=>3]); $successNum = 0; $errorNum = 0; $nowTime = time(); foreach ($worksheet as $key => $val) { // 入庫 $insert = []; $insert['item_id'] = $val['item_id']; $insert['building_id'] = $val['building_id']; $insert['room_id'] = $val['room_id']; $insert['room_number'] = $val['room_number']; // $insert['order_id'] = $val['order_id']; $insert['user_name'] = $val['user_name']; $insert['start_time'] = $val['start_time']; $insert['end_time'] = $val['end_time']; $insert['unit_price'] = $val['unit_price']; // $insert['building_area'] = $val['building_area']; // $insert['decorate'] = '否'; $insert['payable'] = $val['payable']; $insert['remark'] = $val['remark']; $insert['cost_type'] = 'managefee'; $insert['cost_explain'] = '物業費'; $insert['purpose'] = '否'; //空置 $insert['status'] = 1; //已付款 $insert['payment'] = '現金'; //默認現金全付款 $insert['pay_way'] = '導入'; $insert['admin_id'] = $this->admin_id; $insert['admin_name'] = $this->admin_name; $insert['pay_time'] = strtotime('2015-09-01'); //時間戳 $insert['update_time'] = strtotime('2015-09-01'); //時間戳 $insert['create_time'] = strtotime('2015-09-01'); //時間戳 $insert['import_time'] = $nowTime; //時間戳 $insert['payable'] = get_cost_for_date($val['start_time'],$val['end_time'],$val['building_area'],$val['unit_price']); //時間戳 if($val['category']==1){ $insert['total'] = $val['total']; $insert['collected'] = $val['total']; $insert['uncollected'] = 0; $insert['months'] = $val['months']; $insert['deposit'] = 0; //押金轉物業費 $insert['derate_num'] = 0; }else{ $insert['derate_num'] = $val['months']; //減免月數 $insert['derate_price'] = $val['jianmian']; //減免金額 $insert['months'] = 0; } $id = Db::name('fee_manage')->insertGetId($insert); if($id){ $order_id = get_order_id_for_tableid($id); Db::name('fee_manage')->where( 'id',$id )->update(['order_id'=>$order_id]); $successNum++; }else{ } } $str = ''; $str .= '導入前：'.Db::name('fee_manage')->count().'條數據'; $str .= '<br>'; $str .= '成功導入'.$successNum.'條數據'; $str .= '<br>'; sleep(1); return $str .= '導入后：'.Db::name('fee_manage')->count().'條數據'; } ~~~