function migrate() { global $conn; $sql = getMigrateQueryHeader(); $sql .= Customer::getSchemaSQL(); $sql .= CustomerCar::getSchemaSQL(); $sql .= EventLog::getSchemaSQL(); $sql .= GreaseRatEvent::getSchemaSQL(); $sql .= RepairPost::getSchemaSQL(); $sql .= RepairType::getSchemaSQL(); $sql .= User::getSchemaSQL(); if ($conn->multi_query($sql)) { do { if ($result = $conn->store_result()) { while ($row = $result->fetch_row()) { printf("%s\n", $row[0]); } $result->free(); } if ($conn->more_results()) { printf("-----------------\n"); } } while ($conn->next_result()); } $conn->close(); }
function processForm($data, $user) { $gump = new GUMP(); $data = $gump->sanitize($data); $gump->validation_rules(array('user_target_name' => 'required', 'repair_post_id' => 'required|integer', 'repair_type_id' => 'required|integer', 'user_target_id' => 'required|integer', 'startdatetime' => 'required', 'enddatetime' => 'required', 'customer_car_gv_number' => 'required', 'customer_car_mileage' => 'integer', 'customer_car_name' => 'required', 'customer_car_vin' => 'required', 'customer_name' => 'required', 'customer_phone' => 'required', 'customer_id' => 'integer', 'customer_car_id' => 'integer', 'id' => 'integer', 'state' => 'required|integer')); $gump->filter_rules(array('user_target_name' => 'trim|sanitize_string', 'customer_car_gv_number' => 'trim|sanitize_string', 'customer_car_name' => 'trim|sanitize_string', 'customer_car_vin' => 'trim|sanitize_string', 'customer_name' => 'trim|sanitize_string', 'customer_phone' => 'trim|sanitize_string')); $customer_car_id = null; $customer_id = null; $validated_data = $gump->run($data); if ($validated_data) { $customer_car = null; $customer = null; // добавляем авто if (!isset($validated_data['customer_car_id'])) { $customer_car = new CustomerCar(); } else { $customer_car = CustomerCar::retrieveByPK($validated_data['customer_car_id']); } $customer_car->gv_number = $validated_data["customer_car_gv_number"]; $customer_car->mileage = $validated_data["customer_car_mileage"]; $customer_car->name = $validated_data["customer_car_name"]; $customer_car->vin = $validated_data["customer_car_vin"]; try { $customer_car->save(); $customer_car_id = $customer_car->id; Log::toDebug(["Save CustomerCar", $customer_car_id]); } catch (Exception $ex) { Log::toDebug("ERROR_SAVE_TO_DATABASE"); return ["err" => "ERROR_SAVE_TO_DATABASE"]; } // добавляем заказчика if (!isset($validated_data['customer_id'])) { $customer = new Customer(); } else { $customer = Customer::retrieveByPK($validated_data['customer_id']); } $customer->name = $validated_data["customer_name"]; $customer->phone = $validated_data["customer_phone"]; try { $customer->save(); $customer_id = $customer->id; Log::toDebug(["Save CustomerCar", $customer_id]); } catch (Exception $ex) { return ["err" => "ERROR_SAVE_TO_DATABASE"]; } try { if (!isset($validated_data['id'])) { $new_event = new GreaseRatEvent(); } else { $new_event = GreaseRatEvent::retrieveByPK($validated_data['id']); } $new_event->repair_post_id = $validated_data["repair_post_id"]; $new_event->repair_type_id = $validated_data["repair_type_id"]; if (isset($user)) { $new_event->user_owner_id = $user->id; } $new_event->user_target_id = $validated_data["user_target_id"]; $new_event->state = $validated_data["state"]; $new_event->customer_id = $customer_id; $new_event->customer_car_id = $customer_car_id; $new_event->startdatetime = $validated_data["startdatetime"]; $new_event->enddatetime = $validated_data["enddatetime"]; $new_event->save(); Log::toDebug(["Save rat event", $new_event->id]); return ['event' => $new_event]; } catch (Exception $ex) { return ["err" => "ERROR_SAVE_TO_DATABASE"]; } } else { return ["err" => "VALIDATE_FORM_ERROR", "errors" => $gump->errors()]; } }