Example #1
0
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) < 2) {
    print "Usage: add_repair_post.php [name]";
    exit(1);
}
print "add_repair_post: {$argv[1]}";
$newRepairPost = new RepairPost();
$newRepairPost->name = $argv[1];
$newRepairPost->save();
exit(0);
Example #3
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();