PHP mod_tra_BO::search примеры использования

Пример #1

Файл: pneu_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai_sus_rel_ent_tan_pne, pneu\n\t\t\t\tFROM mod_tra_mot_cai_sus_rel_ent_tan_pne JOIN pneu ON mod_tra_mot_cai_sus_rel_ent_tan_pne.id_pneu=pneu.id_pneu\n\t\t\t\tWHERE id_mod_tra_mot_cai_sus_rel_ent_tan=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("pneu", NULL, "*", "pneu");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #2

Файл: tracao_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra, tracao.id_tracao, tracao FROM mod_tra JOIN tracao ON mod_tra.id_tracao=tracao.id_tracao WHERE id_modelo=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("tracao", NULL, "*", "tracao");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);

Пример #3

Файл: cabine_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai_sus_rel_ent_tan_pne_pac_cab, cabine\n\t\t\t\tFROM mod_tra_mot_cai_sus_rel_ent_tan_pne_pac_cab JOIN cabine ON mod_tra_mot_cai_sus_rel_ent_tan_pne_pac_cab.id_cabine=cabine.id_cabine\n\t\t\t\tWHERE id_mod_tra_mot_cai_sus_rel_ent_tan_pne_pac=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("cabine", NULL, "*", "cabine");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #4

Файл: relacao_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai_sus_rel, relacao_diferencial FROM mod_tra_mot_cai_sus_rel JOIN relacao_diferencial ON mod_tra_mot_cai_sus_rel.id_relacao_diferencial=relacao_diferencial.id_relacao_diferencial\n\t\t\t\tWHERE id_mod_tra_mot_cai_sus=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("relacao_diferencial", NULL, "*", "relacao_diferencial");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #5

Файл: pacote_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai_sus_rel_ent_tan_pne_pac, pacote\n\t\t\t\tFROM mod_tra_mot_cai_sus_rel_ent_tan_pne_pac JOIN pacote_acabamento ON mod_tra_mot_cai_sus_rel_ent_tan_pne_pac.id_pacote=pacote_acabamento.id_pacote\n\t\t\t\tWHERE id_mod_tra_mot_cai_sus_rel_ent_tan_pne=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("pacote_acabamento", NULL, "*", "pacote");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #6

Файл: tanque_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai_sus_rel_ent_tan, tanque\n\t\t\t\tFROM mod_tra_mot_cai_sus_rel_ent_tan JOIN tanque ON mod_tra_mot_cai_sus_rel_ent_tan.id_tanque=tanque.id_tanque\n\t\t\t\tWHERE id_mod_tra_mot_cai_sus_rel_ent=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("tanque", NULL, "*", "tanque");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #7

Файл: caixa_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai, caixa_cambio FROM mod_tra_mot_cai JOIN caixa_cambio ON mod_tra_mot_cai.id_caixa_cambio=caixa_cambio.id_caixa_cambio \n\t\t\t\tWHERE id_mod_tra_mot=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("caixa_cambio", NULL, "*", "caixa_cambio");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #8

Файл: modelo_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
$M_newMatrix = $P_BO->search("modelo", NULL, "*", "modelo");
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #9

Файл: eixos_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai_sus_rel_ent, entre_eixos\n\t\t\t\tFROM mod_tra_mot_cai_sus_rel_ent JOIN entre_eixos ON mod_tra_mot_cai_sus_rel_ent.id_entre_eixos=entre_eixos.id_entre_eixos\n\t\t\t\tWHERE id_mod_tra_mot_cai_sus_rel=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("entre_eixos", NULL, "*", "entre_eixos");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #10

Файл: suspensao_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot_cai_sus, suspensao_traseira\n\t\t\t\tFROM mod_tra_mot_cai_sus JOIN suspensao_traseira ON mod_tra_mot_cai_sus.id_suspensao_traseira=suspensao_traseira.id_suspensao_traseira\n\t\t\t\tWHERE id_mod_tra_mot_cai=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("suspensao_traseira", NULL, "*", "suspensao_traseira");
}
//print_r($M_newMatrix);
for ($i = 0; $i < count($M_newMatrix); $i++) {
    $M_newMatrix[$i]['suspensao_traseira'] = $M_newMatrix[$i]['suspensao_traseira'];
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############

Пример #11

Файл: motor_list.vw.php Проект: wborbajr/VolvoApp

<?php

// PRINCIPAIS CLASSES CORE
require_once '../../dashboard/core/modules/utils/autoload.php';
session_start();
// ############# INICIO SELECT DADOS #############
$P_BO = new mod_tra_BO();
if (isset($_GET) && !empty($_GET)) {
    $_id = $_GET['id'];
    $_sql = "SELECT id_mod_tra_mot, motor FROM mod_tra_mot JOIN motor ON mod_tra_mot.id_motor=motor.id_motor WHERE id_mod_tra=" . $_id;
    $M_newMatrix = $P_BO->execQueryMy($_sql);
} else {
    $M_newMatrix = $P_BO->search("motor", NULL, "*", "motor");
}
$M_newMatrix = json_encode($M_newMatrix);
print_r($M_newMatrix);
// ############# FIM SELECT DADOS #############