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()];
}
}
