$value)
$_GET[$key] = str_replace(array("'",'"'),array('',''),$value);
foreach ($_POST as $key => $value)
$_POST[$key] = str_replace(array("'",'"'),array('',''),$value);
$strTipoValidacion = isset($_REQUEST["op"]) ? $_REQUEST["op"] : '';
switch($strTipoValidacion) {
case "genera_meses":
include_once ("conexion.inc.php");
//iniciarConexionVUS();
$sql="SELECT DISTINCT adm_con_mes FROM adm_control_{$_POST['tipo']}, adm_control_{$_POST['tipo']}_etapas WHERE
adm_con_numsol = adm_coe_numsol AND
adm_con_tpt_id = adm_coe_tpt_id AND
adm_con_tpr_id = adm_coe_tpr_id AND
adm_coe_tpe_id = '07' AND adm_con_prnlst = 2 AND adm_coe_status IN (4) AND adm_con_mes ILIKE '%".$_POST['adm_con_mes']."%' ORDER BY adm_con_mes";
// echo $sql."
";
$result=$connection->Execute($sql);
if (!$result->EOF) {
while ( !$result->EOF ) {
$operador = $result->fields;
echo "";
$result->MoveNext ();
}
} else {
echo "";
}
die();
break;
case 'security_number':
//include_once ("conexion.inc.php");
function generarCodigo($longitud) {
$key = '';
$pattern = '1234567890';
$max = strlen($pattern)-1;
for($i=0;$i < $longitud;$i++) $key .= $pattern{mt_rand(0,$max)};
return $key;
}
ob_start();
include_once ('settings.php');
ob_end_clean();
$res['stat'] = 0;
$res['avoid'] = 0;
while ($res['stat'] == 0 || $res['avoid'] > 5) {
$res['rnd'] = generarCodigo(8);
//da de baja a otros tokens que esten habilitados
$sql = "update ctg_security_numbers set ctg_sec_valid = '3' where ctg_sec_valid = '2' AND ctg_sec_user = '{$_POST["usr"]}'";
$result = $connection->Execute($sql);
//crea nuevo token
$sql = "insert into ctg_security_numbers (ctg_sec_id, ctg_sec_number, ctg_sec_user, ctg_sec_date, ctg_sec_date_exp, ctg_sec_valid) values (nextval('ctg_security_numbers_ctg_sec_id'),'{$res['rnd']}','{$_POST["usr"]}', NOW(), NOW() + (30 ||' minutes')::interval, '2' )";
$result = $connection->Execute($sql);
$res['sql'] = $sql;
$res['stat'] = $connection->Affected_Rows();
$res['error'] = $connection->ErrorMsg();
$res['avoid']++;
}
if ($res['stat'] == 0 && $res['avoid'] > 5) { //problemas
echo json_encode($res);
die();
} else { //generar email
$sql="select * from adm_usuarios where adm_usr_ci = '{$_POST["usr"]}'";
$result=$connection->Execute($sql);
$error = $connection->ErrorMsg();
if (!$result->EOF) {
$operador = $result->fields;
$emails="";
if (!empty($operador['adm_usr_email_inhrr']))
$emails=$operador['adm_usr_email_inhrr'];
if (!empty($operador['adm_usr_email_per'])) {
if (!empty($emails))
$emails .=", ".$operador['adm_usr_email_per'];
else
$emails =$operador['adm_usr_email_per'];
}
//adm_usr_nme1 adm_usr_nme2 adm_usr_ape1 adm_usr_ape2
$subject = "SIVERC - Verificacion de Seguridad";
$body = "Codigo de Acceso: {$res['rnd']}
";
ob_start();
include_once ('settings.php');
ob_end_clean();
//$res["send"] = mail_attachment($operador['adm_usr_nombre'], "", $operador['adm_usr_email_inhrr'], $operador['adm_usr_email_per'], "", "", $subject, $body);
$res["send"] = mail_attachment($operador['adm_usr_nombre'], "", $emails, "", "", "", $subject, $body);
}
}
echo json_encode($res);
die();
break;
case 'security_number_validator':
$res['stat'] = -1;
if (empty($_POST["ctg_sec_number"])) {
echo json_encode($res);
die();
}
include_once ("conexion.inc.php");
$res['stat'] = 0;
$sql = "select ctg_sec_valid, extract(epoch from (now() - ctg_sec_date_exp)) / 60 as minutes from ctg_security_numbers where ctg_sec_number = '{$_POST["ctg_sec_number"]}' and ctg_sec_user = '{$_POST["usr"]}'";
$res['sql'] = $sql;
$result=$connection->Execute($sql);
$error = $connection->ErrorMsg();
if (!$result->EOF) {
$operador = $result->fields;
if ($operador['ctg_sec_valid'] == 2) {
if ($operador['minutes'] < 2) {
//marca el codigo ya utilizado
$sql = "update ctg_security_numbers set ctg_sec_valid = '1' where ctg_sec_valid = '2' AND ctg_sec_user = '{$_POST["usr"]}' AND ctg_sec_number = '{$_POST["ctg_sec_number"]}' ";
$result = $connection->Execute($sql);
$res['stat'] = 1;
if (substr($_POST['optmenu'],0,6)=='030207') {
switch ($_POST['optmenu']){
case '030207':
case '03020701':
$sqlt="UPDATE adm_usuarios SET adm_usr_tok1='{$_POST["ctg_sec_number"]}', adm_usr_tok1_dt = now() WHERE adm_usr_ci ='{$_POST["usr"]}' ";
$resultt = $connection->Execute($sqlt);
break;
case '03020702':
$sqlt="UPDATE adm_usuarios SET adm_usr_tok2='{$_POST["ctg_sec_number"]}', adm_usr_tok2_dt = now() WHERE adm_usr_ci ='{$_POST["usr"]}' ";
$resultt = $connection->Execute($sqlt);
break;
case '03020703':
$sqlt="UPDATE adm_usuarios SET adm_usr_tok3='{$_POST["ctg_sec_number"]}', adm_usr_tok3_dt = now() WHERE adm_usr_ci ='{$_POST["usr"]}' ";
$resultt = $connection->Execute($sqlt);
break;
}
}
} else {
$res['stat'] = 2;
if (substr($_POST['optmenu'],0,6)=='030207') {
switch ($_POST['optmenu']){
case '030207':
case '03020701':
$sqlt="UPDATE adm_usuarios SET adm_usr_tok1='', adm_usr_tok1_dt='1900-01-01 00:00:00' WHERE adm_usr_ci ='{$_POST["usr"]}' ";
$resultt = $connection->Execute($sqlt);
break;
case '03020702':
$sqlt="UPDATE adm_usuarios SET adm_usr_tok2='', adm_usr_tok2_dt='1900-01-01 00:00:00' WHERE adm_usr_ci ='{$_POST["usr"]}' ";
$resultt = $connection->Execute($sqlt);
break;
case '03020703':
$sqlt="UPDATE adm_usuarios SET adm_usr_tok3='', adm_usr_tok3_dt='1900-01-01 00:00:00' WHERE adm_usr_ci ='{$_POST["usr"]}' ";
$resultt = $connection->Execute($sqlt);
break;
}
}
}
} else {
$res['stat'] = 3;
}
}
echo json_encode($res);
die();
break;
case 'save_casillas':
ob_start();
include_once ("conexion.inc.php");
//include_once ('settings.php');
ob_end_clean();
$res = array();
$go = false;
if ( $_POST['field'] == "adm_con_nomprod") {
echo "por aqui
";
$conn = $connection;
// ACTUALIZO TABLA DE adm_control
$sqlt="UPDATE adm_control_{$_POST['tipo']} SET adm_con_nomprod='".$_POST['value']."' WHERE adm_con_numsol = '{$_POST['codigo']}' AND adm_con_tpt_id = '{$_POST['tpt']}' AND adm_con_tpr_id = '{$_POST['tpr']}'";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
$sqlt="UPDATE adm_control_{$_POST['tipo']}1 SET adm_con_nomprod='".$_POST['value']."' WHERE adm_con_numsol = '{$_POST['codigo']}' AND adm_con_tpt_id = '{$_POST['tpt']}' AND adm_con_tpr_id = '{$_POST['tpr']}'";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
iniciarConexionVUS();
$conn = $connectionVUS;
// ACTUALIZO TABLA DE vus_tramites
$sqlt="UPDATE vus_tramites_{$_POST['tipo']}2 SET vus_{$_POST['tipo']}_nomprod='{$_POST['value']}' WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['tpt']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['tpr']}'";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
$res['stat'] = $conn->Affected_Rows();
} else {
echo "por ACA
";
if ( $_POST['field'] != "adm_con_nomprod") $go = true;
if ( $_POST['field'] == "adm_con_issdate" || $_POST['field'] == "adm_{$_POST['tipo']}_vencim" ) {
$go = strtotime($_POST['value']);
$_POST['value'] = date("Y-m-d",strtotime($_POST['value']));
}
if ($_POST['db'] == "vus") {
iniciarConexionVUS();
$conn = $connectionVUS;
}
else
$conn = $connection;
if ($go){
$table = "{$_POST['tabla']}{$_POST['tipo']}{$_POST['dtb']}";
$set = "{$_POST['field']} = '".trim($_POST['value'])."'";
switch(trim($_POST['tabla'])){
case 'adm_control_':
$complementos = ", adm_con_dt = 'now()', adm_con_sta = '2', adm_con_usr = '{$_POST['usr']}' ";
$where = "adm_con_numsol = '{$_POST['codigo']}' AND adm_con_tpt_id = '{$_POST['tpt']}' AND adm_con_tpr_id = '{$_POST['tpr']}'";
break;
case 'ctg_productos_':
$complementos = ", adm_{$_POST['tipo']}_dt = 'now()', adm_{$_POST['tipo']}_sta = '2', adm_{$_POST['tipo']}_usr = '{$_POST['usr']}' ";
$where = "adm_{$_POST['tipo']}_numreg = '{$_POST['numreg']}' AND adm_{$_POST['tipo']}_tpr_id = '{$_POST['tpr']}'";
$set = "adm_{$_POST['tipo']}_autori= date '".trim($_POST['value'])."', {$_POST['field']} = date '".trim($_POST['value'])."' + interval '5 year'";
break;
case 'vus_tramites_':
$complementos = ", vus_{$_POST['tipo']}_dt = 'now()', vus_{$_POST['tipo']}_sta = '2', vus_{$_POST['tipo']}_usr = '{$_POST['usr']}' ";
$where = "vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['tpt']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['tpr']}'";
break;
case 'lab_control_qc_tecnicos':
$table = $_POST['tabla'];
$complementos = ", lab_cot_dt = 'now()', lab_cot_sta = '2', lab_cot_usr = '{$_POST['usr']}' ";
$where = "lab_cot_numsol = '".$_POST['codigo']."' AND
lab_cot_tpt_id = '".$_POST['tpt']."' AND
lab_cot_tpr_id = '".$_POST['tpr']."' AND
lab_cot_arm_id = '".$_POST['ctg_arm_id']."' AND
lab_cot_esa_id = '".$_POST['ctg_esa_id']."' AND
lab_cot_asi_usr = '".$_POST['lab_cot_asi_usr']."'";
break;
}
$sql="UPDATE $table SET $set $complementos WHERE $where";
$sql = str_replace("\\","",$sql);
$result = $conn->Execute($sql);
$res['sql'] = $sql;
$res['stat'] = $conn->Affected_Rows();
$res['error'] = $conn->ErrorMsg();
if ( trim($_POST['tabla']) == 'ctg_productos_' ) {
$num_id='0';
$vencimdt='';
$newnumreg='';
$sql="SELECT adm_{$_POST['tipo']}_id, adm_{$_POST['tipo']}_vencim FROM ctg_productos_{$_POST['tipo']} WHERE adm_{$_POST['tipo']}_numreg = '{$_POST['numreg']}'";
$result2 = $conn->Execute($sql);
if (!$result2->EOF) {
$operador = $result2->fields;
$num_id=$operador["adm_".$_POST['tipo']."_id"];
$vencimdt=$operador["adm_".$_POST['tipo']."_vencim"];
if (substr($_POST['numreg'],0,1) =="R")
$numreg=substr($_POST['numreg'],5,10);
else
$numreg=substr($_POST['numreg'],4,10);
$newnumreg=substr($vencimdt,2,2).substr($vencimdt,5,2).$numreg;
$_POST['numreg']=$newnumreg;//NUEVO NUMERO DE REGISTRO
iniciarConexionVUS();
// ACTUALIZO TABLA DE vus_tramites
$sqlt="UPDATE vus_tramites_{$_POST['tipo']}1 SET vus_{$_POST['tipo']}_numreg='{$newnumreg}' WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id='{$_POST['tpt']}' AND vus_{$_POST['tipo']}_tpr_id='{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $connectionVUS->Execute($sqlt);
if ($connectionVUS->Affected_Rows() == 0) {
$sqlt="UPDATE vus_tramites_{$_POST['tipo']}2 SET vus_{$_POST['tipo']}_numreg='{$newnumreg}' WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id='{$_POST['tpt']}' AND vus_{$_POST['tipo']}_tpr_id='{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $connectionVUS->Execute($sqlt);
}
switch ($_POST['tipo']) {
case 'ef':{
// ACTUALIZO TABLA DE ctg_productos
$sqlt="UPDATE ctg_productos_{$_POST['tipo']} SET adm_{$_POST['tipo']}_numreg='{$newnumreg}' WHERE adm_{$_POST['tipo']}_id = '{$num_id}' AND adm_{$_POST['tipo']}_tpr_id = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_CPC
$sqlt="UPDATE \"ctg_productos_{$_POST['tipo']}_CPC\" SET \"adm_{$_POST['tipo']}CPC_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}CPC_id\" = '{$num_id}' AND \"adm_{$_POST['tipo']}CPC_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_DOCs
$sqlt="UPDATE \"ctg_productos_{$_POST['tipo']}_DOCs\" SET \"adm_{$_POST['tipo']}DOC_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}DOC_idr\" = '{$num_id}' AND \"adm_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_EMPRESAS
$sqlt="UPDATE \"ctg_productos_{$_POST['tipo']}_EMPRESAS\" SET \"adm_{$_POST['tipo']}EMP_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}EMP_id\" = '{$num_id}' AND \"adm_{$_POST['tipo']}EMP_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_EMPRESASreg
$sqlt="UPDATE \"ctg_productos_{$_POST['tipo']}_EMPRESASreg\" SET \"adm_{$_POST['tipo']}EMPreg_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}EMPreg_id\" = '{$num_id}' AND \"adm_{$_POST['tipo']}EMPreg_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_files
$sqlt="UPDATE ctg_productos_{$_POST['tipo']}_files SET adm_{$_POST['tipo']}fil_numreg='{$newnumreg}' WHERE adm_{$_POST['tipo']}fil_idr = '{$num_id}' AND adm_{$_POST['tipo']}fil_tpr_id = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_FIT
$sqlt="UPDATE \"ctg_productos_{$_POST['tipo']}_FIT\" SET \"adm_{$_POST['tipo']}FIT_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}FIT_id\" = '{$num_id}' AND \"adm_{$_POST['tipo']}FIT_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_formula
$sqlt="UPDATE ctg_productos_{$_POST['tipo']}_formula SET \"adm_{$_POST['tipo']}FOR_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}FOR_idr\" = '{$num_id}' AND \"adm_{$_POST['tipo']}FOR_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_formulareg
$sqlt="UPDATE ctg_productos_{$_POST['tipo']}_formulareg SET \"adm_{$_POST['tipo']}FOR_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}FOR_idr\" = '{$num_id}' AND \"adm_{$_POST['tipo']}FOR_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_historia
$sqlt="UPDATE ctg_productos_{$_POST['tipo']}_historia SET \"adm_{$_POST['tipo']}HIS_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}HIS_id\" = '{$num_id}' AND \"adm_{$_POST['tipo']}HIS_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_mensajes
$sqlt="UPDATE ctg_productos_{$_POST['tipo']}_mensajes SET adm_{$_POST['tipo']}msg_numreg='{$newnumreg}' WHERE adm_{$_POST['tipo']}msg_idr = '{$num_id}' AND adm_{$_POST['tipo']}msg_tpr_id = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_public_files
$sqlt="UPDATE ctg_productos_{$_POST['tipo']}_public_files SET adm_{$_POST['tipo']}pub_numreg='{$newnumreg}' WHERE adm_{$_POST['tipo']}pub_idr = '{$num_id}' AND adm_{$_POST['tipo']}pub_tpr_id = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_SEC
$sqlt="UPDATE \"ctg_productos_{$_POST['tipo']}SEC\" SET \"adm_{$_POST['tipo']}SEC_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}SEC_id\" = '{$num_id}' AND \"adm_{$_POST['tipo']}SEC_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_SECinf
$sqlt="UPDATE \"ctg_productos_{$_POST['tipo']}SECinf\" SET \"adm_{$_POST['tipo']}SECi_numreg\"='{$newnumreg}' WHERE \"adm_{$_POST['tipo']}SECi_idr\" = '{$num_id}' AND \"adm_{$_POST['tipo']}SECt_tpr_id\" = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
// ACTUALIZO TABLA DE ctg_productos_tramite
$sqlt="UPDATE ctg_productos_{$_POST['tipo']}_tramite SET adm_{$_POST['tipo']}_tpt_numreg='{$newnumreg}' WHERE adm_{$_POST['tipo']}_tpt_idr = '{$num_id}' AND adm_{$_POST['tipo']}_tpr_id = '{$_POST['tpr']}' ";
$res['sql'] .= $sqlt."
";
$resultt = $conn->Execute($sqlt);
break;
}
default:
# code...
break;
}
}
}
}
}
//$res['l'] = strtotime($_POST['value']);
echo json_encode($res);
die();
break;
case "genera_pdf":
include_once('html2pdf/html2pdf.php');
die();
break;
case "update_prnlst":
$res = array();
$res['sql'] = '';
$res['msg'] = '';
$res['stat'] = 0;
ob_start();
include_once ('settings.php');
ob_end_clean();
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_obs = '".date("Y-m-d H:i:s")."',
adm_con_prnlst = 2,
adm_con_mes = '".$_POST['dac_date']."',
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_con_prnlst = 1";
$result = $connection->Execute($sql);
$error = $connection->ErrorMsg();
$res['sql'] = $sql;
$res['msg'] = $error;
$res['stat'] = $connection->Affected_Rows();
echo json_encode($res);
die();
break;
case "update_prnlst1":
$res = array();
$res['sql'] = '';
$res['msg'] = '';
$res['stat'] = 0;
ob_start();
include_once ('settings.php');
ob_end_clean();
$filter='';
$str = "0,";
switch ($_REQUEST["idmenu"]) {
case '030207':
case '03020701':
case '03020702':
case '03020703':
$filter="adm_con_tpt_action='1'";
break;
case '0302A0701':
case '0302A0702':
$filter="adm_con_tpt_action='2'";
break;
case '0302B0701':
case '0302B0702':
$filter="adm_con_tpt_action IN ('3','9')";
break;
}
$sql1 = "select adm_con_numsol,
adm_con_prnlst,
adm_con_usr,
adm_con_dt,
adm_con_tpt_action
FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}, adm_control_{$_POST['tipo']}_etapas
WHERE
adm_con_numsol = adm_coe_numsol AND
adm_con_tpt_id = adm_coe_tpt_id AND
adm_con_tpr_id = adm_coe_tpr_id AND
adm_coe_tpe_id = '07' AND adm_con_prnlst <> 2 AND adm_coe_status IN (3,4) AND ".$filter;
$result=$connection->Execute($sql1);
$error = $connection->ErrorMsg();
if (!$result->EOF) {
while ( !$result->EOF ) {
$operador = $result->fields;
$str .= $operador['adm_con_numsol'].",";
$result->MoveNext();
}
}
$str = substr($str,0,-1);
$sql2="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_prnlst = 1,
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_con_numsol IN ($str) AND adm_con_prnlst <> 2";
$result = $connection->Execute($sql2);
$error = $connection->ErrorMsg();
$res['sql'] = $sql1;
$res['msg'] = $error;
$res['stat'] = $connection->Affected_Rows();
//$res['stat'] = 1;
echo json_encode($res);
die();
break;
case "print_list":
ob_start();
include_once ('settings.php');
$content = ob_get_clean();
$str = "0,";
$text = file_get_contents(dirname(__FILE__)."\\".$_POST['file']);
$arr_report = json_decode($text);
foreach ($arr_report as $i => $row) {
if ($row->item == 2)
$str .= $row->numsol.",";
}
$str = substr($str,0,-1);
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_obs = '".date("Y-m-d H:i:s")."',
adm_con_prnlst = 2,
adm_con_mes = '".$_POST['dac_date']."',
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_con_numsol IN ($str)";
//$result = $connection->Execute($sql);
$error = $connection->ErrorMsg();
$res['sql'] = $sql;
$res['msg'] = $error;
$res['stat'] = $connection->Affected_Rows();
$res['stat'] = 1;
echo json_encode($res);
die();
break;
case "verifica_elementos2":
$file = dirname(__FILE__)."\\".$_GET['file'];
file_put_contents("030207_json2.txt","");
$text = file_get_contents($file);
$arr_report = json_decode($text);
$ant = -1;
$arr_tmp = array();
$arrsi = array();
foreach ($arr_report as $row) {
switch($row->item) {
case 0:
$head = $row;
break;
case 1:
$str = $row->numsol;
$row1 = $row;
break;
case 2: {
if ($ant != intval($row->status)) {
if ($ant != -1) {
$arr_tmp[] = $head;
}
$arr_tmp[] = $head;
$arr_tmp[] = $row1;
$ant = intval($row->status);
}
$arr_tmp[] = $row;
}
break;
}
}
if (count($arr_tmp) > 0) {
$string = json_encode($arr_tmp);
$string = str_replace("},","},\n",$string);
file_put_contents("030207_json2.txt",$string);
}
$res['count'] = count($arr_tmp);
$res['file'] = $file;
echo json_encode($res);
die();
break;
case "no_need_loq":
include_once ("conexion.inc.php");
include_once ("settings.php");
$res = array();
$res['sql'] = '';
$res['msg'] = '';
$res['stat'] = 0;
iniciarConexionVUS();
/// ACTUALIZO TRAMITE Y GENERO BOLETA
$sql = "UPDATE adm_control_{$_REQUEST['tipopro']}
SET adm_con_nloqg='1', adm_con_jarepo = '1', adm_con_jadate='".Date("Y-m-d")."'
WHERE adm_con_numsol = '".$_REQUEST['solinum']."' AND
adm_con_tpt_id = '".$_REQUEST['tipo']."' AND
adm_con_tpr_id = '".$_REQUEST['prod']."' ";
$connection->Execute($sql);
if ($_REQUEST['optbuttom']==1) {
$sql="UPDATE vus_tramites_{$_REQUEST['tipopro']}_dates SET
vus_{$_REQUEST['tipopro']}_dat_dt08 = now()
WHERE
vus_{$_REQUEST['tipopro']}_dat_numsol = '{$_REQUEST['solinum']}' AND vus_{$_REQUEST['tipopro']}_dat_column='3'";
$result=$connectionVUS->Execute($sql);
} else {
$sql="UPDATE vus_tramites_{$_REQUEST['tipopro']}_dates SET
vus_{$_REQUEST['tipopro']}_dat_dt09 = now()
WHERE
vus_{$_REQUEST['tipopro']}_dat_numsol = '{$_REQUEST['solinum']}' AND vus_{$_REQUEST['tipopro']}_dat_column='3'";
$result=$connectionVUS->Execute($sql);
}
$res['stat'] = 1;
echo json_encode($res);
die();
break;
}
ob_start();
include_once ('settings.php');
$quien=0;
$_POST['tabla'] = $_POST['tabla'].$_POST['tipo'];
$_POST['catalogo_prefijo'] = $_POST['catalogo_prefijo'];
if (empty($_SESSION['dtb_vus'])) $_SESSION['dtb_vus'] = $_POST['session_vus'];
if (empty($_SESSION['dtb_adm'])) $_SESSION['dtb_adm'] = $_POST['session_adm'];
if ($_POST['op'] == "hay_vus_tramites2") {
ob_clean();
$respuesta = array();
$respuesta['res'] = 0;
iniciarConexionVUS();
$sql = "SELECT vus_{$_POST['tipo']}_numreg FROM vus_tramites_{$_POST['tipo']}2 WHERE vus_{$_POST['tipo']}_numsol='{$_POST['numsol']}' AND vus_{$_POST['tipo']}_tpt_id='{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id='{$_POST['ctg_tpr_id']}'";
//echo $sql."
";
$respuesta['sql'] = $sql;
$ret=$connectionVUS->Execute($sql);
if (!$ret->EOF) {
$respuesta['res'] = 1;
}
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "valida_doc") {
ob_clean();
$respuesta = array();
$respuesta['res'] = 0;
iniciarConexionVUS();
$sql = "SELECT * FROM ctg_tipo_tramites_documentos WHERE ctg_ttd_id = '{$_POST['id']}' AND ctg_ttc_id = '{$_POST['ttc_id']}' AND ctg_tpt_id = '{$_POST['ctg_tpt_id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' LIMIT 1";
//echo $sql;
$ret=$connection->Execute($sql);
$respuesta['sql1'] = $sql;
if (!$ret->EOF) {
$respuesta['res'] = 1;
}
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "CambiosPostRegistro") { //caso especifico resultado_final_4_4.php
ob_clean();
$respuesta = array();
//$_POST['adm_con_certxt1'] = htmlspecialchars($_POST['adm_con_certxt1']);
//$_POST['adm_con_certxt2'] = htmlspecialchars($_POST['adm_con_certxt2']);
$sql="UPDATE adm_control_{$_POST['tipo']}1 SET
adm_con_certxt1 = '{$_POST['adm_con_certxt1']}',
adm_con_certxt2 = '{$_POST['adm_con_certxt2']}',
adm_con_cerlins = '{$_POST['adm_con_cerlins']}'
WHERE adm_con_numsol = '{$_POST['codigo']}' AND adm_con_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_con_tpr_id = '{$_POST['ctg_tpr_id']}'";
//echo $sql."
";
$result = $connection->Execute ($sql);
$respuesta['sql'] = $sql;
$respuesta['affected'] = $connection->Affected_Rows();
$respuesta['error'] = $connection->ErrorMsg();
/*
$respuesta['token'] = strtotime("now");
$texto = $_POST["per"] . "**||**" . $_POST["con"];
file_put_contents($respuesta['token'],$texto);
*/
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "certificado_docname") {
ob_clean();
$respuesta = array();
$respuesta['nombre'] = "";
$respuesta['parte'] = "";
iniciarConexionVUS();
$sql = "SELECT vus_{$_POST['tipo']}_numreg, vus_{$_POST['tipo']}_fec_cre, vus_{$_POST['tipo']}_est_id FROM vus_tramites_{$_POST['tipo']}2 WHERE vus_{$_POST['tipo']}_numsol='{$_POST['numsol']}'";
//echo $sql."
";
$ret=$connectionVUS->Execute($sql);
if ($ret->fields["vus_{$_POST['tipo']}_fec_cre"]) {
list($fecha,$hora) = explode(" ",$ret->fields["vus_{$_POST['tipo']}_fec_cre"]);
list($anio,$mes,$dia) = explode("-",$fecha);
$numreg = $ret->fields["vus_{$_POST['tipo']}_numreg"];
}
$respuesta['numreg'] = $numreg;
$parte = 1;
$adm_cod_tmf_cor = 1;
$registro = "";
$sql="SELECT * FROM ctg_tipo_tramites_formatos WHERE ctg_tpd_id = '{$_POST['id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}' AND ctg_tpt_id = '{$_POST['tpt_id']}'";
//echo $sql."
";
$result_=$connection->Execute($sql);
if (!$result_->EOF) {
$sql = "SELECT ctg_fmt_sig, ctg_fmt_cor, ctg_fmt_nom, ctg_fmt_fec, ctg_fmt_ver FROM ctg_tipo_formatos WHERE ctg_fmt_id = '{$_POST['id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}'";
$result_=$connection->Execute($sql);
if (!$result_->EOF) {
$adm_cod_tmf_cor = intval($result_->fields["ctg_fmt_cor"]) + 1;
$respuesta['registro'] = "{$result_->fields["ctg_fmt_sig"]}
{$result_->fields["ctg_fmt_fec"]}
{$result_->fields["ctg_fmt_ver"]}";
}
}
if ($ip_int==$ip_ext){
$path = "/html";
} else {
$path = "/html";
}
//if ($_POST["ip_int"] != "190.56.146.14")
//$path = "/var/www"; 2015-10-14
if ($_POST['EsCertificado'] == 1) {
$path .= "/{$_POST['location_adm']}/docs/{$_POST['tipo']}";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
$path .= "/$numreg";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
$path .= "/0";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
$sql = "SELECT * FROM adm_control_{$_POST['tipo']}1_docs WHERE adm_cod_numreg = '$numreg' AND adm_cod_numsol = '{$_POST['numsol']}' AND adm_cod_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = '{$_POST['ttc_id']}' AND adm_cod_tmf_id = '{$_POST['id']}'";
// echo $sql."
";
//$respuesta['este_es'] = $sql;
$respuesta['sql'] = $sql;
$result=$connection->Execute($sql);
if (intval($result->fields["adm_cod_part"]) > 0) {
$parte = intval($result->fields["adm_cod_part"]);
$adm_cod_tmf_cor = $result->fields["adm_cod_tmf_cor"];
} else {
$sql = "SELECT \"adm_{$_POST['tipo']}DOC_part\" FROM \"ctg_productos_{$_POST['tipo']}_DOCs\" WHERE
\"adm_{$_POST['tipo']}DOC_numreg\" = '$numreg' AND
\"adm_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND
\"adm_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND
\"adm_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND
\"adm_{$_POST['tipo']}DOC_numsol\" = '0' AND
\"adm_{$_POST['tipo']}DOC_id\" = '{$_POST['id']}'
ORDER BY \"adm_{$_POST['tipo']}DOC_part\" DESC LIMIT 1";
//echo $sql."
";
$ret=$connection->Execute($sql);
$respuesta['sql1'] = $sql;
if (!$ret->EOF) {
$adm_cod_part = intval($ret->fields["adm_{$_POST['tipo']}DOC_part"])+1;
}
}
$respuesta['path'] = "$path";
$respuesta['nombre'] = "{$_POST['tipo']}_{$numreg}_{$_POST['ttc_id']}-{$_POST['id']}_$parte.pdf";
} else {
if ($ip_int==$ip_ext){
$path .= "/html/".str_replace("adm", "", $_POST['location_adm']);
} else {
$path .= "/html/".str_replace("adm", "", $_POST['location_adm']);
}
$sql="SELECT ctg_tpr_resu_loc FROM ctg_tipo_productos WHERE ctg_tpr_id='{$_POST['ctg_tpr_id']}'";
//echo $sql."
";
$respuesta['sql2'] = $sql;
$row=$connection->Execute($sql);
if (!$row->EOF) {
$path .= $row->fields['ctg_tpr_resu_loc'];
}
$path .= "docs_tramites";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
$path .= "/{$_POST['tipo']}";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
//echo "($files_path)
";
$path .= "/$anio";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
//echo "($files_path)
";
$path .= "/$mes";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
//echo "($files_path)
";
$path .= "/{$_POST['ctg_tpt_id']}_{$_POST['numsol']}";
@ mkdir("/var/www$path",7777);
shell_exec("chmod 7777 /var/www$path");
//echo "($files_path)
";
$respuesta['path'] = "$path";
$respuesta['nombre'] = "{$_POST['tipo']}_{$_POST['ctg_tpt_id']}_{$_POST['numsol']}_{$_POST['ttc_id']}_{$_POST['id']}_1.pdf";
}
$respuesta['parte'] = $parte;
$respuesta['adm_cod_tmf_cor'] = $adm_cod_tmf_cor;
$respuesta['is_dir'] = is_dir("/var/www$path");
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "certificado_docname_save") {
ob_clean();
$respuesta = array();
$respuesta['error'] = 0;
$inserta = false;
$update = false;
function tamano_archivo($peso, $decimales = 2 ) {
$clase = array(" Bytes", " KB", " MB", " GB", " TB");
try {
$res = round($peso/pow(1024,($i = floor(log($peso, 1024)))),$decimales ); //$clase[$i];
} catch (Exception $e) {
$res = 0;
}
return $res;
}
$iFile = "/var/www".$_POST['path']."/".$_POST['name'];
if (is_file($iFile))
$peso_archivo = filesize($iFile); // obtenemos su peso en bytes
else {
$respuesta['file'] = $iFile;
$respuesta['error'] = 1;
echo json_encode($respuesta);
die();
}
$num_id='';
$sql = "SELECT adm_{$_POST['tipo']}_id FROM ctg_productos_{$_POST['tipo']} WHERE adm_{$_POST['tipo']}_numreg = '{$_POST['numreg']}' ";
$respuesta['sql'] = $sql;
$result=$connection->Execute($sql);
if (!$result->EOF) {
$num_id = $result->fields[0];
}
$_POST['size'] = tamano_archivo($peso_archivo);
$_POST['path']=str_replace("/html/adm","",$_POST['path']);
if ($_POST['EsCertificado'] == 1) {
//$_POST['numsol'] = 0;
$sql = "SELECT * FROM \"ctg_productos_{$_POST['tipo']}_DOCs\" WHERE \"adm_{$_POST['tipo']}DOC_numreg\" = '{$_POST['numreg']}' AND \"adm_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"adm_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"adm_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND \"adm_{$_POST['tipo']}DOC_numsol\" = '0' AND \"adm_{$_POST['tipo']}DOC_id\" = '{$_POST['id']}' AND \"adm_{$_POST['tipo']}DOC_part\" = '{$_POST['parte']}'";
//echo $sql."
";
$respuesta['sql'] = $sql;
$result=$connection->Execute($sql);
if (!$result->EOF) {
$sql = "UPDATE \"ctg_productos_{$_POST['tipo']}_DOCs\" SET
\"adm_{$_POST['tipo']}DOC_doc_name\" = '{$_POST['name']}',
\"adm_{$_POST['tipo']}DOC_doc_desc\" = '{$_POST['name_desc']}',
\"adm_{$_POST['tipo']}DOC_docubi\" = '{$_POST['path']}',
\"adm_{$_POST['tipo']}DOC_size\" = '{$_POST['size']}',
\"adm_{$_POST['tipo']}DOC_sta\" = 2,
\"adm_{$_POST['tipo']}DOC_usr\" = '{$_SESSION['ADMusuario_id']}',
\"adm_{$_POST['tipo']}DOC_dt\" = now()
WHERE
\"adm_{$_POST['tipo']}DOC_numreg\" = '{$_POST['numreg']}' AND
\"adm_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND
\"adm_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND
\"adm_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND
\"adm_{$_POST['tipo']}DOC_numsol\" = '0' AND
\"adm_{$_POST['tipo']}DOC_id\" = '{$_POST['id']}' AND
\"adm_{$_POST['tipo']}DOC_part\" = '{$_POST['parte']}'";
$respuesta['sql1'] = $sql;
$result=$connection->Execute($sql);
$respuesta['error1'] = $connection->ErrorMsg();
$respuesta['affected1'] = $connection->Affected_Rows();
if ($respuesta['affected1'] == 1)
$update = true;
} else {
$sql = "INSERT INTO \"ctg_productos_{$_POST['tipo']}_DOCs\" (
\"adm_{$_POST['tipo']}DOC_idr\",
\"adm_{$_POST['tipo']}DOC_numreg\",
\"adm_{$_POST['tipo']}DOC_tpt_id\",
\"adm_{$_POST['tipo']}DOC_tpr_id\",
\"adm_{$_POST['tipo']}DOC_ttc_id\",
\"adm_{$_POST['tipo']}DOC_numsol\",
\"adm_{$_POST['tipo']}DOC_id\",
\"adm_{$_POST['tipo']}DOC_part\",
\"adm_{$_POST['tipo']}DOC_doc_name\",
\"adm_{$_POST['tipo']}DOC_doc_desc\",
\"adm_{$_POST['tipo']}DOC_docubi\",
\"adm_{$_POST['tipo']}DOC_size\",
\"adm_{$_POST['tipo']}DOC_sta\",
\"adm_{$_POST['tipo']}DOC_usr\",
\"adm_{$_POST['tipo']}DOC_dt\" ) VALUES (
'{$num_id}','{$_POST['numreg']}','{$_POST['ctg_tpt_id']}','{$_POST['ctg_tpr_id']}','{$_POST['ttc_id']}','0','{$_POST['id']}','{$_POST['parte']}','{$_POST['name']}','{$_POST['name_desc']}','{$_POST['path']}','{$_POST['size']}','1','{$_SESSION['ADMusuario_id']}',now())";
$respuesta['sql1'] = $sql;
$result=$connection->Execute($sql);
$respuesta['error1'] = $connection->ErrorMsg();
$respuesta['affected1'] = $connection->Affected_Rows();
if ($respuesta['affected1'] == 1)
$inserta = true;
}
} else {
iniciarConexionVUS();
$sql = "SELECT * FROM \"vus_tramites_{$_POST['tipo']}2_DOCs\" WHERE \"vus_{$_POST['tipo']}DOC_numsol\" = '{$_POST['numsol']}' AND \"vus_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND \"vus_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND \"vus_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND \"vus_{$_POST['tipo']}DOC_ttd_id\" = '{$_POST['id']}' AND \"vus_{$_POST['tipo']}DOC_ttd_part\" = '{$_POST['parte']}'";
$respuesta['sql'] = $sql;
$result=$connectionVUS->Execute($sql);
if (!$result->EOF) {
$sql = "UPDATE \"vus_tramites_{$_POST['tipo']}2_DOCs\" SET
\"vus_{$_POST['tipo']}DOC_doc_name\" = '{$_POST['name']}',
\"vus_{$_POST['tipo']}DOC_doc_desc\" = '{$_POST['name_desc']}',
\"vus_{$_POST['tipo']}DOC_docubi\" = '{$_POST['path']}',
\"vus_{$_POST['tipo']}DOC_size\" = '{$_POST['size']}',
\"vus_{$_POST['tipo']}DOC_sta\" = '2',
\"vus_{$_POST['tipo']}DOC_usr\" = '{$_SESSION['ADMusuario_id']}',
\"vus_{$_POST['tipo']}DOC_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}DOC_numsol\" = '{$_POST['numsol']}' AND
\"vus_{$_POST['tipo']}DOC_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND
\"vus_{$_POST['tipo']}DOC_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND
\"vus_{$_POST['tipo']}DOC_ttc_id\" = '{$_POST['ttc_id']}' AND
\"vus_{$_POST['tipo']}DOC_ttd_id\" = '{$_POST['id']}' AND
\"vus_{$_POST['tipo']}DOC_ttd_part\" = '{$_POST['parte']}'";
$respuesta['sql2'] = $sql;
$result=$connectionVUS->Execute($sql);
$respuesta['error2'] = $connectionVUS->ErrorMsg();
$respuesta['affected2'] = $connectionVUS->Affected_Rows();
if ($respuesta['affected2'] == 1)
$update = true;
$respuesta['update'] = $update;
} else {
$sql = "INSERT INTO \"vus_tramites_{$_POST['tipo']}2_DOCs\" (
\"vus_{$_POST['tipo']}DOC_numsol\",
\"vus_{$_POST['tipo']}DOC_tpt_id\",
\"vus_{$_POST['tipo']}DOC_tpr_id\",
\"vus_{$_POST['tipo']}DOC_ttc_id\",
\"vus_{$_POST['tipo']}DOC_ttd_id\",
\"vus_{$_POST['tipo']}DOC_ttd_part\",
\"vus_{$_POST['tipo']}DOC_doc_name\",
\"vus_{$_POST['tipo']}DOC_doc_desc\",
\"vus_{$_POST['tipo']}DOC_docubi\",
\"vus_{$_POST['tipo']}DOC_size\",
\"vus_{$_POST['tipo']}DOC_sta\",
\"vus_{$_POST['tipo']}DOC_usr\",
\"vus_{$_POST['tipo']}DOC_dt\" ) VALUES (
'{$_POST['numsol']}','{$_POST['ctg_tpt_id']}','{$_POST['ctg_tpr_id']}','{$_POST['ttc_id']}','{$_POST['id']}','{$_POST['parte']}','{$_POST['name']}','{$_POST['name_desc']}','{$_POST['path']}','{$_POST['size']}','1','{$_SESSION['ADMusuario_id']}',now())
";
$respuesta['sql2'] = $sql;
$result=$connectionVUS->Execute($sql);
$respuesta['error2'] = $connectionVUS->ErrorMsg();
$respuesta['affected2'] = $connectionVUS->Affected_Rows();
if ($respuesta['affected2'] == 1)
$inserta = true;
}
}
$sql = "SELECT * FROM adm_control_{$_POST['tipo']}1_docs WHERE adm_cod_numreg = '{$_POST['numreg']}' AND adm_cod_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = '{$_POST['ttc_id']}' AND adm_cod_numsol = '0' AND adm_cod_tmf_id = '{$_POST['id']}' AND adm_cod_part = '{$_POST['parte']}'";
//echo $sql."
";
$respuesta['sql'] = $sql;
$result=$connection->Execute($sql);
if (!$result->EOF) {
$inserta=false;
} else {
$inserta=true;
}
if ($inserta == true) {
$sql = "INSERT INTO adm_control_{$_POST['tipo']}1_docs (
adm_cod_numsol,
adm_cod_numreg,
adm_cod_tpr_id,
adm_cod_tpt_id,
adm_cod_ttc_id,
adm_cod_tmf_id,
adm_cod_tec_id,
adm_cod_tmf_cor,
adm_cod_part,
adm_cod_path,
adm_cod_file,
adm_cod_sta,
adm_cod_usr,
adm_cod_dt ) VALUES (
'{$_POST['numsol']}',
'{$_POST['numreg']}',
'{$_POST['ctg_tpr_id']}',
'{$_POST['ctg_tpt_id']}',
'{$_POST['ttc_id']}',
'{$_POST['id']}',
'{$_SESSION['ADMusuario_id']}',
'{$_POST['adm_cod_tmf_cor']}',
'{$_POST['parte']}',
'{$_POST['path']}',
'{$_POST['name']}',
'1',
'{$_SESSION['ADMusuario_id']}',
now())";
// echo "sql3 (".$sql.")";
$respuesta['sql3'] = $sql;
$result=$connection->Execute($sql);
$respuesta['error3'] = $connection->ErrorMsg();
$respuesta['affected3'] = $connection->Affected_Rows();
$sql = "UPDATE ctg_tipo_formatos SET ctg_fmt_cor = {$_POST['adm_cod_tmf_cor']} WHERE ctg_fmt_id = '{$_POST['id']}' AND ctg_tpr_id = '{$_POST['ctg_tpr_id']}'";
$respuesta['sql4'] = $sql;
$result=$connection->Execute($sql);
$respuesta['error4'] = $connection->ErrorMsg();
$respuesta['affected4'] = $connection->Affected_Rows();
}
if ($update == true) {
$sql = "UPDATE adm_control_{$_POST['tipo']}1_docs SET
adm_cod_path = '{$_POST['path']}',
adm_cod_file = '{$_POST['name']}',
adm_cod_sta = '2',
adm_cod_usr = '{$_SESSION['ADMusuario_id']}',
adm_cod_dt = now()
WHERE
adm_cod_numsol = '{$_POST['numsol']}' AND
adm_cod_numreg = '{$_POST['numreg']}' AND
adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND
adm_cod_tpt_id = '{$_POST['ctg_tpt_id']}' AND
adm_cod_ttc_id = '{$_POST['ttc_id']}' AND
adm_cod_tmf_id = '{$_POST['id']}' AND
adm_cod_part = '{$_POST['parte']}'
";
// echo "sql3 (".$sql.")";
$respuesta['sql3'] = $sql;
$result=$connection->Execute($sql);
$respuesta['error3'] = $connection->ErrorMsg();
$respuesta['affected3'] = $connection->Affected_Rows();
}
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "certificado_send") {
ob_clean();
$respuesta = array();
$sql = "SELECT ctg_tpr_id, ctg_tpr_desc, ctg_tpr_email, ctg_tpr_email1, ctg_tpr_email2, ctg_tpr_email3, ctg_tpr_email4 FROM ctg_tipo_productos WHERE ctg_tpr_id = '{$_POST['ctg_tpr_id']}'";
$respuesta["sql1"] = $sql;
$res1=$connection->Execute($sql);
if (!$res1->EOF) {
$_POST['ctg_tpr_desc'] = $res1->fields[1];
$_POST['ctg_tpr_email'] = "";
if (!empty($res1->fields[2])) $_POST['ctg_tpr_email'] .= $res1->fields[2].",";
if (!empty($res1->fields[3])) $_POST['ctg_tpr_email'] .= $res1->fields[3].",";
if (!empty($res1->fields[4])) $_POST['ctg_tpr_email'] .= $res1->fields[4].",";
if (!empty($res1->fields[5])) $_POST['ctg_tpr_email'] .= $res1->fields[5].",";
if (!empty($res1->fields[6])) $_POST['ctg_tpr_email'] .= $res1->fields[6].",";
if (!empty($_POST['ctg_tpr_email'])) $_POST['ctg_tpr_email'] = substr($_POST['ctg_tpr_email'],0,-1);
}
iniciarConexionVUS();
$sql = "SELECT * FROM vus_tramites_{$_POST["tipo"]}2 WHERE
vus_{$_POST["tipo"]}_numsol = '".$_POST["codigo"]."' AND
vus_{$_POST["tipo"]}_tpt_id = '".$_POST["tpt_id"]."' AND
vus_{$_POST["tipo"]}_tpr_id = '".$_POST["ctg_tpr_id"]."'";
//echo "$sql
";
$respuesta["sql2"] = $sql;
$result_1=$connectionVUS->Execute($sql);
if (!$result_1->EOF) {
$operador_1 = $result_1->fields;
$_POST['nomprod'] = $operador_1["vus_{$_POST["tipo"]}_nomprod"];
$_POST['numreg'] = $operador_1["vus_{$_POST["tipo"]}_numreg"];
$status = $operador_1["vus_{$_POST["tipo"]}_est_id"];
$sql = "SELECT ctg_tpt_id, ctg_tpt_desc FROM ctg_tipo_tramites WHERE ctg_tpt_id = '{$operador_1["vus_{$_POST["tipo"]}_tpt_id"]}' AND ctg_tpr_id = '{$operador_1["vus_{$_POST["tipo"]}_tpr_id"]}'";
$respuesta["sql3"] = $sql;
$res1=$connection->Execute($sql);
if (!$res1->EOF) {
//$_POST['ctg_tpt_id'] = $res1->fields[0];
$_POST['ctg_tpt_desc'] = $res1->fields[1];
}
$sql = "SELECT * FROM ctg_productos_{$_POST["tipo"]} WHERE adm_{$_POST["tipo"]}_numreg = '{$operador_1["vus_{$_POST["tipo"]}_numreg"]}' AND ctg_tpr_id = '{$operador_1["vus_{$_POST["tipo"]}_tpr_id"]}'";
$respuesta["sql3"] = $sql;
$res1=$connection->Execute($sql);
if (!$res1->EOF) {
//$_POST['ctg_tpt_id'] = $res1->fields[0];
$_POST['fecvenc'] = $res1->fields[6];
}
$sql = "SELECT vus_usr_nombre, vus_usr_email FROM vus_usuarios WHERE vus_usr_id = '{$operador_1["vus_{$_POST["tipo"]}_usr_id"]}'";
$respuesta["sql4"] = $sql;
$res1=$connectionVUS->Execute($sql);
$respuesta["sql2"] = $sql;
if (!$res1->EOF) {
$_POST['nombre'] = $res1->fields[0];
$_POST['email'] = $res1->fields[1];//",dcdfdammemails@gmail.com";
}
}
$arr_label[317]='tramite_no';
$arr_label[10]='tipo_producto';
$arr_label[54]='tipo_tramite';
$arr_label[316]='doc_nombre';
$arr_label[14]='comentarios';
$arr_label[324]='parte';
$arr_label[366]='cambio_status';
$arr_label[367]='faltante';
$arr_label[368]='se_cambio_status';
$arr_label[369]='a';
$arr_label[84]='nombre_producto';
$arr_label[511] = 'genero_boleta';
$arr_label[1919] = 'model17_part1';
$arr_label[1920] = 'model17_part2';
$arr_label[1374] = 'model16_part1';
$arr_label[1375] = 'model16_part2';
$arr_label[1376] = 'model16_part3';
$arr_lang = "317,10,54,316,14,324,366,367,368,369,84,511,1919,1920,1374,1375,1376";
include ('form_language.php');
$subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo'];
if( $status == 9) {
$_POST['fecha'] = date("Y-m-d");
$fechaven= suma_fechas($_POST['fecha'],90);//recibe en formato d-m-Y y retorna Y-m-d
$body = "Date: ".date("d-m-Y")."
";
$body .= $arr_label['estimado']." ".$_POST['nombre'].",
";
$body .= $arr_label['tramite_no'].":".$_POST['codigo']."
";
$body .= $arr_label['nombre_producto'].":".$_POST['nomprod'];//.", ".$_POST['forma'].", ".$_POST['strength'].", ".$_POST['presenta'];
$body .= "
".$arr_label['model17_part1']." ".$arr_label['model17_part2']."
";
} else {
$body = "Date: ".date("d-m-Y")."
";
$body .= $arr_label['estimado']." ".$_POST['nombre'].",
";
$body .= $arr_label['tramite_no'].":".$_POST['codigo']."
";
$body .= $arr_label['nombre_producto'].":".$_POST['nomprod'];//.", ".$_POST['forma'].", ".$_POST['strength'].", ".$_POST['presenta'];
$body .= "
".$arr_label['model16_part1']."
".$arr_label['model16_part2']."
".$arr_label['model16_part3']."
";
}
$subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo'];
$content = email_tpl($arr_label['informacion_tramite'],$body);
$headers = "From: $soporte <$company_email3>\nReply-To: $soporte <$company_email3>\nContent-Type: text/html; charset=UTF-8";
$respuesta["subject"] = $subject;
$respuesta["body"] = $body;
$my_name = "$soporte";
$my_mail = $company_email3;
$my_replyto = $company_email3;
$file_complete="";
$sql= "SELECT adm_cod_path, adm_cod_file FROM adm_control_".$_POST['tipo']."1_docs WHERE
adm_cod_numsol = '".$_POST["codigo"]."' AND
adm_cod_tpt_id = 'AO' AND
adm_cod_tpr_id = '".$_POST["ctg_tpr_id"]."' AND
adm_cod_ttc_id = 'DR' AND adm_cod_tmf_id = '{$_POST['id']}'";
// echo $sql."
";
$result=$connection->Execute($sql);
if (!$result->EOF){
$tmp_file=$result->fields[0].$result->fields[1];
$remote_dir = "/var/www/html/siverc".$location_adm.$tmp_file;
$local_dir = "/var/www/html/siverc".$location_adm."/temp/";
// echo "remote ({$remote_dir}) local ({$local_dir})";
shell_exec("cp -rf $remote_dir $local_dir");
$file_loq=$remote_dir;
$file2=$local_dir.$result->fields[1];
$file1=str_replace("/", "", $result->fields[1]);
}
$sql="SELECT adm_cnf_email_asoc8 FROM adm_config";
$email_asoc8="";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$email_asoc8=$result->fields[0];
}
$send1 = mail_attachment($file1 ,$file2, $email_asoc8, $my_mail, $my_name, $my_replyto, $subject, $content);
$respuesta["send"] = mail_attachment($file1 ,$file2, $_POST['email'], $my_mail, $my_name, $my_replyto, $subject, $content);
$respuesta["insert"] = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod'],$_POST['email'],$subject,$body,$respuesta["send"],"");
echo json_encode($respuesta);
die();
}
//ctg_tipo_tramites_documentos
if ($_POST['op'] == "certificado_send_save") {
ob_clean();
$respuesta = array();
//if ($_POST['EsCertificado'] == 1) $_POST['ctg_tpt_id'] = "AO";
iniciarConexionVUS();
$sql = "SELECT vus_{$_POST['tipo']}_numreg, vus_{$_POST['tipo']}_fec_cre, vus_{$_POST['tipo']}_est_id FROM vus_tramites_{$_POST['tipo']}2 WHERE vus_{$_POST['tipo']}_numsol='{$_POST['codigo']}'";
//echo $sql."
";
$ret=$connectionVUS->Execute($sql);
if ($ret->fields["vus_{$_POST['tipo']}_fec_cre"]) {
$numreg = $ret->fields["vus_{$_POST['tipo']}_numreg"];
}
$sql = "SELECT * FROM adm_control_{$_POST['tipo']}1_docs WHERE adm_cod_numreg = '$numreg' AND adm_cod_numsol = '{$_POST['codigo']}' AND adm_cod_tpt_id = 'AO' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = 'DR' AND adm_cod_tmf_id = '{$_POST['id']}'"; // AND adm_cod_part = '{$_POST['parte']}'
// echo $sql."
";
//$respuesta['este_es'] = $sql;
$respuesta['sql'] = $sql;
$result=$connection->Execute($sql);
if (intval($result->fields["adm_cod_part"]) > 0) {
$sql = "UPDATE adm_control_{$_POST['tipo']}1_docs SET adm_cod_email = 1, adm_cod_email_sent='".date("Y-m-d H:i:s")."' WHERE adm_cod_numreg = '$numreg' AND adm_cod_numsol = '{$_POST['codigo']}' AND adm_cod_tpt_id = 'AO' AND adm_cod_tpr_id = '{$_POST['ctg_tpr_id']}' AND adm_cod_ttc_id = 'DR' AND adm_cod_tmf_id = '{$_POST['id']}'";
$respuesta['sql3'] = $sql;
$result=$connection->Execute($sql);
$respuesta['error3'] = $connection->ErrorMsg();
$respuesta['affected3'] = $connection->Affected_Rows();
}
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "firmae"){
ob_clean();
$respuesta = array();
$sql="SELECT adm_cnf_cdvcor FROM adm_config";
//echo $sql."
";
$result = $connection->Execute ($sql);
$corr = intval($result->fields[0]) + 1;
$respuesta['correlativo'] = $corr;
$corr = sprintf("%06d",$corr);
$respuesta['codigo'] = "#".strtoupper($_POST['ctg_tpt_id'] . $corr[0] . $_POST['pais'][0] . $corr[1] . $_POST['tipo'] . $corr[2] . $_POST['pais'][1] . $corr[3] . $_POST['codigo'] . $corr[4] . $_POST['pais'][2] . $corr[5] . date("Y"))."#";
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "guarda_firmae"){
ob_clean();
iniciarConexionVUS();
$sql2="";
$sql1= "SELECT vus_{$_POST['tipo']}_numreg FROM vus_tramites_{$_POST['tipo']}2 WHERE vus_".$_POST['tipo']."_numsol='".$_POST['codigo']."'";
$result1=$connectionVUS->Execute($sql1);
if (!$result1->EOF) {
$numreg = $result1->fields[0];
if ($numreg!=''){
$sql2="UPDATE ctg_productos_{$_POST['tipo']} SET adm_".$_POST['tipo']."_cdv = '{$_POST['firmae_cod']}' WHERE adm_".$_POST['tipo']."_numreg = '{$numreg}' ";
$result2 = $connection->Execute ($sql2);
}
}
$respuesta = array();
$sql="UPDATE adm_control_{$_POST['tipo']}1 SET adm_con_cdv = '{$_POST['firmae_cod']}' WHERE adm_con_numsol = '{$_POST['codigo']}' AND adm_con_tpt_id = '{$_POST['ctg_tpt_id']}' AND adm_con_tpr_id = '{$_POST['ctg_tpr_id']}'";
//echo $sql."
";
$result = $connection->Execute ($sql);
$sql="UPDATE adm_config SET adm_cnf_cdvcor = '{$_POST['firmae_cor']}'";
//echo $sql."
";
$result = $connection->Execute ($sql);
$respuesta['sql'] = $sql2;
$respuesta['affected'] = $connection->Affected_Rows();
$respuesta['error'] = $connection->ErrorMsg();
echo json_encode($respuesta);
die();
}
if ($_POST['op'] == "GuardaDatosCosultaEmails") { //2015-12-07
ob_clean();
$respuestam = array();
iniciarConexionVUS();
switch ($_POST['opcion']) {
case "03050501": //a. Extension de Plazo de vencimiento
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\"
SET
\"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
\"vus_{$_POST['tipo']}MSG_sta\" = '2',
\"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}MSG_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}'
AND \"vus_{$_POST['tipo']}MSG_falsta\" = '1'
AND \"vus_{$_POST['tipo']}MSG_tipo\" = '{$_POST['msg_tipo']}'";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
break;
case "03050502": //b. Recuperar Rechazadas por la FDA
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\"
SET
\"vus_{$_POST['tipo']}MSG_falsta\" = '1',
\"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
\"vus_{$_POST['tipo']}MSG_sta\" = '2',
\"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}MSG_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}'
AND \"vus_{$_POST['tipo']}MSG_falsta\" = '2'
AND \"vus_{$_POST['tipo']}MSG_tipo\" = '1'";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
$sql="UPDATE vus_tramites_{$_POST['tipo']}3
SET
vus_{$_POST['tipo']}_est_id = '1',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' ";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
break;
case "03050505": //b. Recuperar Rechazadas automaticamente por el sistema
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\"
SET
\"vus_{$_POST['tipo']}MSG_falsta\" = '1',
\"vus_{$_POST['tipo']}MSG_autrej\" = '0',
\"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
\"vus_{$_POST['tipo']}MSG_sta\" = '2',
\"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}MSG_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}'
AND \"vus_{$_POST['tipo']}MSG_falsta\" = '2'
AND \"vus_{$_POST['tipo']}MSG_tipo\" = '1'";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
$sql="UPDATE vus_tramites_{$_POST['tipo']}3
SET
vus_{$_POST['tipo']}_est_id = '1',
vus_{$_POST['tipo']}_autrej = '0',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}'";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
break;
case "03050506": //b. Recuperar Rechazadas automaticamente por el sistema por no entregar el archivo fisico a tiempo
$sql="UPDATE vus_tramites_{$_POST['tipo']}3
SET
vus_{$_POST['tipo']}_est_id = '5',
vus_{$_POST['tipo']}_autrej = '0',
vus_{$_POST['tipo']}_fislim = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}'";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
break;
case "03050601": //a. Extension de Plazo de vencimiento
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\"
SET
\"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
\"vus_{$_POST['tipo']}MSG_sta\" = '2',
\"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}MSG_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}'
AND \"vus_{$_POST['tipo']}MSG_tpe_id\" = '{$_POST['etapa_id']}'
AND \"vus_{$_POST['tipo']}MSG_falsta\" = '1'
AND \"vus_{$_POST['tipo']}MSG_tipo\" = '{$_POST['msg_tipo']}'";
// echo "(".$sql.")";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
break;
case "03050602": //b. Recuperar rechazadas
// $sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\"
// SET
// \"vus_{$_POST['tipo']}MSG_falsta\" = '1',
// \"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
// \"vus_{$_POST['tipo']}MSG_sta\" = '2',
// \"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."',
// \"vus_{$_POST['tipo']}MSG_dt\" = now()
// WHERE
// \"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}'
// AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}'
// AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}'
// AND \"vus_{$_POST['tipo']}MSG_falsta\" = '2'
// AND \"vus_{$_POST['tipo']}MSG_tipo\" = '2'";
// $connectionVUS->Execute($sql);
// $respuesta['sql'] = $sql;
// $respuesta['error'] = $connectionVUS->ErrorMsg();
// $respuesta['Affected'] = $connectionVUS->Affected_Rows();
$tipo=1;
$sql="SELECT vus_{$_POST['tipo']}_boleta FROM vus_tramites_{$_POST['tipo']}3
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}'
AND vus_{$_POST['tipo']}_est_id = '7' ";
// echo "(".$sql.")
";
$result=$connectionVUS->Execute($sql);
if (!$result->EOF) {
if (intval($result1->fields[0])>0)
$tipo=2;
}
if ($tipo==1){
$sql="UPDATE vus_tramites_{$_POST['tipo']}3
SET
vus_{$_POST['tipo']}_est_id = '1',
vus_{$_POST['tipo']}_autrej = '0',
vus_{$_POST['tipo']}_faltante = '0',
vus_{$_POST['tipo']}_numfal = '0',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' ";
// echo "(".$sql.")
";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
} else {
$sql="UPDATE vus_tramites_{$_POST['tipo']}3
SET
vus_{$_POST['tipo']}_est_id = '8',
vus_{$_POST['tipo']}_autrej = '0',
vus_{$_POST['tipo']}_boleta = '0',
vus_{$_POST['tipo']}_numbol = '0',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' ";
// echo "(".$sql.")
";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
$sql="UPDATE adm_control_{$_POST['tipo']}1
SET
adm_con_estatus = '0',
adm_con_rf_status = '0',
adm_con_rf_dt = NULL,
adm_con_rf_usr ='NULL,
adm_con_sta = '2',
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = now()
WHERE adm_con_numsol = '{$_POST['etapa_numsol']}'
AND adm_con_tpt_id = '{$_POST['etapa_tpt']}'
AND adm_con_tpr_id = '{$_POST['etapa_tpr']}' ";
// echo "(".$sql.")
";
$connection->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
$sql="UPDATE adm_control_{$_POST['tipo']}_etapas
SET
adm_coe_status = '1',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = now()
WHERE adm_coe_numsol = '{$_POST['etapa_numsol']}'
AND adm_coe_tpt_id = '{$_POST['etapa_tpt']}'
AND adm_coe_tpr_id = '{$_POST['etapa_tpr']}' ";
// echo "(".$sql.")
";
$connection->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
}
break;
case "03050503": //c. Habilitar cerrados faltantes
$sql="UPDATE vus_tramites_{$_POST['tipo']}
SET
vus_{$_POST['tipo']}_faltante = '1',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' ";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\"
SET
\"vus_{$_POST['tipo']}MSG_falsta\" = '1',
\"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
\"vus_{$_POST['tipo']}MSG_sta\" = '2',
\"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}MSG_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}'
AND \"vus_{$_POST['tipo']}MSG_tipo\" = '1'
AND \"vus_{$_POST['tipo']}MSG_falsta\"='2'";
$connectionVUS->Execute($sql);
$respuesta['sql1'] = $sql;
$respuesta['error1'] = $connectionVUS->ErrorMsg();
$respuesta['Affected1'] = $connectionVUS->Affected_Rows();
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_CHKl\"
SET
\"vus_{$_POST['tipo']}CHK_res1_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_res2_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_res10_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_sta\" = '2',
\"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}CHK_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'";
$connectionVUS->Execute($sql);
$respuesta['sql3'] = $sql;
$respuesta['error3'] = $connectionVUS->ErrorMsg();
$respuesta['Affected3'] = $connectionVUS->Affected_Rows();
break;
case "03050603": //c. Habilitar cerradas boleta
$sql="UPDATE vus_tramites_{$_POST['tipo']}1
SET
vus_{$_POST['tipo']}_boleta = '1',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['etapa_numsol']}'
AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['etapa_tpt']}'
AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['etapa_tpr']}' ";
$connectionVUS->Execute($sql);
$respuesta['sql'] = $sql;
$respuesta['error'] = $connectionVUS->ErrorMsg();
$respuesta['Affected'] = $connectionVUS->Affected_Rows();
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_MENSAJES\"
SET
\"vus_{$_POST['tipo']}MSG_falsta\" = '1',
\"vus_{$_POST['tipo']}MSG_fecven\" = '".date("Y-m-d",strtotime($_POST['msg_fecven']))."',
\"vus_{$_POST['tipo']}MSG_sta\" = '2',
\"vus_{$_POST['tipo']}MSG_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}MSG_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}MSG_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}MSG_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}MSG_tpr_id\" = '{$_POST['etapa_tpr']}'
AND \"vus_{$_POST['tipo']}MSG_tipo\" = '{$_POST['msg_tipo']}'
AND \"vus_{$_POST['tipo']}MSG_tipo\" = '2'
AND \"vus_{$_POST['tipo']}MSG_falsta\"='2'";
$connectionVUS->Execute($sql);
$respuesta['sql1'] = $sql;
$respuesta['error1'] = $connectionVUS->ErrorMsg();
$respuesta['Affected1'] = $connectionVUS->Affected_Rows();
$sql = "UPDATE adm_control_{$_POST['tipo']}_etapas
SET adm_coe_bolespres = 1
WHERE
adm_coe_numsol = '{$_POST['etapa_numsol']}'
AND adm_coe_tpt_id = '{$_POST['etapa_tpt']}'
AND adm_coe_tpr_id = '{$_POST['etapa_tpr']}'
AND adm_coe_tpe_id = '{$_POST['etapa']}'";
$connection->Execute($sql);
$respuesta['sql2'] = $sql;
$respuesta['error2'] = $connection->ErrorMsg();
$respuesta['Affected2'] = $connection->Affected_Rows();
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}1_CHKl\"
SET
\"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_sta\" = '2',
\"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}CHK_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'";
$connectionVUS->Execute($sql);
$respuesta['sql3'] = $sql;
$respuesta['error3'] = $connectionVUS->ErrorMsg();
$respuesta['Affected3'] = $connectionVUS->Affected_Rows();
break;
case "03050504": //d. Habilitar documentos FALTANTES
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_CHKl\"
SET
\"vus_{$_POST['tipo']}CHK_res1_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res1_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res1_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_res2_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res2_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res2_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_res10_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res10_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res10_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_sta\" = '2',
\"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}CHK_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'";
$connectionVUS->Execute($sql);
$respuesta['sql3'] = $sql;
$respuesta['error3'] = $connectionVUS->ErrorMsg();
$respuesta['Affected3'] = $connectionVUS->Affected_Rows();
break;
case "03050604": //d. Habilitar documentos BOLETAS
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}1_CHKl\"
SET
\"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" = CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" IS NULL THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE
CASE WHEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_obs\" = '' THEN \"vus_{$_POST['tipo']}CHK_res".(intval($_POST['etapa'])+2)."_aut\" ELSE 1 END
END,
\"vus_{$_POST['tipo']}CHK_sta\" = '2',
\"vus_{$_POST['tipo']}CHK_usr\" = '".$_SESSION['ADMusuario_id']."',
\"vus_{$_POST['tipo']}CHK_dt\" = now()
WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '{$_POST['etapa_numsol']}'
AND \"vus_{$_POST['tipo']}CHK_tpt_id\" = '{$_POST['etapa_tpt']}'
AND \"vus_{$_POST['tipo']}CHK_tpr_id\" = '{$_POST['etapa_tpr']}'";
$connectionVUS->Execute($sql);
$respuesta['sql3'] = $sql;
$respuesta['error3'] = $connectionVUS->ErrorMsg();
$respuesta['Affected3'] = $connectionVUS->Affected_Rows();
break;
}
//usuario propietario de solicitud
switch ($_POST['opcion']) {
case '03050501':
$arr_label[1637]='model_part1';
$arr_label[1638]='model_part2';
$vus_tabla="";
break;
case '03050502':
$arr_label[1540]='model_part1';
$arr_label[1638]='model_part2';
$vus_tabla="";
break;
case '03050503':
case '03050504':
$arr_label[1636]='model_part1';
$vus_tabla="";
break;
case '03050505':
$arr_label[1640]='model_part1';
$arr_label[1638]='model_part2';
$vus_tabla="";
break;
case '03050601':
$arr_label[1637]='model_part1';
$arr_label[1638]='model_part2';
$vus_tabla="1";
break;
case '03050603':
case '03050604':
$arr_label[1636]='model_part1';
$vus_tabla="1";
break;
case '03050602':
$arr_label[1640]='model_part1';
$arr_label[1638]='model_part2';
$vus_tabla="1";
break;
case '03050606':
$arr_label[1640]='model_part1';
$arr_label[1641]='model_part2';
$vus_tabla="1";
break;
}
$_POST['email']="";
$sql = "SELECT vus_{$_POST['tipo']}_nomprod, vus_{$_POST['tipo']}_forma, vus_{$_POST['tipo']}_strength, vus_{$_POST['tipo']}_presenta, vus_{$_POST['tipo']}_tpt_id, vus_{$_POST['tipo']}_tpr_id, vus_usr_nombre, vus_usr_email FROM vus_tramites_{$_POST['tipo']}, vus_usuarios WHERE vus_usr_id = vus_{$_POST['tipo']}_usr_id AND vus_{$_POST['tipo']}_numsol='{$_POST['etapa_numsol']}'";
$result=$connectionVUS->Execute($sql);
if (!$result->EOF) {
$_POST['nomprod']= $result->fields[0];
$_POST['forma']=$result->fields[1];
$_POST['strength']=$result->fields[2];
$_POST['presenta']=$result->fields[3];
$_POST['ctg_tpt_id']=$result->fields[4];
$_POST['ctg_tpr_id']=$result->fields[5];
$_POST['user_name'] = $result->fields[6];
$_POST['email'] = $result->fields[7];
}
echo "email (".$_POST['email'].")";
$arr_label[10]='tipo_producto';
$arr_label[54]='tipo_tramite';
$arr_label[84]='nombre_producto';
$arr_label[317]='tramite_no';
$arr_lang = "10,54,84,317,1636,1549,1637,1638,1540,1636,1640,1641";
include("form_language.php");
//////////////////////////////////////////////
// ENVIO DE EMAIL DE NOTIFICACION //
//////////////////////////////////////////////
$subject = $arr_label['informacion_tramite']." No. ".$_POST['etapa_numsol'];
$body = "Date: ".date("d-m-Y")."
";
$body .= $arr_label['estimado']." ".$_POST['user_name'].",
";
$body .= $arr_label['tramite_no'].":".$_POST['etapa_numsol']."
";
$body .= $arr_label['nombre_producto'].":".$_POST['nomprod'];//.", ".$_POST['forma'].", ".$_POST['strength'].", ".$_POST['presenta'];
switch ($_POST['opcion']) {
case '03050501':
case '03050601':
case '03050505':
$body .= "
".$arr_label['model_part1']." ".$_POST['msg_fecven'].".
".$arr_label['model_part2']."
";
break;
case '03050502':
case '03050503':
case '03050504':
case '03050603':
case '03050604':
$body .= "
".$arr_label['model_part1'].".
";
break;
case '03050602':
$body .= "
".$arr_label['model_part1']." ".$_POST['msg_fecven'].".
".$arr_label['model_part2']."
";
break;
case '03050506':
$body .= "
".$arr_label['model_part1'].".
".$arr_label['model_part2']." ".$_POST['msg_fecven'].".
";
break;
}
// $_POST['email'].= "; monterrosow@gmail.com";
$content = email_tpl($arr_label['informacion_tramite'],$body);
$headers = "From: $soporte <$company_email3>\nReply-To: $soporte <$company_email3>\nContent-Type: text/html; charset=UTF-8";
// $send = mail($_POST['email'], $subject, $content, $headers);
$respuestam["insert"] = insert_email($_POST['tipo'],$_POST['etapa_numsol'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod'],$_POST['email'],$subject,$body,$send,$_POST['id']);
$respuestam["send"] = mail_attachment("", "", $_POST['email'], $my_mail, $my_name, $my_replyto, $subject, $content);
echo json_encode($respuesta);
die();
}
//es llamada de watch_vus_tramites_docs.php & form_ctg_botones.php
if ($_POST['op'] == "texto_eval"){ // es una llamada #.post
ob_clean();
$sql_txt_look = "SELECT ctg_txt_obs FROM ctg_textos_evaluacion WHERE ctg_txt_id='".$_POST['ide']."' AND ctg_tpr_id = '".$_POST['ctg_tpr_id']."'";
$result=$connection->Execute($sql_txt_look);
echo $result->fields['ctg_txt_obs'];
die();
}
if ($_POST['op'] == "texto_docs") {
$respuesta = array();
$texto_docs = "tabla_docs_obs{$_SESSION['ADMusuario_id']}.txt";
$c=0;
while (!file_exists($texto_docs)) {
$c++;
}
$respuesta['c'] = $c;
echo json_encode($respuesta);
die();
}
//echo " POST op ({$_POST['op']})";
if ($_POST['op']=="update_token"){
die();
}
if ($_POST['op']=="update_many_status1"){
echo "menu option ["+$_POST['id']+"]
";
echo "elements ["+$_POST['elements']+"]
";
for ($x=0;$x<$_POST['elements'];$x++){
$varsol = $_POST['hid_numsol'.$x];
$vartpt = $_POST['hid_tpt_id'.$x];
$vartpr = $_POST['hid_tpr_id'.$x];
$varsta = $_POST['hid_status'.$x];
echo "The number is: ($x) sol (".$varsol.") tpt ($vartpt) tpr ($vartpr) status ($varsta)
";
}
// if (!empty($_POST['iNumsol']) && !empty($_POST['iValue'])) {
// if ($_POST['id'] == "03020701" || $_POST['id'] == "03020702" || $_POST['id'] == "03020703" || $_POST['id'] == "0302A0701" || $_POST['id'] == "0302A0702" || $_POST['id'] == "0302B0701" || $_POST['id'] == "0302B0702") {
// if (strstr($_POST['id'],"A") || strstr($_POST['id'],"B")) {
// $etapa_men = substr($_POST['id'],5,2);
// } else {
// $etapa_men = substr($_POST['id'],4,2);
// }
// //update a revision de c onforme
// //adm_coe_obs = '',
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_status = '".$_POST['iValue']."',
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['iNumsol']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".$etapa_men."'";
// echo "SQLLLL (".$sql.")";
// $result = $connection->Execute($sql);
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1)
// $info = $arr_label['datos_grabados'];
// $adm_cnf_serialnum_cor = 1;
// /*
// if (intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7) {
// $sql = "SELECT coalesce(adm_cnf_serialnum_cor,0)+1 as adm_cnf_serialnum_cor FROM adm_config";
// //echo $sql."
";
// $ret=$connection->Execute($sql);
// $adm_cnf_serialnum_cor = $ret->fields["adm_cnf_serialnum_cor"];
// }
// */
// switch ($_POST['id']) {
// case '03020701':
// case '03020702':
// case '03020703':
// $filterid ." AND adm_con_tpt_action='1' ";
// break;
// case '0302A0701':
// case '0302A0702':
// $filterid ." AND adm_con_tpt_action='2' ";
// break;
// case '0302B0701':
// case '0302B0702':
// $filterid ." AND adm_con_tpt_action IN ('3','9') ";
// break;
// }
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
// adm_con_obs = '".date("Y-m-d H:i:s")."',
// adm_con_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_dt = '".date("Y-m-d H:i:s")."',
// adm_con_prnlst = '".(intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7 ? 1 : 0)."',
// adm_con_serialnum = '".(intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7 ? $adm_cnf_serialnum_cor : 0)."'
// WHERE
// adm_con_numsol = '".$_POST['iNumsol']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' AND ".$filterid;
// $result = $connection->Execute($sql);
// $error = $connection->ErrorMsg();
// //echo $sql."
[".$error."]
";
// if ($connection->Affected_Rows() == 1) {
// if (intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7) {
// $sql="UPDATE adm_config SET adm_cnf_serialnum_cor=coalesce(adm_cnf_serialnum_cor,0)+1";
// //echo $sql."
";
// $result = $connection->Execute ($sql);
// }
// }
// }
// }
die();
}
//usuario propietario de solicitud
$vus_sol_usr_id = 0;
$sql="SELECT adm_con_usr_id FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$operador = $result->fields;
$vus_sol_usr_id = $operador['adm_con_usr_id'];
}
switch ($_POST['id']){
case "030205":
case "0302A05":
case "0302B05":{
//update a revision de c onforme
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status = '".$_POST['status']."',
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_obs = '".$_POST['obs']."',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '05'";
// echo "sql 111 ".$ql;
$result = $connection->Execute ( $sql );
// if ($_POST['status']=='3'){
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
// adm_con_cii = 1,
// adm_con_etapa = '05',
// adm_con_estatus = '3',
// adm_con_rf_status = '3',
// adm_con_rf_dt = '".date("Y-m-d H:i:s")."',
// adm_con_rf_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_rf_obs = '".$_POST['obs']."',
// adm_con_prnlst = '1',
// adm_con_sta='2',
// adm_con_usr='".$_SESSION['ADMusuario_id']."',
// adm_con_dt=now()
// WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1)
// $info = $arr_label['datos_grabados'];
// $fecha=Date("Y-m-d");
// $fisven_dt=suma_fechas($fecha,29);//recibe en formato d-m-Y y retorna Y-m-d
// // UPDATE ESTATUS DE RESULTADO FINAL
// $sql="UPDATE \"vus_tramites_{$_POST['tipo']}_ESTATUS\" SET
// \"vus_{$_POST['tipo']}EST_result\" = '10',
// \"vus_{$_POST['tipo']}EST_author\" = '".date("Y-m-d")."'
// WHERE
// \"vus_{$_POST['tipo']}EST_numsol\" = '{$_POST['codigo']}' AND
// \"vus_{$_POST['tipo']}EST_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND
// \"vus_{$_POST['tipo']}EST_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND
// \"vus_{$_POST['tipo']}EST_tts_id\" = '5' ";
// $result=$connectionVUS->Execute($sql);
// // echo $sql;
// //update tramite con boleta
// $sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET
// vus_{$_POST['tipo']}_est_id = '10',
// vus_{$_POST['tipo']}_est_dt = '".date("Y-m-d H:i:s")."',
// vus_{$_POST['tipo']}_fisven_dt = '".$fisven_dt."',
// vus_{$_POST['tipo']}_sta = '2',
// vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
// vus_{$_POST['tipo']}_dt = '".date("Y-m-d H:i:s")."'
// WHERE
// vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND
// vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'";
// $result=$connectionVUS->Execute($sql);
// } else {
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_cii = 1,
adm_con_sta='2',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt=now()
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result = $connection->Execute ( $sql );
// }
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
break;
}
case "030206":
case "0302A06":
case "0302B06":
case "030207":
case "03020701":
case "03020702":
case "03020703":
case "0302A0701":
case "0302A0702":
case "0302B0701":
case "0302B0702":
if (substr($_POST['id'],0,6)=='030207') {
if ($_POST['id'] == "030207" || $_POST['id'] == "03020701" || $_POST['id'] == "03020702" || $_POST['id'] == "03020703" || $_POST['id'] == "0302A0701" || $_POST['id'] == "0302A0702" || $_POST['id'] == "0302B0701" || $_POST['id'] == "0302B0702") {
if (strstr($_POST['id'],"A") || strstr($_POST['id'],"B")) {
$etapa_men = substr($_POST['id'],5,2);
} else {
$etapa_men = substr($_POST['id'],4,2);
}
//update a revision de c onforme
//adm_coe_obs = '',
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_status = '".$_POST['iValue']."',
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['iNumsol']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".$etapa_men."'";
// echo "SQLLLL (".$sql.")";
// $result = $connection->Execute($sql);
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1)
// $info = $arr_label['datos_grabados'];
$adm_cnf_serialnum_cor = 1;
/*
if (intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7) {
$sql = "SELECT coalesce(adm_cnf_serialnum_cor,0)+1 as adm_cnf_serialnum_cor FROM adm_config";
//echo $sql."
";
$ret=$connection->Execute($sql);
$adm_cnf_serialnum_cor = $ret->fields["adm_cnf_serialnum_cor"];
}
*/
switch ($_POST['id']) {
case '030207':
case '03020701':
case '03020702':
case '03020703':
$filterid ." AND adm_con_tpt_action='1' ";
break;
case '0302A07':
case '0302A0701':
case '0302A0702':
$filterid ." AND adm_con_tpt_action='2' ";
break;
case '0302B07':
case '0302B0701':
case '0302B0702':
$filterid ." AND adm_con_tpt_action IN ('3','9') ";
break;
}
if ($_POST['id'] == "030207" || $_POST['id'] == "03020701" || $_POST['id'] == "0302A0701" || $_POST['id'] == "0302B0701" ) {
$sqltk="SELECT adm_usr_tok1 FROM adm_usuarios WHERE adm_usr_ci ='{$_SESSION['ADMusuario_id']}' ";
// echo $sqltk;
$resultk=$connection->Execute($sqltk);
if (!$resultk->EOF) {
$token_number = $resultk->fields[0];
}
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = '".date("Y-m-d H:i:s")."',
adm_con_dec1_st = '".$_POST['status']."',
adm_con_dec1_dt = '".date("Y-m-d H:i:s")."',
adm_con_dec1_tk = '".$token_number."'
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
$result = $connection->Execute($sql);
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1) {
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
// if (intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7) {
// $sql="UPDATE adm_config SET adm_cnf_serialnum_cor=coalesce(adm_cnf_serialnum_cor,0)+1";
// //echo $sql."
";
// $result = $connection->Execute ($sql);
// }
}
switch ($_POST['res_st']) {
case '5':
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_dec1_re = '1',
adm_con_dec2_st = NULL,
adm_con_dec3_st = NULL
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
$result = $connection->Execute($sql);
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status = '1',
adm_coe_notify_sent='1',
adm_coe_res_dt = '1900-01-01',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id in ('02','03','041','042','05','07')";
$result = $connection->Execute ( $sql );
case '4':
case '3':
$res_st=$_POST['res_st'];
$sql="SELECT adm_con_dec2_st FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
echo "
SQL 6 ".$sql;
$result = $connection->Execute($sql);
if ( !$result->EOF ) {
$res_st = $result->fields[0];
}
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status = '".$res_st."',
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '07'";
// echo "
SQL 8 ".$sql;
$result = $connection->Execute ( $sql );
break;
}
}
if ($_POST['id'] == "03020702" || $_POST['id'] == "0302A0702" || $_POST['id'] == "0302B0702" ) {
$sqltk="SELECT adm_usr_tok2 FROM adm_usuarios WHERE adm_usr_ci ='{$_SESSION['ADMusuario_id']}' ";
$resultk=$connection->Execute($sqltk);
if (!$resultk->EOF) {
$token_number = $resultk->fields[0];
}
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = '".date("Y-m-d H:i:s")."',
adm_con_dec2_st = '".$_POST['res_st']."',
adm_con_dec2_dt = '".date("Y-m-d H:i:s")."',
adm_con_dec2_tk = '".$token_number."',
adm_con_dec1_re='0'
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
$result = $connection->Execute($sql);
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1) {
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
}
switch ($_POST['res_st']) {
case '7':
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_dec1_st = '0'
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
$result = $connection->Execute($sql);
break;
// case '5':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
// adm_con_dec1_re = '0',
// adm_con_dec2_re = '0'
// WHERE
// adm_con_numsol = '".$_POST['iNumsol']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
// $result = $connection->Execute($sql);
// break ;
}
// switch ($_POST['res_st']) {
// case '7':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
// adm_con_dec1_re = '1',
// adm_con_dec2_re = '1'
// WHERE
// adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
// $result = $connection->Execute($sql);
// break;
// case '5':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
// adm_con_dec1_re = '0',
// adm_con_dec2_re = '0'
// WHERE
// adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
// $result = $connection->Execute($sql);
// break;
// }
}
if ($_POST['id'] == "03020703" || $_POST['id'] == "0302A0703" || $_POST['id'] == "0302B0703" ) {
$sqltk="SELECT adm_usr_tok3 FROM adm_usuarios WHERE adm_usr_ci ='{$_SESSION['ADMusuario_id']}' ";
// echo "
SQL 1 ".$sqltk;
$resultk=$connection->Execute($sqltk);
if (!$resultk->EOF) {
$token_number = $resultk->fields[0];
}
if ($_POST['res_st']=='4'){
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = '".date("Y-m-d H:i:s")."',
adm_con_dec3_st = adm_con_dec2_st,
adm_con_dec3_tk = '".$token_number."',
adm_con_dec3_dt = '".date("Y-m-d H:i:s")."'
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
// echo "
SQL 2 ".$sql;
$result = $connection->Execute($sql);
} else {
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_dt = '".date("Y-m-d H:i:s")."',
adm_con_dec3_st = '".$_POST['res_st']."',
adm_con_dec3_tk = '".$token_number."',
adm_con_dec3_dt = '".date("Y-m-d H:i:s")."'
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
// echo "
SQL 3 ".$sql;
$result = $connection->Execute($sql);
}
if ($connection->Affected_Rows() == 1) {
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
}
switch ($_POST['res_st']) {
case '7':
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_dec3_re = '1',
adm_con_dec2_re = '1',
adm_con_dec2_st='0'
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
// echo "
SQL 4 ".$sql;
$result = $connection->Execute($sql);
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status = '0',
adm_coe_res_dt = '1900-01-01',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '07'";
// echo "
SQL 5 ".$sql;
$result = $connection->Execute ( $sql );
break;
case '4':
$res_st=$_POST['res_st'];
$sql="SELECT adm_con_dec2_st FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
echo "
SQL 6 ".$sql;
$result = $connection->Execute($sql);
if ( !$result->EOF ) {
$res_st = $result->fields[0];
}
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_dec2_re = '0',
adm_con_dec3_re = '0'
WHERE
adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ".$filterid;
echo "
SQL 7 ".$sql;
$result = $connection->Execute($sql);
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status = '".$res_st."',
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '07'";
// echo "
SQL 8 ".$sql;
$result = $connection->Execute ( $sql );
break;
}
}
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
// adm_con_obs = '".date("Y-m-d H:i:s")."',
// adm_con_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_dt = '".date("Y-m-d H:i:s")."',
// adm_con_prnlst = '".(intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7 ? 1 : 0)."',
// adm_con_serialnum = '".(intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7 ? $adm_cnf_serialnum_cor : 0)."'
// WHERE
// adm_con_numsol = '".$_POST['iNumsol']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' AND ".$filterid;
// $result = $connection->Execute($sql);
// $error = $connection->ErrorMsg();
// //echo $sql."
[".$error."]
";
// if ($connection->Affected_Rows() == 1) {
// if (intval($_POST['iValue']) == 3 || intval($_POST['iValue']) == 4 || intval($_POST['iValue']) == 7) {
// $sql="UPDATE adm_config SET adm_cnf_serialnum_cor=coalesce(adm_cnf_serialnum_cor,0)+1";
// //echo $sql."
";
// $result = $connection->Execute ($sql);
// }
// }
}
} else {
//update a revision de c onforme
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status = '".$_POST['res_final']."',
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_obs = '".$_POST['obs_final']."',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".substr($_POST['id'],4,2)."'";
echo "sql 111 ".$ql;
// $result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
if ($_POST['id'] == "030205" || $_POST['id'] == "0302A05" || $_POST['id'] == "0302B05") {
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_cii = 1,
adm_con_sta='2',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt=now()
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
} else {
if ($_POST['res_final'] == 3) {
$adm_coe_jun=0;
$adm_coe_com=0;
if ($_POST['id'] == "030206" || $_POST['id'] == "0302A06" || $_POST['id'] == "0302B06"){
$adm_coe_jun=1;
}
if ($_POST['id'] == "030207" || $_POST['id'] == "03020701" || $_POST['id'] == "03020702" || $_POST['id'] == "03020703" || $_POST['id'] == "0302A0701" || $_POST['id'] == "0302A0702" || $_POST['id'] == "0302B0701" || $_POST['id'] == "0302B0702"){
$adm_coe_com=1;
}
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_jun = ".$adm_coe_jun.",
adm_coe_com = ".$adm_coe_com.",
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE
adm_coe_numsol = '".$_POST['codigo']."' AND
adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND
adm_coe_tpe_id = '05'";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
}
}
}
break;
case "040101"://selecion de tecnicos, laboratorio
if ($_POST['op'] == "graba_sel_evaluadores") {
$sql="DELETE FROM lab_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_tecnicos
WHERE
lab_cot_numsol = '".$_POST['codigo']."' AND
lab_cot_tpr_id = '".$_POST['ctg_tpr_id']."' AND
lab_cot_tpt_id = '".$_POST['ctg_tpt_id']."' AND
lab_cot_arm_id = '".$_POST['ctg_arm_id']."' AND
lab_cot_esa_id = '".$_POST['ctg_esa_id1']."'";
$result = $connection->Execute ( $sql );
$sql="INSERT INTO lab_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_tecnicos (
lab_cot_numsol,
lab_cot_tpt_id,
lab_cot_tpr_id,
lab_cot_arm_id,
lab_cot_esa_id,
lab_cot_usr_id,
lab_cot_asi_dt,
lab_cot_asi_mue,
lab_cot_asi_usr,
lab_cot_asi_obs,
lab_cot_ini_dt,
lab_cot_exp_dt,
lab_cot_fin_dt,
lab_cot_res,
lab_cot_sup_usr,
lab_cot_sup_dt,
lab_cot_sup_obs,
lab_cot_sta,
lab_cot_usr,
lab_cot_dt
) VALUES (
'".$_POST['codigo']."',
'".$_POST['ctg_tpt_id']."',
'".$_POST['ctg_tpr_id']."',
'".$_POST['ctg_arm_id']."',
'".$_POST['ctg_esa_id1']."',
'".$_SESSION['ADMusuario_id']."',
'".date("Y-m-d H:i:s")."',
'".$_POST['lab_cot_asi_mue']."',
'".$_POST['lab_cot_usr_id']."',
'".$_POST['obs']."',
'1900-01-01 00:00:00',
'1900-01-01',
'1900-01-01 00:00:00',
'0',
'',
'1900-01-01',
'',
'1',
'".$_SESSION['ADMusuario_id']."',
'".date("Y-m-d H:i:s")."');";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
}
break;
/*
case "030202"://evaluacion
case "030203":
case "030204":
case "030205":
case "030206":
case "030207":
*/
case "030504": //rechazo 2015-11-10
//update control
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_rf_status = '7',
adm_con_rf_dt = '".fecha_srv($_POST['adm_con_rf_dt'])."',
adm_con_rf_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_rf_obs = '".$_POST['adm_con_rf_obs']."',
adm_con_sta='2',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt=now()
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
// AND ctg_esa_id = '".$_POST['ctg_esa_id']."'";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1) {
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
iniciarConexionVUS();
//update tramite
$sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET
vus_{$_POST['tipo']}_est_id = 7,
vus_{$_POST['tipo']}_est_dt = '".fecha_srv($_POST['adm_con_rf_dt'])."',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_obs = '".$_POST['adm_con_rf_obs']."',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE
vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND
vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND
vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if ($connectionVUS->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
if ($connectionVUS->Affected_Rows() == 1) {
$sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}_ESTATUS\" (
\"vus_{$_POST['tipo']}EST_numsol\",
\"vus_{$_POST['tipo']}EST_tpt_id\",
\"vus_{$_POST['tipo']}EST_tpr_id\",
\"vus_{$_POST['tipo']}EST_tts_id\",
\"vus_{$_POST['tipo']}EST_estatus_dt\",
\"vus_{$_POST['tipo']}EST_obs\",
\"vus_{$_POST['tipo']}EST_usr_id\",
\"vus_{$_POST['tipo']}EST_sta\",
\"vus_{$_POST['tipo']}EST_usr\",
\"vus_{$_POST['tipo']}EST_dt\"
) VALUES (
'{$_POST['codigo']}',
'{$_POST['ctg_tpt_id']}',
'{$_POST['ctg_tpr_id']}',
'7',
now(),
'".$_POST['adm_con_rf_obs']."',
'".$_SESSION['ADMusuario_id']."',
'1',
'".$_SESSION['ADMusuario_id']."',
now());";
$result=$connectionVUS->Execute($sql);
echo $sql."
[".$error."]
[".$info."]
";
}
}
break;
default:
if($_POST['id']!='03020103' && $_POST['id']!='0302A0103' && $_POST['id']!='0302B0103'){
iniciarConexionVUS();
if($_SESSION['rsf']=='1'){
if ($_POST['arr_res_final'])
foreach ($_POST['arr_res_final'] as $key => $value) {
//update a revision de c onforme
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status = '".$_POST['res_final']."',
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_obs = '".$_POST['arr_obs_final'][$key]."',
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".$key."'";
echo $sql."
";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."XXXX
[".$error."]
[".$info."]
";
}
if ($_POST['res_final']=='4'){
$prnlist='2';
} else {
$prnlist='1';
}
//update a resultado final general
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_etapa = '".$_POST['etapa']."',
adm_con_estatus = '".$_POST['res_final']."',
adm_con_rf_status = '".$_POST['res_final']."',
adm_con_rf_dt = '".date("Y-m-d H:i:s")."',
adm_con_rf_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_rf_obs = '".$_POST['obs_final']."',
adm_con_prnlst = '".$prnlist."',
adm_con_sta='2',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt='".date("Y-m-d H:i:s")."'
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
// AND ctg_esa_id = '".$_POST['ctg_esa_id']."'";
// echo $sql."
";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."))))YYYY
[".$error."]
[".$info."]
";
echo "RESULTADO ".$_POST['res_final'];
if($_POST['res_final']=='4'){
$ctg_tpr_correg = 0;
$validez = 0;
$sql= "SELECT ctg_tpr_expe_loc, ctg_tpr_coradm, ctg_tpr_correg, ctg_tpr_validez FROM ctg_tipo_productos WHERE ctg_tpr_id='".$_POST['ctg_tpr_id']."'";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$operador = $result->fields;
$ctg_tpr_expe_loc=$operador['ctg_tpr_expe_loc'];
$validez = $operador['ctg_tpr_validez'];
$ctg_tpr_correg=$operador['ctg_tpr_correg'];
}
$sql="SELECT ctg_tpt_accion FROM ctg_tipo_tramites WHERE ctg_tpt_id='{$_POST['ctg_tpt_id']}' AND ctg_tpr_id='{$_POST['ctg_tpr_id']}'";
// echo $sql."
";
$result = $connection->Execute ($sql);
// echo "(accion={$result->fields[0]})";
switch ($result->fields[0]) {
case 1://nuevo registro
echo "
******* ADMITIR EL RESULTADO FINAL ******
";
include_once ('admitir_nuevo_registro.php');
echo "
******* ADMITIR DOCUMENTOS ******
";
include_once ('admitir_docs.php');
break;
case 2://renovacion
//solo GT
//ren_res_no pendiente el input de numero de resolucion
//ren_res_dt pendiente el input la fecha de resolucion
//select adm_ef_vencim, to_char(adm_ef_vencim + interval '2 year','yyyy-mm-dd') as otro from ctg_productos_ef
include_once ('admitir_renovacion.php');
break;
case 3://cambios post registro
//admitir_cambios
break;
case 9://renovacion y cambios
include_once ('admitir_renovacion.php');
//admitir_cambios
break;
}
$est_id = 9;
}
if($_POST['res_final']=='3')
$est_id = 10;
echo "ESTATUS ".$est_id;
$fecha=Date("Y-m-d");
$sql= "SELECT * FROM adm_config";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$oper = $result->fields;
$numrecfis=$oper['adm_cnf_numrecfis'];
}
$fisven_dt=suma_fechas($fecha,$numrecfis);//recibe en formato d-m-Y y retorna Y-m-d
if(($_POST['id'] == '030208' || $_POST['id'] == '0302A08' || $_POST['id'] == '0302B08') && ($est_id == 9 || $est_id == 10) )
{
// UPDATE ESTATUS DE RESULTADO FINAL
$sql="UPDATE \"vus_tramites_{$_POST['tipo']}_ESTATUS\" SET
\"vus_{$_POST['tipo']}EST_result\" = '{$est_id}',
\"vus_{$_POST['tipo']}EST_author\" = '".date("Y-m-d")."'
WHERE
\"vus_{$_POST['tipo']}EST_numsol\" = '{$_POST['codigo']}' AND
\"vus_{$_POST['tipo']}EST_tpt_id\" = '{$_POST['ctg_tpt_id']}' AND
\"vus_{$_POST['tipo']}EST_tpr_id\" = '{$_POST['ctg_tpr_id']}' AND
\"vus_{$_POST['tipo']}EST_tts_id\" = '5' ";
$result=$connectionVUS->Execute($sql);
// echo $sql;
//update tramite con boleta
$sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET
vus_{$_POST['tipo']}_est_id = ".$est_id.",
vus_{$_POST['tipo']}_est_dt = '".date("Y-m-d H:i:s")."',
vus_{$_POST['tipo']}_fisven_dt = '".$fisven_dt."',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = '".date("Y-m-d H:i:s")."'
WHERE
vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND
vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND
vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if ($connectionVUS->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo "///////////////////////////////////////////////////////////////////";
echo $sql."
[".$error."]
[".$info."]
";
}
//ENVIO EMAIL Y GUARDA EN MENSAJES CUANDO ES OPCION DE DESICION FINAL
if($_POST['id'] == '030208' || $_POST['id'] == '0302A08' || $_POST['id'] == '030208') {
//lenguaje para email
$arr_label[317]='tramite_no';
$arr_label[10]='tipo_producto';
$arr_label[54]='tipo_tramite';
$arr_label[316]='doc_nombre';
$arr_label[14]='comentarios';
$arr_label[324]='parte';
$arr_label[366]='cambio_status';
$arr_label[367]='faltante';
$arr_label[368]='se_cambio_status';
$arr_label[369]='a';
$arr_label[84]='nombre_producto';
$arr_label[511] = 'genero_boleta';
$arr_label[1363] = 'model17_part1';
$arr_label[1364] = 'model17_part2';
$arr_label[1365] = 'model17_part3';
$arr_label[1366] = 'model17_part4';
$arr_label[1367] = 'model17_part5';
$arr_label[1368] = 'model17_part6';
$arr_label[1374] = 'model16_part1';
$arr_label[1375] = 'model16_part2';
$arr_label[1376] = 'model16_part3';
$arr_lang = "317,10,54,316,14,324,366,367,368,369,84,511,1363,1364,1365,1366,1367,1368,1374,1375,1376";
include ('form_language.php');
$subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo'];
if($est_id == 9) {
$_POST['fecha'] = date("Y-m-d");
$fechaven= suma_fechas($_POST['fecha'],90);//recibe en formato d-m-Y y retorna Y-m-d
$body = "Date: ".date("d-m-Y")."
";
$body .= $arr_label['estimado']." ".$_POST['nombre'].",
";
$body .= $arr_label['tramite_no'].":".$_POST['codigo']."
";
$body .= $arr_label['nombre_producto'].":".$_POST['nomprod'];//.", ".$_POST['forma'].", ".$_POST['strength'].", ".$_POST['presenta'];
$body .= "
".$arr_label['model17_part1']." ".$arr_label['model17_part2']." ".fecha_usr($fisven_dt).$arr_label['model17_part3']."
".$arr_label['model17_part4']."
";//.$arr_label['model17_part5']."
"; //.$arr_label['model17_part6']."
";
$sql="UPDATE vus_tramites_{$_POST['tipo']}2 SET
vus_{$_POST['tipo']}_pagcer ='".$fechaven."',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt =now()
WHERE vus_{$_POST['tipo']}_numsol = '{$_POST['codigo']}' AND vus_{$_POST['tipo']}_tpt_id = '{$_POST['ctg_tpt_id']}' AND vus_{$_POST['tipo']}_tpr_id = '{$_POST['ctg_tpr_id']}'";
echo $sql."
";
$result=$connectionVUS->Execute($sql);
} else {
$body = "Date: ".date("d-m-Y")."
";
$body .= $arr_label['estimado']." ".$_POST['nombre'].",
";
$body .= $arr_label['tramite_no'].":".$_POST['codigo']."
";
$body .= $arr_label['nombre_producto'].":".$_POST['nomprod'];//.", ".$_POST['forma'].", ".$_POST['strength'].", ".$_POST['presenta'];
$body .= "
".$arr_label['model16_part2']."
";//.$arr_label['model16_part3']."
";
}
// if (!empty($_POST['obs_final'])){
// $comments = "Final Observations
";
// $comments .= nl2br($_POST['obs_final']);
// }
//manda email
if ($error != '') {
//include_once ("send_error_mail.php");
$error = 1;
$info = "";
} else {
if (trim($_POST['email']) != "") {
$content = email_tpl($arr_label['informacion_tramite'],$body);
//$company_email3="info@siamedweb.com";
//$headers = "From: $soporte $company <$company_email3>\nReply-To: $soporte $company<$company_email3>\nContent-Type: text/html; charset=UTF-8";
//$send = mail($_POST['email'], $subject, $content, $headers);
$send = mail_attachment("", "", $_POST['email'], $company_email3, $soporte, $company_email3, $subject, $content);
$sql="SELECT adm_cnf_email_asoc6 FROM adm_config";
$email_asoc6="";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$email_asoc6=$result->fields[0];
}
$send2 = mail_attachment("", "", $email_asoc6, $company_email3, $soporte, $company_email3, $subject, $content);
$res = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod'],$_POST['email'],$subject,$body,$send,$_POST['id']);
echo $res."
";
if ($send)
$info = $arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio'];
else
$error = 2;//"no pudo enviar correo a ".$_POST['email'];
} else
$error = 3;//"No se encontro cuenta de correo";
}
//insertar mensaje
$sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}_MENSAJES\" (
\"vus_{$_POST['tipo']}MSG_numsol\",
\"vus_{$_POST['tipo']}MSG_tpt_id\",
\"vus_{$_POST['tipo']}MSG_tpr_id\",
\"vus_{$_POST['tipo']}MSG_nomprod\",
\"vus_{$_POST['tipo']}MSG_tipo\",
\"vus_{$_POST['tipo']}MSG_fecha\",
\"vus_{$_POST['tipo']}MSG_asunto\",
\"vus_{$_POST['tipo']}MSG_mensaje\",
\"vus_{$_POST['tipo']}MSG_usr_id\",
\"vus_{$_POST['tipo']}MSG_esa_id\",
\"vus_{$_POST['tipo']}MSG_fecven\",
\"vus_{$_POST['tipo']}MSG_fecfal\",
\"vus_{$_POST['tipo']}MSG_falsta\",
\"vus_{$_POST['tipo']}MSG_sta\",
\"vus_{$_POST['tipo']}MSG_usr\",
\"vus_{$_POST['tipo']}MSG_dt\",
\"vus_{$_POST['tipo']}MSG_tpe_id\"
) VALUES (
'".$_POST['codigo']."',
'".$_POST['ctg_tpt_id']."',
'".$_POST['ctg_tpr_id']."',
'".$_POST['nomprod']."',
'3',
now(),
'".$subject."',
'".str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body)."',
'".$vus_sol_usr_id."',
'".$_SESSION['ADMnivel']."',
".(empty($_POST['bolresdt']) ? "now()" : "'".date("Y-m-d",strtotime($_POST['bolresdt']))."'").",
now(),
'1',
'1',
'".$_SESSION['ADMusuario_id']."',
now(),
'".substr($_POST['id'],strlen($_POST['id'])-2,2)."'
);";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if ($connectionVUS->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo "2995 ".$sql."
[error=".$error."*****]
[info=".$info."]
";
echo "[$error]";
}
}else if($_SESSION['ntf']=='1'){
}else{
//$rf = "";
echo "(numbol=".$_POST['numbol'].")(adm_cnf_numbol=$adm_cnf_numbol)"; //2014-07-31
if ($_POST['status'] == "2" && $_POST['numbol'] == $adm_cnf_numbol) {
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_etapa = '".$_POST['etapa']."',
adm_con_estatus = '4',
adm_con_sta='2',
adm_con_rf_status = 4,
adm_con_rf_dt = now(),
adm_con_rf_usr = {$_SESSION['ADMusuario_id']},
adm_con_rf_obs = '{$_POST['obs']}',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt='".date("Y-m-d H:i:s")."'
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";// AND ctg_esa_id = '".$_POST['ctg_esa_id']."'";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
} else {
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_etapa = '".$_POST['etapa']."',
adm_con_estatus = '".$_POST['status']."',
adm_con_sta='2',
adm_con_obs = '{$_POST['obs']}',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt='".date("Y-m-d H:i:s")."'
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";// AND ctg_esa_id = '".$_POST['ctg_esa_id']."'";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
}
//lenguaje para email
$arr_label[317]='tramite_no';
$arr_label[10]='tipo_producto';
$arr_label[54]='tipo_tramite';
$arr_label[316]='doc_nombre';
$arr_label[14]='comentarios';
$arr_label[324]='parte';
$arr_label[366]='cambio_status';
$arr_label[367]='faltante';
$arr_label[368]='se_cambio_status';
$arr_label[369]='a';
$arr_label[84]='nombre_producto';
$arr_label[511] = 'genero_boleta';
$arr_label[323] = 'conforme';
$arr_label[505] = 'no_conforme';
$arr_label[1276] = 'limite_boleta';
$arr_label[1277] = 'limite_boleta2';
$arr_label[1183]='comentarios_neg';
$arr_lang = "317,10,54,316,14,324,366,367,368,369,84,511, 323, 505, 1276, 1277, 1183";
include ('form_language.php');
//$comments = "No encontro estatus!!!
";
$obs = $_POST['obs']." ";
if ($_POST['id'] == "0302041" || $_POST['id'] == "0302A041" || $_POST['id'] == "0302B041")
if ($_POST['status'] == "3")
$obs.=" QC LAB RESULTS: NON CONFORM ";
else
$obs.=" QC LAB RESULTS: CONFORM ";
if (($_POST['status'] == "2" || $_POST['status'] == "5")&& $_POST['numbol'] == $adm_cnf_numbol) {
$comp = "adm_coe_obs = '{$arr_label['limite_boleta2']}',";
} else {
$comp = "adm_coe_obs = '".$obs."',";
}
$emailBoolean = true;
$boletaBoolean = true;
include_once('tabla_docs_html2.php');
switch ($_POST['status']){
case "1"://en proceso no genera email
$comp .= "adm_coe_inipro_dt = '".date("Y-m-d H:i:s")."',"; //etapas
break;
case "5"://preboleta
break;
case "6"://reject
if ($_POST['id'] == "030202" || $_POST['id'] == "030203" || $_POST['id'] == "030204" || $_POST['id'] == "0302041" || $_POST['id'] == "0302A02" || $_POST['id'] == "0302A03" || $_POST['id'] == "0302A04" || $_POST['id'] == "0302A041" || $_POST['id'] == "0302B02" || $_POST['id'] == "0302B03" || $_POST['id'] == "0302B04" || $_POST['id'] == "0302B041") {
//update control
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_rf_status = '7',
adm_con_rf_dt = '".fecha_srv($_POST['adm_con_rf_dt'])."',
adm_con_rf_usr = '".$_SESSION['ADMusuario_id']."',
adm_con_rf_obs = '".$_POST['obs']."',
adm_con_sta='2',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt=now()
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
// AND ctg_esa_id = '".$_POST['ctg_esa_id']."'";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1) {
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
iniciarConexionVUS();
//update tramite
$sql="UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET
vus_{$_POST['tipo']}_est_id = 7,
vus_{$_POST['tipo']}_est_dt = '".fecha_srv($_POST['adm_con_rf_dt'])."',
vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_obs = '".$_POST['obs']."',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = now()
WHERE
vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND
vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND
vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if ($connectionVUS->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[".$error."]
[".$info."]
";
if ($connectionVUS->Affected_Rows() == 1) {
$sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}_ESTATUS\" (
\"vus_{$_POST['tipo']}EST_numsol\",
\"vus_{$_POST['tipo']}EST_tpt_id\",
\"vus_{$_POST['tipo']}EST_tpr_id\",
\"vus_{$_POST['tipo']}EST_tts_id\",
\"vus_{$_POST['tipo']}EST_estatus_dt\",
\"vus_{$_POST['tipo']}EST_obs\",
\"vus_{$_POST['tipo']}EST_usr_id\",
\"vus_{$_POST['tipo']}EST_sta\",
\"vus_{$_POST['tipo']}EST_usr\",
\"vus_{$_POST['tipo']}EST_dt\"
) VALUES (
'{$_POST['codigo']}',
'{$_POST['ctg_tpt_id']}',
'{$_POST['ctg_tpr_id']}',
'7',
now(),
'".$_POST['obs']."',
'".$_SESSION['ADMusuario_id']."',
'1',
'".$_SESSION['ADMusuario_id']."',
now());";
$result=$connectionVUS->Execute($sql);
echo $sql."
[".$error."]
[".$info."]
";
}
}
}
break;
case "2"://con boleta
if ($_POST['id'] == "030202" || $_POST['id'] == "030203" || $_POST['id'] == "030204" || $_POST['id'] == "0302041" || $_POST['id'] == "0302A02" || $_POST['id'] == "0302A03" || $_POST['id'] == "0302A04" || $_POST['id'] == "0302A041" || $_POST['id'] == "0302B02" || $_POST['id'] == "0302B03" || $_POST['id'] == "0302B04" || $_POST['id'] == "0302B041") {
$emailBoolean = true;
$boletaBoolean = true;
// $coe_obs = "";
// $sql="SELECT * FROM adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas WHERE
// adm_coe_numsol = '".$_POST['codigo']."' AND
// adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND
// adm_coe_tpe_id BETWEEN '02' AND '04' ORDER BY adm_coe_tpe_orden";
// echo $sql."
";
// $result=$connection->Execute($sql);
// $error = $connection->ErrorMsg();
// if (!$result->EOF) {
// while ( !$result->EOF ) {
// $operador = $result->fields;
// $coe_obs .= $operador['adm_coe_obs'].", ";
// $result->MoveNext ();
// }
// }
// $_POST['obs'] = $coe_obs." ".$_POST['obs'];
// $comp = "adm_coe_obs = '{$_POST['obs']}',";
// echo $comp."
";
}
if ($boletaBoolean) {
//update tramite con boleta 2014-07-30
$sql = "UPDATE vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} SET ";
// ya no tiene tiene limite porque ahora es por etapa
if ($_POST['numbol'] == $adm_cnf_numbol) { //2014-07-31
// $sql .= "vus_{$_POST['tipo']}_est_id = '7', vus_{$_POST['tipo']}_est_dt = now(), vus_{$_POST['tipo']}_obs = '{$arr_label['limite_boleta2']}',";
$comments = "".$arr_label['limite_boleta']."
";
} else {
$sql .= "
vus_{$_POST['tipo']}_boleta = '1',
vus_{$_POST['tipo']}_numbol = COALESCE(vus_{$_POST['tipo']}_numbol,0) + 1,";
}
$sql .= "vus_{$_POST['tipo']}_sta = '2',
vus_{$_POST['tipo']}_usr = '".$_SESSION['ADMusuario_id']."',
vus_{$_POST['tipo']}_dt = '".date("Y-m-d H:i:s")."'
WHERE
vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND
vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND
vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if ($connectionVUS->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo "33 ".$sql."
[".$error."]
[".$info."]
";
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']} SET
adm_con_etapa = '".$_POST['etapa']."',
adm_con_estatus = '2',
adm_con_sta='2',
adm_con_usr='".$_SESSION['ADMusuario_id']."',
adm_con_dt='".date("Y-m-d H:i:s")."'
WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_con_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result = $connection->Execute ( $sql );
$sql = "SELECT vus_{$_POST['tipo']}_numbol FROM vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']} WHERE
vus_{$_POST['tipo']}_numsol = '".$_POST['codigo']."' AND
vus_{$_POST['tipo']}_tpr_id = '".$_POST['ctg_tpr_id']."' AND
vus_{$_POST['tipo']}_tpt_id = '".$_POST['ctg_tpt_id']."'";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
echo "22 ".$sql."
[".$error."]
[".$info."]
";
if (!$result_->EOF)
$numebole = intval($result->fields[0])+1;
else
$numebole =1;
$comp .= "adm_coe_bol = '1',";
$comp .= "adm_coe_bolgen = '".date("Y-m-d")."',"; //etapas
$comp .= "adm_coe_bolespres = '1',";
$comp .= "adm_coe_boldias = '".intval($_POST['dias'])."',"; //etapas
$comp .= "adm_coe_bolresdt = '".fecha_srv($_POST['bolresdt'])."',"; //etapas
$comp .= "adm_coe_bolnum = '".$numebole."', ";
$comp2 = "adm_coe_bol = '1',";
$comp2 .= "adm_coe_bolgen = '".date("Y-m-d")."',"; //etapas
$comp2 .= "adm_coe_bolespres = '1',";
$comp2 .= "adm_coe_boldias = '".intval($_POST['dias'])."',"; //etapas
$comp2 .= "adm_coe_bolresdt = '".fecha_srv($_POST['bolresdt'])."',"; //etapas
$comp2 .= "adm_coe_bolnum = '".$numebole."', ";
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_status = '8',
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id ='05' ";
// // echo "44 ".$sql."
[".$error."]
[".$info."]
";
// $result = $connection->Execute ( $sql );
// Actualiza etapa 02 con info de boleta 2018-01-28
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_status = '".$_POST['status']."',
adm_coe_obs = '".$_POST['obs']."',
$comp2
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id ='".substr($_POST['id'],4,2)."' ";
echo "
SQL ETAPAS ".$sql."
";
$result = $connection->Execute ( $sql );
$info = $arr_label['datos_grabados'];
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_status='2' AND adm_coe_tpe_id='03' ";
// $result = $connection->Execute ( $sql );
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_status='2' AND adm_coe_tpe_id='04' ";
// $result = $connection->Execute ( $sql );
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_status='2' AND adm_coe_tpe_id='07' ";
// $result = $connection->Execute ( $sql );
}
//generar boleta pdf
//para luego contar las boletas hasta tres
break;
case "3":{//no conforme
if ($_POST['id'] == "030202" || $_POST['id'] == "030203" || $_POST['id'] == "030204" || $_POST['id'] == "0302041" || $_POST['id'] == "030205" || $_POST['id'] == "0302A02" || $_POST['id'] == "0302A03" || $_POST['id'] == "0302A04" || $_POST['id'] == "0302A041" || $_POST['id'] == "0302A05" || $_POST['id'] == "0302B02" || $_POST['id'] == "0302B03" || $_POST['id'] == "0302B04" || $_POST['id'] == "0302B041" || $_POST['id'] == "0302B05") {
$emailBoolean = false;
$boletaBoolean = false;
}
$comp .= "adm_coe_finpro = '".date("Y-m-d H:i:s")."',"; //etapas
if ($_POST['id'] == "0302041" || $_POST['id'] == "0302A041" || $_POST['id'] == "0302B041")
$comments="QC LAB RESULTS: NON CONFORM ";
// else
// $comments = "".$arr_label['no_conforme']."
";
}
break;
case "4"://conforme
$emailBoolean = false;
if ($_POST['id'] == "030202" || $_POST['id'] == "030203" || $_POST['id'] == "030204" || $_POST['id'] == "0302041" || $_POST['id'] == "030205" || $_POST['id'] == "0302A02" || $_POST['id'] == "0302A03" || $_POST['id'] == "0302A04" || $_POST['id'] == "0302A041" || $_POST['id'] == "0302A05" || $_POST['id'] == "0302B02" || $_POST['id'] == "0302B03" || $_POST['id'] == "0302B04" || $_POST['id'] == "0302B041" || $_POST['id'] == "0302B05") {
$boletaBoolean = false;
}
$comp .= "adm_coe_finpro = '".date("Y-m-d H:i:s")."',"; //etapas
if ($_POST['id'] == "0302041" || $_POST['id'] == "0302A041" || $_POST['id'] == "0302B041")
$comments="QC LAB RESULTS: CONFORM ";
// else
// $comments = "".$arr_label['conforme']."
";
break;
}
if ($_POST['status'] == 3 || $_POST['status'] == 4 || $_POST['status'] == 1 && (
$_POST['id'] == "030202" || $_POST['id'] == "0302A02" || $_POST['id'] == "0302B02" ||
$_POST['id'] == "030203" || $_POST['id'] == "0302A03" || $_POST['id'] == "0302B03" ||
$_POST['id'] == "030204" || $_POST['id'] == "0302A04" || $_POST['id'] == "0302B04")
) {
// Actualiza etapa 07 con info de observaciones del QClab 2018-02-11
// adm_coe_status = '".$_POST['status']."',
$obs=$_POST['obs'].$comments;
$sql9="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_status_dt = '".date("Y-m-d")."',
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_status = '".$_POST['status']."',
adm_coe_obs = '".$obs."',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id='".substr($_POST['id'],4,2)."' ";
echo $sql9;
$result = $connection->Execute ($sql9);
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1) {
if ($info == "")
$info = $arr_label['datos_grabados'];
}
}
if ($_POST['status'] ==3 || $_POST['status'] == 4 && ($_POST['id'] == "0302042" || $_POST['id'] == "0302A042" || $_POST['id'] == "0302B042")) {
// Actualiza etapa 07 con info de observaciones del QClab 2018-02-11
// adm_coe_status = '".$_POST['status']."',
$obs=$_POST['obs'].$comments;
$sql9="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_obs = '".$obs."',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id='07' ";
$result = $connection->Execute ($sql9);
$error = $connection->ErrorMsg();
$sql9="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
adm_coe_obs = '".$obs."',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id='041' ";
$result = $connection->Execute ($sql9);
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1) {
if ($info == "")
$info = $arr_label['datos_grabados'];
}
}
if ($_POST['status'] ==3 || $_POST['status'] == 4 && ($_POST['id'] == "030208" || $_POST['id'] == "0302A08" || $_POST['id'] == "0302B08")) {
$sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
$comp2
adm_coe_sta = '2',
adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
adm_coe_dt = '".date("Y-m-d H:i:s")."'
WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '02' AND adm_coe_status='2'";
$result = $connection->Execute ( $sql );
$error = $connection->ErrorMsg();
if ($connection->Affected_Rows() == 1) {
if ($info == "")
$info = $arr_label['datos_grabados'];
}
}
/////////////////proceso de mandar correo y agregar los documentos que tienen problemas/////////
if ($_POST['status'] > 1) {
if ($emailBoolean) {
echo " estatus (".$_POST['status'].") id (".$_POST['id'].") emailboolean (true)";
$_POST['bolresdt']=date("Y-m-d");
$sql= "SELECT * FROM adm_config";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$oper = $result->fields;
$numboldias=$oper['adm_cnf_numboldias'];
}
$_POST['bolresdt']= suma_fechas($_POST['bolresdt'],$numboldias);//recibe en formato d-m-Y y retorna Y-m-d
$sql= "SELECT * FROM ctg_tipo_tramites_etapas WHERE ctg_tpr_id='".$_POST['ctg_tpr_id']."' AND ctg_tpt_id='".$_POST['ctg_tpt_id']."' AND ctg_tte_id = '".substr($_POST['id'],4,2)."'";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$oper = $result->fields;
$tte_email = $oper['ctg_tte_email'];
$tte_descrip = strtoupper($oper['ctg_tte_desc']);
}
if ($_POST['id']=='030203'){
$arr_label[1359] = 'model14_part1';
$arr_label[1360] = 'model14_part2';
$arr_label[1361] = 'model14_part3';
$arr_label[1362] = 'model14_part4';
$arr_label[1346] = 'model14_part5';
} else {
$arr_label[1359] = 'model14_part1';
$arr_label[1360] = 'model14_part2';
$arr_label[1361] = 'model14_part3';
$arr_label[1362] = 'model14_part4';
$arr_label[1346] = 'model14_part5';
$arr_label[1908] = 'model14_part6';
$arr_label[1909] = 'model14_part7';
}
$arr_lang = "1346,1359,1360,1361,1362";
include ('form_language.php');
$texto_docs = "tabla_docs_obs{$_SESSION['ADMusuario_id']}.txt";
//elabora email
$subject = $arr_label['informacion_tramite']." No. ".$_POST['codigo'];
//$comments .= nl2br($_POST['obs']);
$body = "Date: ".date("d-m-Y")."
";
$body .= $arr_label['estimado']." ".$_POST['nombre'].",
";
$body .= $arr_label['tramite_no'].":".$_POST['codigo']."
";
$body .= $arr_label['nombre_producto'].":".$_POST['nomprod'];//.", ".$_POST['forma'].", ".$_POST['strength'].", ".$_POST['presenta']."
";
switch ($_POST['id']) {
case '030202':
$body .= "
CENAVIF
";
$body .= "
".$arr_label['model14_part1']." ".$_POST['bolresdt']." lo siguiente:
Estatus de la solicitud:NO CONFORME.
VENTANILLA UNICA DE SERVICIOS:
";
if (!empty($_POST['obs'])){
$body .= "
".nl2br($_POST['obs'])."
";
}
$body .= "#*tabla_docs*#";
$body .= "
".$arr_label['model14_part3']."
";
// $body .= "
".$arr_label['model14_part5']."
";
break;
case '030203':
$body .= "
Division de Evaluacion Farmacologica
";
$body .= "
".$arr_label['model14_part1']." ".$_POST['bolresdt']." lo siguiente:
Estatus de la solicitud:NO CONFORME.
VENTANILLA UNICA DE SERVICIOS:
";
if (!empty($_POST['obs'])){
$body .= "
".nl2br($_POST['obs'])."
";
}
$body .= "#*tabla_docs*#";
$body .= "
".$arr_label['model14_part3']."
";
// $body .= "
".$arr_label['model14_part5']."
";
break;
case '030204':
$body .= "
Division de Evaluacion Farmaceutica
";
$body .= "
".$arr_label['model14_part1']." ".$_POST['bolresdt']." lo siguiente:
Estatus de la solicitud:NO CONFORME.
";
$body .= $arr_label['model14_part6']." ".$arr_label['model14_part7']."
VENTANILLA UNICA DE SERVICIOS:
";
if (!empty($_POST['obs'])){
$body .= "
".nl2br($_POST['obs'])."
";
}
$body .= "#*tabla_docs*#";
$body .= "
".$arr_label['model14_part3']."
";
break;
default:
# code...
break;
}
// if ($_POST['id']=='030203'){
// $body .= "
Division de Evaluacion Farmacologica
";
// $body .= "
".$arr_label['model14_part1']." ".$_POST['bolresdt']." lo siguiente:
Estatus de la solicitud:NO CONFORME.
VENTANILLA UNICA DE SERVICIOS:
";
// if (!empty($_POST['obs'])){
// $body .= "
".nl2br($_POST['obs'])."
";
// }
// $body .= "#*tabla_docs*#";
// $body .= "
".$arr_label['model14_part3']."
";
// // $body .= "
".$arr_label['model14_part5']."
";
// } else {
// $body .= "
Division de Evaluacion Farmaceutica
";
// $body .= "
".$arr_label['model14_part1']." ".$_POST['bolresdt']." lo siguiente:
Estatus de la solicitud:NO CONFORME.
";
// $body .= $arr_label['model14_part6']." ".$arr_label['model14_part7']."
VENTANILLA UNICA DE SERVICIOS:
";
// if (!empty($_POST['obs'])){
// $body .= "
".nl2br($_POST['obs'])."
";
// }
// $body .= "#*tabla_docs*#";
// $body .= "
".$arr_label['model14_part3']."
";
// }
// if (!empty($_POST['obs'])){
// $comments1 .= "
".nl2br($_POST['obs'])."
";
// }
//insertar mensaje
$sql="INSERT INTO \"vus_tramites_{$_POST['tipo']}_MENSAJES\" (
\"vus_{$_POST['tipo']}MSG_numsol\",
\"vus_{$_POST['tipo']}MSG_tpt_id\",
\"vus_{$_POST['tipo']}MSG_tpr_id\",
\"vus_{$_POST['tipo']}MSG_nomprod\",
\"vus_{$_POST['tipo']}MSG_tipo\",
\"vus_{$_POST['tipo']}MSG_fecha\",
\"vus_{$_POST['tipo']}MSG_asunto\",
\"vus_{$_POST['tipo']}MSG_mensaje\",
\"vus_{$_POST['tipo']}MSG_usr_id\",
\"vus_{$_POST['tipo']}MSG_esa_id\",
\"vus_{$_POST['tipo']}MSG_fecven\",
\"vus_{$_POST['tipo']}MSG_fecfal\",
\"vus_{$_POST['tipo']}MSG_falsta\",
\"vus_{$_POST['tipo']}MSG_sta\",
\"vus_{$_POST['tipo']}MSG_usr\",
\"vus_{$_POST['tipo']}MSG_dt\",
\"vus_{$_POST['tipo']}MSG_tpe_id\"
) VALUES (
'".$_POST['codigo']."',
'".$_POST['ctg_tpt_id']."',
'".$_POST['ctg_tpr_id']."',
'".$_POST['nomprod']."',
'2',
now(),
'".$subject."',
'".str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body)."',
'".$vus_sol_usr_id."',
'".$_SESSION['ADMnivel']."',
'".date("Y-m-d",strtotime($_POST['bolresdt']))."',
now(),
'1',
'1',
'".$_SESSION['ADMusuario_id']."',
now(),
'".substr($_POST['id'],strlen($_POST['id'])-2,2)."'
);";
//if ($_POST['status'] == "2" && $_POST['numbol'] >= $adm_cnf_numbol) { //2014-07-31
//} else {
echo $sql;
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if ($connectionVUS->Affected_Rows() == 1)
$info = $arr_label['datos_grabados'];
echo $sql."
[error=".$error."*****]
[info=".$info."]
";
echo "***********lunes****************
";
//manda email
if ($error != '') {
//include_once ("send_error_mail.php");
//$error = 1;
$info = "";
} else {
$send = 0;
if ($tte_email == 1 ) { //si manda email o es PRE-BOLETA
if ($_POST['status'] == 5) //DRAFT observatins
$_POST['email']="";//assessment@dcdfdamm.online";
else { //final observations, tiene que ir a buscar el email del usuario que creo la solicitud
$_POST['email']="";
$sql = "SELECT vus_usr_nombre, vus_usr_email FROM vus_tramites_{$_POST['tipo']}{$_SESSION['dtb_vus']}, vus_usuarios WHERE vus_usr_id = vus_{$_POST['tipo']}_usr_id AND vus_{$_POST['tipo']}_numsol='{$_POST['codigo']}'";
// echo $sql."
";
$result=$connectionVUS->Execute($sql);
if (!$result->EOF) {
$_POST['email'] = $result->fields["vus_usr_email"];//.",dcdfdammemails@gmail.com";
}
}
if (trim($_POST['email']) != "") {
$body1 = str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body);
$content = email_tpl($arr_label['informacion_tramite'],$body1);
//$headers = "From: $soporte $company <$company_email3>\nReply-To: $soporte $company<$company_email3>\nContent-Type: text/html; charset=UTF-8";
//$send = mail($_POST['email'], $subject, $content, $headers);
//$send = mail_attachment("", "", $_POST['email'], $company_email3, $soporte, $company_email3, $subject, $content);
if ($send)
$info = $arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio'];
else
$error = 2;//"no pudo enviar correo a ".$_POST['email'];
} else
$error = 3;//"No se encontro cuenta de correo";
} else echo "El tte_email no es marcado en tipo_tramites_etapas";
if ($tte_email == 1 || $_POST['status'] == 2) { //si manda email o es BOLETA
if (trim($_POST['email']) != "") {
$body1 = str_replace("#*tabla_docs*#",file_get_contents($texto_docs),$body);
$content = email_tpl($arr_label['informacion_tramite'],$body1);
$send = mail_attachment("", "", $_POST['email'], $company_email3, $soporte, $company_email3, $subject, $content);
$sql="SELECT adm_cnf_email_asoc3, adm_cnf_email_asoc4 FROM adm_config";
$email_asoc3="";
$email_asoc4="";
$result=$connection->Execute($sql);
if (!$result->EOF) {
$email_asoc3=$result->fields[0];
$email_asoc4=$result->fields[1];
}
if ($_POST['id']=='030203'){
echo "SENT COPY TO
(".$email_asoc3.")";
$send1 = mail_attachment("", "", $email_asoc3, $company_email3, $soporte, $company_email3, $subject, $content);
}
if ($_POST['id']=='030204'){
echo "SENT COPY TO
(".$email_asoc4.")";
$send1 = mail_attachment("", "", $email_asoc4, $company_email3, $soporte, $company_email3, $subject, $content);
}
$res = insert_email($_POST['tipo'],$_POST['codigo'],$_POST['ctg_tpt_id'],$_POST['ctg_tpr_id'],$_POST['nomprod'],$_POST['email'],$subject,$body1,$send,$_POST['id']);
if ($send)
$info = $arr_label['envio_correo']." ".$_POST['email']." ".$arr_label['satisfactorio'];
else
$error = 2;//"no pudo enviar correo a ".$_POST['email'];
} else
$error = 3;//"No se encontro cuenta de correo";
} else echo "El tte_email no es marcado en tipo_tramites_etapas";
echo "res=$res
";
}
unlink($texto_docs);
} else {
echo " estatus (".$_POST['status'].") id (".$_POST['id'].") emailboolean (false)";
}
}
$info = $arr_label['datos_grabados'];
$error = '';
echo "ERROR LINEA 3347 ((".$error.") ";
if ($error == "") {
//// LOQ /////
$obs=$_POST['obs'];
$loq_obs2 = "";
$loq_obs3 = "";
$loq_obs4 = "";
$loq_obs5 = "";
$loq_obs6 = "";
switch ($_POST['id']) {
case '030202':
$sqlC="SELECT ctg_ttc_id FROM ctg_tipo_tramites_categorias WHERE substring(ctg_ttc_eva,1,1) = '1' AND ctg_tpr_id = '".$_POST['ctg_tpr_id']."' AND ctg_tpt_id = '".$_POST['ctg_tpt_id']."' ";
$resultC=$connection->Execute($sqlC);
if (!$resultC->EOF) {
$ADM="(";
while ( !$resultC->EOF ) {
if ( strlen($ADM)==1){
$ADM .="'".$resultC->fields[0]."'";
} else {
$ADM .=",'".$resultC->fields[0]."'";
}
$resultC->MoveNext ();
}
$ADM .=")";
}
$sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
\"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
\"vus_{$_POST['tipo']}CHK_ttc_id\" IN".$ADM." AND \"vus_{$_POST['tipo']}CHK_res4_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res4_st\"='0' AND
\"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
echo "SQL CUMULADO ADM ".$sql."
";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if (!$result->EOF) {
$tec_id="";
while ( !$result->EOF ) {
$nom_evaluator="";
$operador = $result->fields;
if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']==$tec_id){
$nom_document="";
$sqlD="SELECT ctg_ttd_id,ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs2 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res4_obs']."
";
} else {
//$loq_obs2.="
";
$sqlU="SELECT adm_usr_nombre,adm_usr_email_inhrr, adm_usr_email_per FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
$resultU=$connection->Execute($sqlU);
if (!$resultU->EOF) {
$nom_evaluator=$resultU->fields[0]." email(s):".$resultU->fields[1];
if ($resultU->fields[2]!=""){
$nom_evaluator .= ", ".$resultU->fields[2];
}
}
//$loq_obs2 .= "EVALUATOR : ".$nom_evaluator."
";
echo "ADM ".$loq_obs2."
";
$tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
$nom_document="";
$sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs2 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res4_obs']."
";
}
$result->MoveNext ();
}
}
echo "
ADM SUMMARY(".$loq_obs2.")";
break;
case "030203":
$sqlC="SELECT ctg_ttc_id FROM ctg_tipo_tramites_categorias WHERE (substring(ctg_ttc_eva,2,1) = '1' OR substring(ctg_ttc_eva,3,1) = '1' ) AND ctg_tpr_id = '".$_POST['ctg_tpr_id']."' AND ctg_tpt_id = '".$_POST['ctg_tpt_id']."' ";
$resultC=$connection->Execute($sqlC);
if (!$resultC->EOF) {
$QUA="(";
while ( !$resultC->EOF ) {
if ( strlen($QUA)==1){
$QUA .="'".$resultC->fields[0]."'";
} else {
$QUA .=",'".$resultC->fields[0]."'";
}
$resultC->MoveNext ();
}
$QUA .=")";
}
$sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
\"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
\"vus_{$_POST['tipo']}CHK_ttc_id\" IN ".$QUA." AND \"vus_{$_POST['tipo']}CHK_res5_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res5_st\"='0' AND
\"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
echo "SQL CUMULADO QUA ".$sql."
";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if (!$result->EOF) {
$tec_id="";
while ( !$result->EOF ) {
$nom_evaluator="";
$operador = $result->fields;
if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']==$tec_id){
$nom_document="";
$sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs3 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res5_obs']."
";
} else {
//$loq_obs2.="
";
$sqlU="SELECT adm_usr_nombre, adm_usr_email_inhrr, adm_usr_email_per FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
$resultU=$connection->Execute($sqlU);
if (!$resultU->EOF) {
$nom_evaluator=$resultU->fields[0]." email(s):".$resultU->fields[1];
if ($resultU->fields[2]!=""){
$nom_evaluator .= ", ".$resultU->fields[2];
}
}
// $loq_obs3 .= "EVALUATOR : ".$nom_evaluator."
";
$tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
$nom_document="";
$sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs3 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res5_obs']."
";
}
$result->MoveNext ();
}
}
break;
case "030204":
$sqlC="SELECT ctg_ttc_id FROM ctg_tipo_tramites_categorias WHERE substring(ctg_ttc_eva,3,1) = '1' AND ctg_tpr_id = '".$_POST['ctg_tpr_id']."' AND ctg_tpt_id = '".$_POST['ctg_tpt_id']."' ";
$resultC=$connection->Execute($sqlC);
if (!$resultC->EOF) {
$CLI="(";
while ( !$resultC->EOF ) {
if ( strlen($CLI)==1){
$CLI .="'".$resultC->fields[0]."'";
} else {
$CLI .=",'".$resultC->fields[0]."'";
}
$resultC->MoveNext ();
}
$CLI .=")";
}
$sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
\"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
\"vus_{$_POST['tipo']}CHK_ttc_id\" IN ".$CLI." AND \"vus_{$_POST['tipo']}CHK_res6_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res6_st\"='0' AND
\"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
echo "SQL CUMULADO CLI ".$sql."
";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if (!$result->EOF) {
$tec_id="";
while ( !$result->EOF ) {
$nom_evaluator="";
$operador = $result->fields;
if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']==$tec_id){
$nom_document="";
$sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs4 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res6_obs']."
";
} else {
//$loq_obs2.="
";
$sqlU="SELECT adm_usr_nombre, adm_usr_email_inhrr, adm_usr_email_per FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
$resultU=$connection->Execute($sqlU);
if (!$resultU->EOF) {
$nom_evaluator=$resultU->fields[0]." email(s):".$resultU->fields[1];
if ($resultU->fields[2]!=""){
$nom_evaluator .= ", ".$resultU->fields[2];
}
}
// $loq_obs4 .= "EVALUATOR : ".$nom_evaluator."
";
$tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
$nom_document="";
$sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs4 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res6_obs']."
";
}
$result->MoveNext ();
}
}
break;
case "0302041":
$sqlC="SELECT ctg_ttc_id FROM ctg_tipo_tramites_categorias WHERE substring(ctg_ttc_eva,3,1) = '1' AND ctg_tpr_id = '".$_POST['ctg_tpr_id']."' AND ctg_tpt_id = '".$_POST['ctg_tpt_id']."' ";
$resultC=$connection->Execute($sqlC);
if (!$resultC->EOF) {
$CNLI="(";
while ( !$resultC->EOF ) {
if ( strlen($NCLI)==1){
$NCLI .="'".$resultC->fields[0]."'";
} else {
$NCLI .=",'".$resultC->fields[0]."'";
}
$resultC->MoveNext ();
}
$NCLI .=")";
}
$sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
\"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
\"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
\"vus_{$_POST['tipo']}CHK_ttc_id\" IN ".$NCLI." AND \"vus_{$_POST['tipo']}CHK_res7_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res7_st\"='0' AND
\"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
echo "SQL CUMULADO N-CLI ".$sql."
";
$result=$connectionVUS->Execute($sql);
$error = $connectionVUS->ErrorMsg();
if (!$result->EOF) {
$tec_id="";
while ( !$result->EOF ) {
$nom_evaluator="";
$operador = $result->fields;
if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']==$tec_id){
$nom_document="";
$sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs5 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res7_obs']."
";
} else {
//$loq_obs2.="
";
$sqlU="SELECT adm_usr_nombre, adm_usr_email_inhrr, adm_usr_email_per FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
$resultU=$connection->Execute($sqlU);
if (!$resultU->EOF) {
$nom_evaluator=$resultU->fields[0]." email(s):".$resultU->fields[1];
if ($resultU->fields[2]!=""){
$nom_evaluator .= ", ".$resultU->fields[2];
}
}
// $loq_obs5 .= "EVALUATOR : ".$nom_evaluator."
";
$tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
$nom_document="";
$sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
\"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
\"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
\"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
\"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
$resultD=$connection->Execute($sqlD);
if (!$resultD->EOF) {
$nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
}
$loq_obs5 .= $nom_document.":
".$operador['vus_'.$_POST['tipo'].'CHK_res7_obs']."
";
}
$result->MoveNext ();
}
}
break;
}
// $sqlfind = "SELECT * FROM adm_control_{$_POST['tipo']}_loq WHERE
// adm_con_tpr_id = '{$_POST['ctg_tpr_id']}' AND
// adm_con_tpt_id = '{$_POST['ctg_tpt_id']}' AND
// adm_con_numsol = '{$_POST['codigo']}' AND
// adm_con_cou_id = '{$codepais}' ";
// //echo "find ".$sqlfind."
";
// $resultf=$connection->Execute($sqlfind);
// if ( $resultf->EOF) {
// $usuario = $_SESSION['ADMusuario_id'];
// $sql="SELECT * FROM adm_usuarios WHERE adm_usr_ci = '{$usuario}' ";
// $result = $connection->Execute ($sql);
// if (! $result->EOF) {
// $operador = $result->fields;
// $geogra = $operador['ctg_geo_id'];
// $sql="SELECT * FROM ctg_geografia WHERE ctg_geo_id = '{$geogra}' ";
// $result = $connection->Execute ($sql);
// if (! $result->EOF) {
// $operador = $result->fields;
// $codepais = trim($operador['ctg_geo_pais']);
// $sql="SELECT * FROM ctg_geografia WHERE ctg_geo_id = '{$codepais}' ";
// $result = $connection->Execute ($sql);
// if (! $result->EOF) {
// $operador = $result->fields;
// $descpais = $operador['ctg_geo_desc'];
// }
// }
// }
// $sqlloq="INSERT INTO adm_control_{$_POST['tipo']}_loq (
// adm_con_numsol,
// adm_con_tpt_id,
// adm_con_tpr_id,
// adm_con_nomprod,
// adm_con_usr_id,
// adm_con_cou_id,
// adm_con_cou_de,
// adm_con_sta_02,
// adm_con_sta_03,
// adm_con_sta_04,
// adm_con_sta_05,
// adm_con_sta_06,
// adm_con_sta,
// adm_con_usr,
// adm_con_dt
// ) VALUES (
// '{$_POST['codigo']}',
// '{$_POST['ctg_tpt_id']}',
// '{$_POST['ctg_tpr_id']}',
// '{$full_name}',
// '{$usuario}',
// '{$codepais}',
// '{$descpais}',
// '0',
// '0',
// '0',
// '0',
// '0',
// '1',
// '".$usuario."',
// now()
// );";
// //echo "INSERT ".$sqlloq."
";
// $resultloq=$connection->Execute($sqlloq);
// }
// switch ($_POST['id']) {
// case '030202':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_loq SET
// adm_con_sta_02 = '".$_POST['status']."',
// adm_con_msg_02 = '".$obs."
".$loq_obs2."',
// adm_con_sta = '2',
// adm_con_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ";
// break;
// case '030203':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_loq SET
// adm_con_sta_03 = '".$_POST['status']."',
// adm_con_msg_03 = '".$obs."
".$loq_obs3."',
// adm_con_sta = '2',
// adm_con_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ";
// break;
// case '030204':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_loq SET
// adm_con_sta_04 = '".$_POST['status']."',
// adm_con_msg_04 = '".$obs."
".$loq_obs4."',
// adm_con_sta = '2',
// adm_con_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ";
// break;
// case '0302041':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_loq SET
// adm_con_sta_05 = '".$_POST['status']."',
// adm_con_msg_05 = '".$obs."
".$loq_obs5."',
// adm_con_sta = '2',
// adm_con_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ";
// break;
// case '0302042':
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_loq SET
// adm_con_sta_06 = '".$_POST['status']."',
// adm_con_msg_06 = '".$obs."
".$loq_obs6."',
// adm_con_sta = '2',
// adm_con_usr = '".$_SESSION['ADMusuario_id']."',
// adm_con_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_con_numsol = '".$_POST['codigo']."' AND adm_con_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_con_tpt_id = '".$_POST['ctg_tpt_id']."' ";
// break;
// }
// echo "LOQ SQL ".$sql."
";
// $result = $connection->Execute ( $sql );
// $obstec="";
// switch ($_POST['id']) {
// case '030202':
// $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
// \"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
// \"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
// \"vus_{$_POST['tipo']}CHK_ttc_id\" = 'ADM' AND \"vus_{$_POST['tipo']}CHK_res4_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res4_st\"='0' AND
// \"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
// $result=$connectionVUS->Execute($sql);
// $error = $connectionVUS->ErrorMsg();
// if (!$result->EOF) {
// $tec_id="";
// while ( !$result->EOF ) {
// $nom_document="";
// $nom_evaluator="";
// $operador = $result->fields;
// if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']!=$tec_id){
// $sqlU="SELECT adm_usr_nombre FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
// $resultU=$connection->Execute($sqlU);
// if (!$resultU->EOF) {
// $nom_evaluator=$resultU->fields[0];
// }
// //$obstec .= "Evaluator:".$nom_evaluator."
";
// $tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
// }
// $sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
// \"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
// \"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
// \"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
// $resultD=$connection->Execute($sqlD);
// if (!$resultD->EOF) {
// $nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
// }
// $obstec .= $nom_document."
".$operador['vus_'.$_POST['tipo'].'CHK_res4_obs']."
";
// $result->MoveNext ();
// }
// }
// break;
// case "030203":
// $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
// \"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
// \"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
// \"vus_{$_POST['tipo']}CHK_ttc_id\" = 'QUA' AND \"vus_{$_POST['tipo']}CHK_res5_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res5_st\"='0' AND
// \"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
// $result=$connectionVUS->Execute($sql);
// $error = $connectionVUS->ErrorMsg();
// if (!$result->EOF) {
// $tec_id="";
// while ( !$result->EOF ) {
// $nom_document="";
// $nom_evaluator="";
// $operador = $result->fields;
// if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']!=$tec_id){
// $sqlU="SELECT adm_usr_nombre FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
// $resultU=$connection->Execute($sqlU);
// if (!$resultU->EOF) {
// $nom_evaluator=$resultU->fields[0];
// }
// //$obstec .= "Evaluator:".$nom_evaluator."
";
// $tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
// }
// $sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
// \"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
// \"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
// \"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
// $resultD=$connection->Execute($sqlD);
// if (!$resultD->EOF) {
// $nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
// }
// $obstec .= $nom_document."
".$operador['vus_'.$_POST['tipo'].'CHK_res5_obs']."
";
// $result->MoveNext ();
// }
// }
// break;
// case "030204":
// $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
// \"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
// \"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
// \"vus_{$_POST['tipo']}CHK_ttc_id\" = 'CLI' AND \"vus_{$_POST['tipo']}CHK_res6_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res6_st\"='0' AND
// \"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
// $result=$connectionVUS->Execute($sql);
// $error = $connectionVUS->ErrorMsg();
// if (!$result->EOF) {
// $tec_id="";
// while ( !$result->EOF ) {
// $nom_document="";
// $nom_evaluator="";
// $operador = $result->fields;
// if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']!=$tec_id){
// $sqlU="SELECT adm_usr_nombre FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
// $resultU=$connection->Execute($sqlU);
// if (!$resultU->EOF) {
// $nom_evaluator=$resultU->fields[0];
// }
// //$obstec .= "Evaluator:".$nom_evaluator."
";
// $tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
// }
// $sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
// \"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
// \"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
// \"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
// $resultD=$connection->Execute($sqlD);
// if (!$resultD->EOF) {
// $nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
// }
// $obstec .= $nom_document."
".$operador['vus_'.$_POST['tipo'].'CHK_res6_obs']."
";
// $result->MoveNext ();
// }
// }
// break;
// case "0302041":
// $sql="SELECT * FROM \"vus_tramites_{$_POST['tipo']}1_CHKl\" WHERE
// \"vus_{$_POST['tipo']}CHK_numsol\" = '".$_POST['codigo']."' AND
// \"vus_{$_POST['tipo']}CHK_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"vus_{$_POST['tipo']}CHK_tpt_id\" = '".$_POST['ctg_tpt_id']."' AND
// \"vus_{$_POST['tipo']}CHK_ttc_id\" = 'NCLI' AND \"vus_{$_POST['tipo']}CHK_res7_obs\" IS NOT NULL AND \"vus_{$_POST['tipo']}CHK_res7_st\"='0' AND
// \"vus_{$_POST['tipo']}CHK_tec_id\" = '".$_SESSION['ADMusuario_id']."' ORDER BY \"vus_{$_POST['tipo']}CHK_tec_id\",\"vus_{$_POST['tipo']}CHK_ttc_id\",\"vus_{$_POST['tipo']}CHK_ttd_id\"";
// $result=$connectionVUS->Execute($sql);
// $error = $connectionVUS->ErrorMsg();
// if (!$result->EOF) {
// $tec_id="";
// while ( !$result->EOF ) {
// $nom_document="";
// $nom_evaluator="";
// $operador = $result->fields;
// if ($operador['vus_'.$_POST['tipo'].'CHK_tec_id']!=$tec_id){
// $sqlU="SELECT adm_usr_nombre FROM adm_usuarios WHERE adm_usr_ci = '{$operador['vus_'.$_POST['tipo'].'CHK_tec_id']}'";
// $resultU=$connection->Execute($sqlU);
// if (!$resultU->EOF) {
// $nom_evaluator=$resultU->fields[0];
// }
// //$obstec .= "Evaluator:".$nom_evaluator."
";
// $tec_id=$operador['vus_'.$_POST['tipo'].'CHK_tec_id'];
// }
// $sqlD="SELECT ctg_ttd_id, ctg_ttd_desc FROM ctg_tipo_tramites_documentos WHERE
// \"ctg_ttd_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttd_id']."' AND
// \"ctg_ttc_id\" = '".$operador['vus_'.$_POST['tipo'].'CHK_ttc_id']."' AND
// \"ctg_tpr_id\" = '".$_POST['ctg_tpr_id']."' AND
// \"ctg_tpt_id\" = '".$_POST['ctg_tpt_id']."' ";
// $resultD=$connection->Execute($sqlD);
// if (!$resultD->EOF) {
// $nom_document=$resultD->fields[0]." - ".$resultD->fields[1];
// }
// $obstec .= $nom_document."
".$operador['vus_'.$_POST['tipo'].'CHK_res7_obs']."
";
// $result->MoveNext ();
// }
// }
// break;
// }
/////////////
// // Actualiza etapa 02 con info de boleta 2018-01-28
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '02' AND adm_coe_status='2'";
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1) {
// if ($info == "")
// $info = $arr_label['datos_grabados'];
// }
// Actualiza etapa 03 con info de boleta 2018-01-28
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '03' AND adm_coe_status='2'" ;
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1) {
// if ($info == "")
// $info = $arr_label['datos_grabados'];
// }
// Actualiza etapa 04 con info de boleta 2018-01-28
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '04' AND adm_coe_status='2'";
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1) {
// if ($info == "")
// $info = $arr_label['datos_grabados'];
// }
// Actualiza etapa 07 con info de boleta 2018-01-28
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '07' AND adm_coe_status='2'";
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1) {
// if ($info == "")
// $info = $arr_label['datos_grabados'];
// }
// Actualiza etapa 08 con info de boleta 2018-01-28
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp2
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '08' AND adm_coe_status='2'";
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1) {
// if ($info == "")
// $info = $arr_label['datos_grabados'];
// }
// adm_coe_res_dt = '".$_POST['res_dt']."',
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_status = '".$_POST['status']."',
// adm_coe_res_dt = '".date("Y-m-d H:i:s")."',
// $comp
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".$_POST['etapa']."'";
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1) {
// if ($info == "")
// $info = $arr_label['datos_grabados'];
// }
$quien=1;
} else echo "hay error
";
}
// $sql="UPDATE adm_control_{$_POST['tipo']}{$_SESSION['dtb_adm']}_etapas SET
// adm_coe_status = '{$_POST['status']}',
// adm_coe_obs = '{$_POST['obs']}',
// adm_coe_sta = '2',
// adm_coe_usr = '".$_SESSION['ADMusuario_id']."',
// adm_coe_dt = '".date("Y-m-d H:i:s")."'
// WHERE adm_coe_numsol = '".$_POST['codigo']."' AND adm_coe_tpr_id = '".$_POST['ctg_tpr_id']."' AND
// adm_coe_tpt_id = '".$_POST['ctg_tpt_id']."' AND adm_coe_tpe_id = '".substr($_POST['id'],4,2)."' ";
// echo "ETAPAS [".$sql."]
[".$error."]
[".$info."]
";
// $result = $connection->Execute ( $sql );
// $error = $connection->ErrorMsg();
// if ($connection->Affected_Rows() == 1) {
// if ($info == "")
// $info = $arr_label['datos_grabados'];
// }
if ($error == "") {
/*2014-10-23 temporalmente
if ($_POST['gendocx'] == '1') {
echo "
********** GENERA DOCUMENTO ***********
";
include("genera_resultado_evaluacion_pdf.php");//2012-09-18
echo "
********** fin ***********
";
$archivo_1="../".$location.$archivo;
$info .= "
![](\"includes/images/icon_pdf.png\")
Abrir PDF";
} else echo "no genera pdf";
*/
echo "******************************paso por aqui
";
} else echo "hay error
";
}
break;
}
if ($error != "") {
include_once("send_error_mail.php");
//$error = 1; 2012-07-14
$info = "";
}
$res_final = "";
if ($_POST["res_final"] == 3 || $_POST["res_final"] == 4)
$res_final = "{$_POST['tipo']}|{$_POST['codigo']}|{$_POST['ctg_tpt_id']}|{$_POST['ctg_tpr_id']}|{$_POST["res_final"]}";
$codigo = $_POST['codigo'];
echo "
codigo {$codigo}
quien ".$quien;
?>