top.window.location = '../../index.php'";
exit;
}
require_once __DIR__ . "/" . "../../includes/include_basics_only.php";
require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php";
$auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 2);
use includes\classes\ConnectPDO;
$conn = ConnectPDO::getInstance();
$post = $_POST;
/* Para manter a compatibilidade com versões antigas */
$table = "equipxpieces";
$clausule = $QRY['componentexequip_ini'];
$sqlTest = "SELECT * FROM {$table}";
try {
$conn->query($sqlTest);
}
catch (Exception $e) {
$table = "equipXpieces";
$clausule = $QRY['componenteXequip_ini'];
}
$terms = "";
$criteria = array();
$criterText = "";
$badgeClass = "badge badge-info p-2 mb-1";
$badgeClassEmptySearch = "badge badge-danger p-2 mb-1";
$imgsPath = "../../includes/imgs/";
$config = getConfig($conn);
/* Unidade */
$field_label = TRANS('COL_UNIT');
$post_field_sufix = "unidade";
$sql_column = "inst.inst_cod";
$field_table = "instituicao";
$field_id = "inst_cod";
$field_name = "inst_nome";
/* Controle para o caso da área ter limitação para visualização de apenas algumas unidades */
$hasLimitationByAllowedUnits = false;
if (!empty($_SESSION['s_allowed_units'])) {
$hasLimitationByAllowedUnits = true;
$terms .= " AND inst.inst_cod IN ({$_SESSION['s_allowed_units']}) ";
}
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Etiqueta */
$field_label = TRANS('ASSET_TAG');
$post_field_sufix = "etiqueta";
$sql_column = "e.estoq_tag_inv";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$tmp = explode(',', (string)$post[$post_field_sufix]);
// $treatValues = array_map('intval', $tmp);
$treatValues = array_map('noHtml', $tmp);
$tagIN = "";
foreach ($treatValues as $tag) {
if (strlen((string)$tagIN)) $tagIN .= ", ";
$tag = trim($tag);
$tagIN .= "'{$tag}'";
}
$terms .= " AND {$sql_column} IN ({$tagIN}) ";
$criterText = $field_label . ": {$tagIN}
";
$criteria[] = "{$criterText}";
}
/* Tipo de componente */
$field_label = TRANS('COL_TYPE');
$post_field_sufix = "equip_type";
$sql_column = "e.estoq_tipo";
$field_table = "itens";
$field_id = "item_cod";
$field_name = "item_nome";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Fabricante */
$field_label = TRANS('COL_MANUFACTURER');
$post_field_sufix = "manufacturer";
$sql_column = "fab.fab_cod";
$field_table = "fabricantes";
$field_id = "fab_cod";
$field_name = "fab_nome";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Modelo */
$field_label = TRANS('COL_MODEL');
$post_field_sufix = "model";
$sql_column = "e.estoq_desc";
$field_table = "modelos_itens";
$field_id = "mdit_cod";
$field_name = "mdit_desc"; /* mdit_desc_capacidade, mdit_sufixo */
$field_name2 = "mdit_desc_capacidade"; /* mdit_desc_capacidade, mdit_sufixo */
$field_name3 = "mdit_sufixo"; /* mdit_desc_capacidade, mdit_sufixo */
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name}, {$field_name2}, {$field_name3} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name] . " " . $rowCriter[$field_name2] . " " . $rowCriter[$field_name3];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Serial number */
$field_label = TRANS('SERIAL_NUMBER');
$post_field_sufix = "serial_number";
$sql_column = "e.estoq_sn";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$tmp = explode(',', (string)$post[$post_field_sufix]);
// $treatValues = array_map('intval', $tmp);
$treatValues = array_map('noHtml', $tmp);
$tagIN = "";
foreach ($treatValues as $tag) {
if (strlen((string)$tagIN)) $tagIN .= ", ";
$tag = trim($tag);
$tagIN .= "'{$tag}'";
}
$terms .= " AND {$sql_column} IN ({$tagIN}) ";
$criterText = $field_label . ": {$tagIN}
";
$criteria[] = "{$criterText}";
}
/* Part-number */
$field_label = TRANS('COL_PARTNUMBER');
$post_field_sufix = "part_number";
$sql_column = "e.estoq_partnumber";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$tmp = explode(',', (string)$post[$post_field_sufix]);
// $treatValues = array_map('intval', $tmp);
$treatValues = array_map('noHtml', $tmp);
$tagIN = "";
foreach ($treatValues as $tag) {
if (strlen((string)$tagIN)) $tagIN .= ", ";
$tag = trim($tag);
$tagIN .= "'{$tag}'";
}
$terms .= " AND {$sql_column} IN ({$tagIN}) ";
$criterText = $field_label . ": {$tagIN}
";
$criteria[] = "{$criterText}";
}
/* Departamento */
$field_label = TRANS('DEPARTMENT');
$post_field_sufix = "departamento";
$sql_column = "e.estoq_local";
$field_table = "localizacao";
$field_id = "loc_id";
$field_name = "local";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Situação */
$field_label = TRANS('STATE');
$post_field_sufix = "condition";
$sql_column = "e.estoq_situac";
$field_table = "situacao";
$field_id = "situac_cod";
$field_name = "situac_nome";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Fornecedores */
$field_label = TRANS('COL_VENDOR');
$post_field_sufix = "supplier";
$sql_column = "e.estoq_vendor";
$field_table = "fornecedores";
$field_id = "forn_cod";
$field_name = "forn_nome";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Centro de Custo */
$field_label = TRANS('COST_CENTER');
$post_field_sufix = "cost_center";
$sql_column = "e.estoq_ccusto";
$db_name = DB_CCUSTO;
$field_table = TB_CCUSTO;
$field_id = CCUSTO_ID;
$field_name = CCUSTO_DESC;
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$db_name}.{$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Nota Fiscal */
$field_label = TRANS('INVOICE_NUMBER');
$post_field_sufix = "invoice_number";
$sql_column = "e.estoq_nf";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$tmp = explode(',', (string)$post[$post_field_sufix]);
// $treatValues = array_map('intval', $tmp);
$treatValues = array_map('noHtml', $tmp);
$tagIN = "";
foreach ($treatValues as $tag) {
if (strlen((string)$tagIN)) $tagIN .= ", ";
$tag = trim($tag);
$tagIN .= "'{$tag}'";
}
$terms .= " AND {$sql_column} IN ({$tagIN}) ";
$criterText = $field_label . ": {$tagIN}
";
$criteria[] = "{$criterText}";
}
/* Assistência - Criar Campo*/
$field_label = TRANS('ASSISTENCE');
$post_field_sufix = "assistance";
$sql_column = "e.estoq_assist";
$field_table = "assistencia";
$field_id = "assist_cod";
$field_name = "assist_desc";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Tipo de garantia - adicionar campo */
$field_label = TRANS('FIELD_TYPE_WARRANTY');
$post_field_sufix = "warranty_type";
$sql_column = "e.estoq_warranty_type";
$field_table = "tipo_garantia";
$field_id = "tipo_garant_cod";
$field_name = "tipo_garant_nome";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} != '-1' AND {$sql_column} != '0' AND {$sql_column} IS NOT NULL AND {$sql_column} != '') ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} = '-1' OR {$sql_column} = '0' OR {$sql_column} IS NULL OR {$sql_column} = '' ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$fieldIn = "";
foreach ($post[$post_field_sufix] as $field) {
if (strlen((string)$fieldIn)) $fieldIn .= ",";
$fieldIn .= $field;
}
$terms .= " AND {$sql_column} IN ({$fieldIn}) ";
$criterText = "";
$sqlCriter = "SELECT {$field_name} FROM {$field_table} WHERE {$field_id} in ({$fieldIn}) ORDER BY {$field_name}";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter[$field_name];
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Garantia */
$field_label = TRANS('WARRANTY_STATUS');
$post_field_sufix = "warranty_status";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND (e.estoq_data_compra IS NOT NULL AND e.estoq_data_compra IS NOT NULL) ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND (e.estoq_data_compra IS NULL OR e.estoq_data_compra IS NULL) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$criterText = "";
if ($post[$post_field_sufix] == 1) {
$terms .= " AND (date_add(e.estoq_data_compra, INTERVAL t.tempo_meses month) >= now()) ";
$criterText .= TRANS('UNDER_WARRANTY');
} elseif ($post[$post_field_sufix] == 2) {
$terms .= " AND (date_add(e.estoq_data_compra, INTERVAL t.tempo_meses month) < now()) ";
$criterText .= TRANS('SEL_GUARANTEE_EXPIRED');
}
$criterText = $field_label . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
if (isset($post['only_relatives']) && !empty($post['only_relatives'])) {
$criterText = TRANS('SMART_ONLY_IN_EQUIPMENT') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['no_relatives']) && !empty($post['no_relatives'])) {
$criterText = TRANS('SMART_ONLY_OUT_OF_EQUIPMENT') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
/* Data mínima de aquisição */
$field_label = TRANS('SMART_MIN_PURCHASE_DATE');
$post_field_sufix = "purchase_date_from";
$sql_column = "e.estoq_data_compra";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} IS NOT NULL ) ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} IS NULL ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$date_from = "";
$date_from = $post[$post_field_sufix] . " 00:00:00";
$date_from = dateDB($date_from);
$terms .= " AND ( {$sql_column} >= '{$date_from}' ) ";
$criterText = $field_label . ": " . $post[$post_field_sufix] . "
";
$criteria[] = "{$criterText}";
}
/* Data máxima de aquisição */
$field_label = TRANS('SMART_MAX_PURCHASE_DATE');
$post_field_sufix = "purchase_date_to";
$sql_column = "e.estoq_data_compra";
if (isset($post['no_empty_' . $post_field_sufix]) && $post['no_empty_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} IS NOT NULL ) ";
$criterText = $field_label . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_' . $post_field_sufix]) && $post['no_' . $post_field_sufix] == 1) {
$terms .= " AND ( {$sql_column} IS NULL ) ";
$criterText = $field_label . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$post_field_sufix]) && !empty($post[$post_field_sufix])) {
$date_from = "";
$date_from = $post[$post_field_sufix] . " 23:59:59";
$date_from = dateDB($date_from);
$terms .= " AND ( {$sql_column} <= '{$date_from}' ) ";
$criterText = $field_label . ": " . $post[$post_field_sufix] . "
";
$criteria[] = "{$criterText}";
}
if (empty($terms)) {
$criterText = TRANS('SMART_WITHOUT_SEARCH_CRITERIA') . "
";
$criteria[] = "{$criterText}";
}
// echo $terms;
// $sql = $QRY["ocorrencias_full_ini"] . " WHERE 1 = 1 {$terms} ORDER BY numero";
// $sql = $QRY["full_detail_ini"];
// $sql = $QRY["componentexequip_ini"];
$sql = $clausule;
$sql .= $terms;
// $sql .= $QRY["full_detail_fim"];
$sql .= " ORDER BY i.item_nome, e.estoq_desc";
$sqlResult = $conn->query($sql);
$totalFiltered = $sqlResult->rowCount();
$criterios = "";
?>
| # | = TRANS('COL_TYPE'); ?> | = TRANS('COL_MANUFACTURER'); ?> | = TRANS('COL_MODEL'); ?> | = TRANS('ASSET_TAG'); ?> | = TRANS('COL_UNIT'); ?> | = TRANS('SERIAL_NUMBER'); ?> | = TRANS('COL_PARTNUMBER'); ?> | = TRANS('COL_EQUIP'); ?> | = TRANS('DEPARTMENT'); ?> | = TRANS('STATE'); ?> | = TRANS('COL_VENDOR'); ?> | = TRANS('COST_CENTER'); ?> | = TRANS('INVOICE_NUMBER'); ?> | = TRANS('ASSISTENCE'); ?> | = TRANS('FIELD_TYPE_WARRANTY'); ?> | = TRANS('PURCHASE_DATE'); ?> |
| = "" . $i . ""; ?> | = $row['item_nome'] ; ?> | = $row['fab_nome'] ; ?> | = $row['modelo'] ; ?> | = $row['estoq_tag_inv']; ?> | = $row['inst_nome'] ; ?> | = $row['estoq_sn'] ; ?> | = $row['estoq_partnumber'] ; ?> | = "" . $equipUnit . $equipTag . ""; ?> | = $row['local'] ; ?> | = $row['situac_nome'] ; ?> | = $row['forn_nome'] ; ?> | = $cost_center ; ?> | = $row['estoq_nf'] ; ?> | = $row['assistencia'] ; ?> | = $row['tipo_garantia'] ; ?> | = dateScreen($row['estoq_data_compra'], 1) ; ?> |