$ip_int) {
$remote = false;
}
if ($ip_int==$ip_ext) {
$local_directory = "/var/www/html/siverc$location_vus/docs/solicitudes/{$_POST['codigo']}_{$anio1}_$mes1/";
$target_path = "http://$ip_ext$location_vus/docs/solicitudes/{$_POST['codigo']}_{$anio1}_$mes1/";
} else {
$local_directory = "/var/www/html/siverc$location_vus/docs/solicitudes/{$_POST['codigo']}_{$anio1}_$mes1/";
$target_path = "http://$ip_ext/user/docs/solicitudes/{$_POST['codigo']}_{$anio1}_$mes1/";
}
}
$copy_directory = true; // hay que verificar si se subieron los archivos
//porque no trae fabricante al leer desde el vus en empressas
//echo "local = $local_directory ";
//echo "remote = $target_path ";
if ($remote == false) {
$arr_name = array();
if ($handle = @ opendir($local_directory)) {
while (false !== ($entry = readdir($handle))) {
if (strlen($entry) > 3) {
$file = explode(".",$entry);
$file[0] = "***".$file[0];//." ";
if (strpos($file[0],"poder") > 0) $arr_name[ ($_POST['tipcta'] - 1) ] = $entry; // 0 , 1, 2, 3
if (strpos($file[0],"reg_mer") > 0) $arr_name[4] = $entry;
if (strpos($file[0],"reg_inf_fis") > 0) $arr_name[5] = $entry;
if (strpos($file[0],"cedula") > 0) $arr_name[6] = $entry;
if (strpos($file[0],"firma") > 0) $arr_name[7] = $entry;
if (strpos($file[0],"certificado") > 0) $arr_name[8] = $entry;
}
}
closedir($handle);
}
} else { //lee remoto
$files_rmt = 0;
$remote_directory = "/";
if ($ftp_server != "190.56.146.14")
$remote_directory .= "var/www/html/siverc";
$remote_directory .= "$location_vus/docs/solicitudes/{$_POST['codigo']}_{$anio1}_$mes1/";
//$local_directory = "/var/www/$location_adm/docs/usuarios/".$_POST['codigo']."/";
//echo "remote = $remote_directory ";
$ftp_connection = ftp_connect($ftp_server);
if (!$ftp_connection) {
echo "Couldn't connect to $ftp_server";
return false;
}
$ftp_username = "userftps";
$ftp_password = "passftp";
$connection_result = ftp_login($ftp_connection, $ftp_username, $ftp_password);
if (!$connection_result) {
echo(" $ftp_username user can't connect to $ftp_server ...");
return false;
} else {
//echo(" $ftp_username connected to $ftp_server ...");
}
$copy_directory = ftp_nlist($ftp_connection, $remote_directory);
if ($copy_directory == false ) {
echo "REMOTE DIRECTORY DOES NOT EXIST... " . $remote_directory;
} else {
foreach ($copy_directory as $i => $remote_file) {
$sf = explode("/",$remote_file);
$entry = $sf[count($sf)-1];
$file = explode(".",$entry);
if ($file[0] == "poder") $arr_name[ ($_POST['tipcta'] - 1) ] = $entry; // 0 , 1, 2, 3
if ($file[0] == "reg_mer") $arr_name[4] = $entry;
if ($file[0] == "reg_inf_fis") $arr_name[5] = $entry;
if ($file[0] == "cedula") $arr_name[6] = $entry;
if ($file[0] == "firma") $arr_name[7] = $entry;
if ($file[0] == "certificado") $arr_name[8] = $entry;
}
}
}
switch ($pais){
case "VEN":
switch ($_POST['tipcta']){
case 1: $show = "5,6,7"; break;//patrocinante
case 2: $show = "1,5,8"; break;//empresa 4 7
case 3: $show = "5,6,7"; break;//persona individual
case 4: $show = "3,6,7"; break;//funcionario MSDS
}
break;
case "GUT":
switch ($_POST['tipcta']){
case 1: $show = "0,5,6,7"; break;//patrocinante
case 2: $show = "1,4,5,7,8"; break;//empresa
case 3: $show = "2,4,5,6,7"; break;//persona individual
case 4: $show = "3,6,7"; break;//funcionario MSDS
}
break;
case "PAK":
switch ($_POST['tipcta']){
case 1: $show = "0,5,6,7"; break;//patrocinante
case 2: $show = "1,4,5,7,8"; break;//empresa
case 3: $show = "2,4,5,6,7"; break;//persona individual
case 4: $show = "3,6,7"; break;//funcionario MSDS
}
break;
case "LAO":
switch ($_POST['tipcta']){
case 1: $show = "0,6,7"; break;//patrocinante
case 2: $show = "1,4,5,7,8"; break;//empresa
case 3: $show = "2,6,7"; break;//persona individual
case 4: $show = "6,7"; break;//funcionario MSDS
}
break;
case "THA":
switch ($_POST['tipcta']){
case 1: $show = "0,6,7"; break;//patrocinante
case 2: $show = "1,4,5,7,8"; break;//empresa
case 3: $show = "6,7"; break;//persona individual
case 4: $show = "6,7"; break;//funcionario MSDS
}
break;
}
$arr_show = explode(",",$show);
//print_r($arr_name);
?>
";
$result=$connectionVUS->Execute($sql);
if (!$result->EOF) {
$_POST['accordion'] = 0;
?>
";
while ( !$result->EOF) { //vus_usuarios_poderes vus_solupp_sta --- vus_usuarios_poderes us_upp_sta
$operador = $result->fields;
?>
|
|
|
";
$result1=$connection->Execute($sql);
if (!$result1->EOF) {
$operador1 = $result1->fields;
echo "| ".$operador1['ctg_emp_rif']." | ".$operador1['ctg_emp_nombre'];
}
?>
|
|
|
|
";
$result1=$connectionVUS->Execute($sql);
if (!$result1->EOF) {
while ( !$result1->EOF ) {
$operador1 = $result1->fields;
echo "| ".$operador1[3]." | ".$operador1[4]." | ";
$result1->MoveNext ();
}
echo " ";
} else {
echo " | ";
echo " ".$arr_label['no_data']."";
}
echo "";
echo " ";
$result->MoveNext ();
}
echo " ";
}
?>
|
|
|
|
|
|
|
|
|
|
| ".$arr_label['tipo_producto']." |
".$arr_label['costo']." |
".$arr_label['cuotas']." |
".$arr_label['sub_total']." |
| ";
$sql="SELECT * FROM vus_usuarios_solicitudes_pagos WHERE vus_solpag_num = '".$_POST['codigo']."' ORDER BY vus_solpag_tpr_id";
//echo $sql."
";
$result=$connectionVUS->Execute($sql);
if (!$result->EOF) {
while ( !$result->EOF ) {
$operador = $result->fields;
//$sql="SELECT * FROM ctg_tipo_productos, ctg_tipo_productos_areas WHERE ctg_tpr_id=ctg_tpa_tpr_id AND ctg_tpr_id='".$operador['vus_solpag_tpr_id']."' ORDER BY ctg_tpr_id";
$sql="SELECT * FROM ctg_tipo_productos WHERE ctg_tpr_id='".$operador['vus_solpag_tpr_id']."'";
//echo $sql."
";
$result1=$connection->Execute($sql);
if (!$result1->EOF) {
$operador1 = $result1->fields;
switch ($_POST['tipcta']){
case '1':$costo = $operador1["ctg_tpr_cuopat"]; break;
case '2':$costo = $operador1["ctg_tpr_cuoemp"]; break;
case '3':$costo = $operador1["ctg_tpr_cuoper"]; break;
case '4':$costo = $operador1["ctg_tpr_cuofun"]; break;
}
echo "";
echo "| ".$operador1["ctg_tpr_desc"]." | ";
echo "".number_format($costo, 2, $decimal, $thousands)." | ";
echo "".$operador["vus_solpag_pagcuo"]." | ";
echo "".number_format($operador["vus_solpag_pagval"], 2, $decimal, $thousands)." | ";
echo " ";
}
$result->MoveNext ();
}
echo " | ".$arr_label['total_pagado']." | ".number_format($_POST['pagmonto'], 2, $decimal, $thousands)." | ";
} else {
echo "";
echo " ".$arr_label['no_data']."";
}
?>
|