コード例 #1
0
ファイル: tipSoporte.php プロジェクト: kractos26/orfeo
        switch ($_POST['btn_accion']) {
            case 'Agregar':
                $sql = "insert into MEDIO_RECEPCION(MREC_CODI, MREC_DESC,MREC_ENV,MREC_REC,MREC_PQR,ENVIO_DIRECTO) ";
                $sql .= "values (" . $_POST['txtId'] . ",'" . $_POST['txtModelo'] . "',{$env},{$rec},{$pqr}," . $_POST['envDirecto'] . ")";
                $conn->Execute($sql) ? $error = 3 : ($error = 2);
                break;
            case 'Modificar':
                $sql = "update MEDIO_RECEPCION set MREC_DESC = '" . $_POST['txtModelo'] . "',MREC_ENV = '" . $env . "',MREC_REC = '" . $rec . "',MREC_PQR = '" . $pqr . "',ENVIO_DIRECTO=" . $_POST['envDirecto'] . " ";
                $sql .= "where MREC_CODI = " . $_POST['txtId'];
                $conn->Execute($sql) ? $error = 4 : ($error = 2);
                break;
            case 'Eliminar':
                $sql = "SELECT COUNT(*) FROM SGD_MTR_MRECFENV WHERE MREC_CODI =" . $_POST['txtId'];
                $rr = $conn->GetOne($sql);
                if ($rr < 1) {
                    $ok = $obj_tmp->SetDelDatos($_POST['slc_cmb2']);
                } else {
                    $error = 2;
                }
                $ok == 0 ? $error = 5 : ($ok ? $error = null : ($error = 2));
                break;
            default:
                break;
        }
        unset($record);
    }
    $slc_tmp = $obj_tmp->Get_ComboOpc(true, true, 0, 1, 1, 1);
    $vec_tmp = $obj_tmp->Get_ArrayDatos();
} else {
    $error = 1;
}