//cabecera solicitud
$codsol = $_POST['codsol'];
$sqlquery = "select codsol,codcli,fecvensol,obssol,codestsol from tb_solicitud where codsol=" . $codsol;
$stmt = mysql_query($sqlquery);
while ($obj = mysql_fetch_object($stmt)) {
$arr[] = $obj;
}
echo '{"cabsolicitud":' . json_encode($arr) . '}';
break;
case 8:
//cabecera solicitud
session_start();
include "ftn_actestchk.php";
$usuregsol = $_SESSION['us3r1d'];
$codsol = $_POST['codsol'];
ftn_act_estadochk($codsol, $usuregsol);
$sqlquery = "SELECT ds.codsol,ds.codper,CONCAT(p.apepatper,' ',p.apematper,' ',p.nomper) AS nombre,p.codtipdoc,doc.destipdoc,p.numdocper,\r\n ds.codpacchk,pc.despacchk,ds.codpue,pu.despue,(\r\n SELECT r.desestchk FROM tb_estadocheck r,tmp_estactchk i\r\n WHERE i.loguser='******' AND r.codestchk=i.codestchk AND i.codsol=ds.codsol AND i.codper=ds.codper\r\n ) AS estado\r\n FROM tb_detallesolicitud ds LEFT JOIN tb_persona p ON ds.codper=p.codper\r\n LEFT JOIN tb_packcheck pc ON ds.codpacchk=pc.codpacchk\r\n LEFT JOIN tb_puesto pu ON ds.codpue=pu.codpue\r\n LEFT JOIN tb_tipdoc doc ON p.codtipdoc=doc.codtipdoc\r\n WHERE ds.codsol=" . $codsol;
//echo $sqlquery;
$stmt = mysql_query($sqlquery);
while ($obj = mysql_fetch_object($stmt)) {
$arr[] = $obj;
}
echo '{"detpersol":' . json_encode($arr) . '}';
break;
case 9:
//cabecera solicitud
$codsol = $_POST['codsol'];
$codper = $_POST['codper'];
$sqlquery = "select sp.codsol,sp.codper,sp.codpacchk,sp.codpue,c.nomobj,concat(p.apepatper,' ',p.apematper,', ',p.nomper) as nombre from tb_detallesolicitud sp\r\n right join tb_detallepackcheck pc on sp.codpacchk=pc.codpacchk\r\n right join tb_check c on pc.codchk=c.codchk\r\n right join tb_persona p on sp.codper=p.codper\r\n where sp.codsol=" . $codsol . " and sp.codper=" . $codper . " order by sp.codper,pc.codpacchk,pc.codchk";
$stmt = mysql_query($sqlquery);
while ($obj = mysql_fetch_object($stmt)) {
<?php
/**
* Actualizamos el estado de la solicitud a Finalizada siempre y cuando los checks de
* cada una de las personas asociadas a la solicitud tiene estado finalizado
* @version 1.0
* @author Ricardo De la Torre
* 17-04-2010
*/
include_once "connect.php";
$link = conectarse();
$dbh = conectaPDO();
$codsol = isset($_POST['codsol']) ? $_POST['codsol'] : $_GET['codsol'];
$logus = isset($_POST['logus']) ? $_POST['logus'] : $_GET['logus'];
include "ftn_actestchk.php";
ftn_act_estadochk($codsol, $logus);
$i = 0;
$iquery_ = mysql_query("select codestchk from tmp_estactchk where codsol={$codsol} order by 1 asc;");
while ($irow = mysql_fetch_array($iquery_)) {
if ($irow[0] != 3) {
$i++;
}
}
if ($i == 0) {
try {
mysql_query("UPDATE tb_solicitud SET fecciesol=NOW() WHERE codsol={$codsol};") or die(mysql_error());
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->beginTransaction();
$sql1 = "update tb_solicitud set codestsol=3 where codsol=:xcodsol";
$stmt = $dbh->prepare($sql1);
$stmt->execute(array(':xcodsol' => $codsol));
