<?php
    //require_once('../include/app.form-msessi.php');
    require_once('../include/app.form-config.php');
    require_once('../include/app.form-define.php');
    require_once('../include/app.form-mquery.php');
    require_once('../include/app.form-object.php');
    require_once('../include/app.form-design.php');

    class app extends XDesign
    {
        private $pgConnect;
        private $queQuery,$exeQuery,$resQuery;
        private $vElement1;
        private $vPage1;
        private $vTile1;

        function __construct()
        {
            $this->pgConnect = $this->sqlConnect(PG_DAT_DB);
        }
        function __destruct()
        {
            if($this->pgConnect){sqlsrv_close($this->pgConnect);}
        }

        function test()
        {
            $this->queQuery = "
                BEGIN
                    SET NOCOUNT ON;
                    DECLARE @tmp_table AS TABLE(
                        step_id VARCHAR(MAX),
                        step_name VARCHAR(MAX),
                        subsystem VARCHAR(MAX),
                        command VARCHAR(MAX),
                        flags VARCHAR(MAX),
                        cmdexec_success_code VARCHAR(MAX),
                        on_success_action VARCHAR(MAX),
                        on_success_step_id VARCHAR(MAX),
                        on_fail_action VARCHAR(MAX),
                        on_fail_step_id VARCHAR(MAX),
                        server VARCHAR(MAX),
                        database_name VARCHAR(MAX),
                        database_user_name VARCHAR(MAX),
                        retry_attempts VARCHAR(MAX),
                        retry_interval VARCHAR(MAX),
                        os_run_priority VARCHAR(MAX),
                        output_file_name VARCHAR(MAX),
                        last_run_outcome VARCHAR(MAX),
                        last_run_duration VARCHAR(MAX),
                        last_run_retries VARCHAR(MAX),
                        last_run_date VARCHAR(MAX),
                        last_run_time VARCHAR(MAX),
                        proxy_id VARCHAR(MAX)
                    );
                    INSERT @tmp_table
                    EXEC msdb.dbo.sp_help_job @job_name='UploadProcess', @job_aspect='STEPS';
                    SELECT * FROM @tmp_table WHERE step_name='Administrator';
                    RETURN;
                END
            ";
            //$this->queQuery = "EXEC process_upload_renewal ;";
            $this->exeQuery = sqlsrv_query($this->pgConnect,$this->queQuery,array(),array("Scrollable"=>SQLSRV_CURSOR_CLIENT_BUFFERED));
            $this->resQuery = sqlsrv_fetch_array($this->exeQuery,SQLSRV_FETCH_BOTH,SQLSRV_SCROLL_FIRST);
            return "FIELD=>".sqlsrv_num_fields($this->exeQuery).
                    "<br>ROWS=>".sqlsrv_num_rows($this->exeQuery).
                    "<br>METADATA". json_encode(sqlsrv_field_metadata($this->exeQuery)).
                    "<br>VALUES". $this->resQuery[0];
        }
    }

    $app        = new app();
    $action                 = "";
    if(isset($_GET["action"]))  { $action = $_GET["action"]; }
    if(isset($_POST["action"])) { $action = $_POST["action"]; }

    switch ($action)
    {
        case 'NEW':
            set_time_limit(0);
            print $app->test();
            break;

        default:
            # code...
            break;
    }
?>