public function input2(Request $request) { $Sheet = $request->input('Document_ID'); //Проверяем документ на ведомость $document = DB::connection('sqlsrv')->table('Documents')->selectRaw('DocumentType_Code,Document_ID')->where('Document_ID', $Sheet)->where('DocumentType_Code', 170)->get(); if ($document->isEmpty()) { $Point_ID = $request->input('point_id'); $Reading_Value = $request->input('Reading_Value'); $PReading_Value = $request->input('PReading_Value'); $Action_Date = $request->input('Action_Date'); $MeterReading_ID = $request->input('MeterReading_ID'); $ReadingType_Code = $request->input('ReadingType_Code'); if (Input::has("MeterReading_ID0")) { $MeterReading_ID = $request->input('MeterReading_ID0'); $Reading_Value = $request->input('Reading_Value0'); $PReading_Value = $request->input('PReading_Value0'); $Document_ID = $request->input('Document_ID0'); $ReadingType_Code = $request->input('ReadingType_Code0'); DB::connection('sqlsrv')->table('MeterReadings')->where('MeterReading_ID', $MeterReading_ID)->update(['Reading_Value' => $Reading_Value, 'Reading_Difference_Value' => $Reading_Value - $PReading_Value, 'Daily_Difference_Value' => ($Reading_Value - $PReading_Value) / 30]); $MeterReadings = DB::connection('sqlsrv')->table('MeterReadings')->where('MeterReading_ID', $MeterReading_ID)->first(); $PointActions = DB::connection('sqlsrv')->table('PointActions')->where('Meter_ID', $MeterReadings->Meter_ID)->where('Document_ID', $Document_ID)->where('PointAction_ID', $MeterReadings->PointAction_ID)->first(); DB::connection('sqlsrv')->table('PointConsumptions')->where('PointAction_ID', $PointActions->PointAction_ID)->where('Point_ID', $PointActions->Point_ID)->where('Deal_ID', $PointActions->Deal_ID)->where('Document_ID', $PointActions->Document_ID)->update(['PointConsumption_Value' => $Reading_Value - $PReading_Value]); $PointConsumptions = DB::connection('sqlsrv')->table('PointConsumptions')->where('PointAction_ID', $PointActions->PointAction_ID)->where('Point_ID', $PointActions->Point_ID)->where('Deal_ID', $PointActions->Deal_ID)->where('Document_ID', $PointActions->Document_ID)->first(); $PointConsumptionItems = DB::connection('sqlsrv')->table('PointConsumptionItems')->where('PointConsumption_ID', $PointConsumptions->PointConsumption_ID)->first(); DB::connection('sqlsrv')->table('PointConsumptionItems')->where('PointConsumption_ID', $PointConsumptions->PointConsumption_ID)->update(['PointConsumptionItem_Value' => $Reading_Value - $PReading_Value, 'DailyConsumption_Value' => ($Reading_Value - $PReading_Value) / $PointConsumptionItems->Days_Count]); DB::connection('sqlsrv')->table('PointConsumptionStatuses')->where('PointConsumption_ID', $PointConsumptions->PointConsumption_ID)->update(['PointConsumption_Value' => $Reading_Value - $PReading_Value]); DB::connection('sqlsrv')->table('MeterConsumptions')->where('PointConsumptionItem_ID', $PointConsumptionItems->PointConsumptionItem_ID)->update(['MeterConsumption_Value' => $Reading_Value - $PReading_Value]); DB::connection('sqlsrv')->table('PointConsumptionItemLines')->where('PointConsumptionItem_ID', $PointConsumptionItems->PointConsumptionItem_ID)->where('ReadingType_Code', $ReadingType_Code)->update(['PointConsumptionItemLine_Value' => $Reading_Value - $PReading_Value, 'DailyPointConsumptionItemLine_Value' => ($Reading_Value - $PReading_Value) / $PointConsumptionItems->Days_Count]); } Session::flash('msg', 'Успешно обновлено'); $ConsumptionSheet_ID = Session::get('ConsumptionSheet_ID'); $results = DB::connection('sqlsrv')->table('ConsumptionSheets')->join('MeteringRoutePoints', 'MeteringRoutePoints.Document_ID', '=', 'ConsumptionSheets.MeteringRoute_ID')->join('DealPoints', 'DealPoints.Point_ID', '=', 'MeteringRoutePoints.Point_ID')->join('Deals', 'Deals.Deal_ID', '=', 'DealPoints.Deal_ID')->join('PointAssets', 'PointAssets.Point_ID', '=', 'MeteringRoutePoints.Point_ID')->join('Assets', 'Assets.Asset_ID', '=', 'PointAssets.Asset_ID')->select('ConsumptionSheet_ID', 'MeteringRoutePoints.Point_ID', 'MeteringRoutePoints.Document_ID', 'Deals.Deal_ID', 'Deal_Num', 'Subject_Name', 'Address_Name', 'Serial_Number')->where('ConsumptionSheets.ConsumptionSheet_ID', $ConsumptionSheet_ID)->get(); return View::make('admin.legal.list', compact('results')); } $id = Document::insertGetId(['Document_Num' => 'б/н', 'Document_Date' => '2016-09-30', 'DocumentType_Code' => '108', 'Comments' => '{"Deal_ID":' . $Sheet . ',"Deal_Num":' . $Sheet . ',"Is_Deal_Num_Incomplete":false,"Subject_Name":"","Supplier_Name":"","SupplierServices_Names":"","ReadingsReadBy":"Supplier","Person":"Каниболоцкий С. В.","Person_ID":6865254,"Action_Date":"30.09.2016","BaseDocumentType_Code":1,"CorrectionPeriodId":" ","calculationMethod":0,"calculationMethodDate":null,"pStatusCode":1,"p_DealType_Code":["2"],"p_Deal_ID":"","p_Deal_Num":"","p_Subject_Name":"","Is_Include_Agreements":true,"Is_Include_Accounts":false,"p_Substation_IDs":"","p_Substation_Names":"","p_ConsumptionGroup_Code":"","p_BranchGroup_IDs":"","p_BranchGroup_Names":"","p_District_Codes":"","p_District_Names":"","p_Department_IDs":"","p_Department_Names":"","p_Supplier_IDs":"","p_Supplier_Names":"Все","p_Point_ID":"","p_Point_Name":""}', 'Date_Fix' => '2016-09-30', 'User_ID' => 167, 'Date_Create' => date('Y-m-d H:i'), 'Period_ID' => 92, 'Status_ID' => 2565, 'Status_User_ID' => '167', 'Status_Date' => date('Y-m-d H:i')]); $id = new Document(); $id->Document_Num = 'б/н'; $id->Document_Date = '2016-09-30'; $id->DocumentType_Code = '108'; $id->save(); echo $id->id; }