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(); }
<?php include_once dirname(__FILE__) . "/../models/index.php"; if (!$argv || count($argv) < 3) { print "Usage: add_repair_type.php [repair_post_id] [name]"; exit(1); } print "add_repair_type: {$argv[1]} {$argv[2]}"; $newRepairType = new RepairType(); $newRepairType->repair_post = intval($argv[1]); $newRepairType->name = $argv[2]; $newRepairType->save(); exit(0);
} } else { return ["err" => "VALIDATE_FORM_ERROR", "errors" => $gump->errors()]; } } // создание события Macaw::post('/create_event', function () { Log::toDebug("CREATE EVENT ROUTE"); $user = checkAuth(); Application::sendJson(processForm($_POST, $user)); }); // вспомогательные данные Macaw::get('source', function () { Log::toDebug("source"); $user = checkAuth(); Application::sendJson(["repair_post" => RepairPost::all(), "repair_type" => RepairType::all(), "state" => [["id" => 0, "name" => "Назначено"], ["id" => 1, "name" => "Выполнено"], ["id" => 2, "name" => "Отклонено"]]]); }); function PopulateEvent($event) { return ["user_owner_id" => User::retrieveByPK($event->user_owner_id), "user_target_id" => User::retrieveByPK($event->user_target_id), "customer_id" => Customer::retrieveByPK($event->customer_id), "customer_car_id" => CustomerCar::retrieveByPK($event->customer_car_id)]; } function buildQueryAndEqStatement($name, $value, $op = "=", $escape = false) { if ($escape) { return " AND {$name}{$op}'{$value}' "; } return " AND {$name}{$op}{$value} "; } // список событий Macaw::post('events', function () { $user = checkAuth();