<?php
    session_start();
    if(isset($_SESSION['u_id'])){
        
    
        # include db config 
        include_once("config.php");
        
        include("phpgrid/lib/inc/jqgrid_dist.php");
        #include(PHPGRID_LIBPATH."inc/jqgrid_dist.php"); 
    
    
        
        # Database config file to be passed in phpgrid constructor 
        $db_conf = array("type"         => PHPGRID_DBTYPE,  
                        "server"       => PHPGRID_DBHOST, 
                        "user"         => PHPGRID_DBUSER, 
                        "password"     => PHPGRID_DBPASS, 
                        "database"     => PHPGRID_DBNAME); 
                 
    
    
        # create contacts grid 
        $g = new jqgrid($db_conf);
        
        #Set table specific options
        $opt = array();
        $opt['caption']= "Contacts Grid";
        #$opt['responsive'] = true; NOT WORKING SJH 7/28/17
        #$opt['shrinkToFit']= true; NOT WORKING SJH 7/28/17
        $opt['autowidth']= true;
        $opt['autoresize']= true; #THIS IS THE RESPONSIVE OPTION!!
        
        
        #Set the client side event handler option
        $opt["onSelectRow"]="function(id){do_onselect(id);}"; 
        $g->set_options($opt);
        $g->table = "tblContacts";
        
        
        #Set column specific options
        $col=array();
        $col["title"] ="Id";
        $col["name"] ="ID";
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $col["resizable"] = true;
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="First Name";
        $col["name"] ="First Name";
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Last Name";
        $col["name"] ='Last Name';
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="PO Box";
        $col["name"] ='con_pobox';
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Address";
        $col["name"] ="con_address";
        $col["width"]="30";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="City";
        $col["name"] ="con_city";
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="State";
        $col["name"] ='con_state';
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Zip";
        $col["name"] ='con_zip';
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Building Name";
        $col["name"] ="building_name";
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Building Id";
        $col["name"] ="building_id";
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Company";
        $col["name"] ="company";
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Decision Maker";
        $col["name"] ="decision_maker";
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Email";
        $col["name"] ="E-mail Address";
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Business Phone";
        $col["name"] ="Business Phone";
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        /*$col=array();
        $col["title"] ="BusExt";
        $col["name"] ='Extension';
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;*/
        
        /*$col=array();
        $col["title"] ="Fax";
        $col["name"] ="fax";
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;*/
        
        $col=array();
        $col["title"] ="Company";
        $col["name"] ="company";
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        $col=array();
        $col["title"] ="Email Contact";
        $col["name"] ='it_email_cont';
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;
        
        /*$col=array();
        $col["title"] ="Mobile Phone";
        $col["name"] ='Mobile Phone';
        $col["width"]="20";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $cols[]=$col;*/
        
        $col=array();
        $col["title"] ="SD User Id";
        $col["name"] ="StarDoc_User_id";
        $col["width"]="10";
        $col["editable"]=false;
        $col["visible"]="sm+";
        $col["resizable"] = true;
        $cols[]=$col;
        
        
        
        
        
        #Set the cols as the options were specified
        $g->set_columns($cols);
        
        
        // you can provide custom SQL query to display data
        //$g->select_command = 'SELECT id, building_name, building_id, "Last Name", "First Name", con_address,
        //    con_pobox, con_state, con_city, con_zip, "E-mail Address", "Business Phone", company, it_email_cont FROM tblContacts';
        #"SELECT * FROM contact_types";
        
        $out=$g->render("list1");
    }#end if
?>
        <!--get id value of selected phpGrid row-->
        <script>
            function get_val(){
                var selr = jQuery('#list1').jqGrid('getGridParam','selrow'); // returns null if no row is selected (single row)
                var rd = jQuery('#list1').jqGrid('getCell', selr, 'ID');//This id should be the same case as the primary key name. (I believe)
                
                return rd;
            }
            
            function do_onselect(id){ 
                var rd=jQuery('#list1').jqGrid('getCell', id, 'address');//This id should be lowercase.  It means the id of the row.
                jQuery("#anchorId").html(rd);
                
                //Call get_val to get the selected id in phpGrid
                var idval = get_val();
                
                //alert(idval + " was selected");
                
                //assign value of selected id in phpGrid to hidden input, anchorId
                document.getElementById("anchorId").value = idval;
                
                //submit the form so the POST value of anchorId will be available
                
                /* I want whichever form that was included to be submitted, so use the index of the form instead of the name */
                document.forms[0].submit();
                
                //document.forms['contactsFormNew'].submit();
            }
        </script>

<body>
    <?php include('includes/myHeader.php'); ?>
    
    <div class="container-fluid" id="myWrapper">
        <?php
            include('includes/myLogoHeader.php');
                
            #if the user is logged in - show the navbar
            if(isset($_SESSION['u_id'])){
                include('includes/myNavbar.php');
                    
                /* Connect to the db to populate the upper panels.  These should be empty if no record
                    is selected in the phpGrid.  Otherwise, the record should contain same data as phpGrid. */
                require('../dmstestConnect.php');
                    
                /*If There is no row selected in the phpGrid, the anchorId is not set, so this is either the first
                    landing on the contacts page and the newContact page should be shown with no data in the upper
                    panel, OR the newContact page has been visited and the user has entered new data in the upper
                    panel and clicked the submit button. */
                if(!isset($_POST['anchorId'])){
                   include('includes/newContact.php');
                }
                /* Else the user has selected a row in the phpGrid, so the selectedContact pg should be shown */
                else{
                    include('includes/selectedContact.php');
                    #$_SESSION['rowSelected'] = 'y';
                }
                        
                    
                    
                    print("<div id='contactList'>");
                        print("<div id='contactsGrid'>");
                            print($out);
                        print("</div>");
                    print("</div>");
                    
                 include('includes/myFooter.php');
                }#end if
                
                #The user has not logged in
                else{
                    #Send the user to the login page
                    print("<script> window.location.replace('myLogin.php'); </script>");
                }
            ?>
            
            <!--testing access of grid elements
            <button onclick='get_val()'>Get Selected Value</button>-->
            
            
        </div><!--end myWrapper-->
 
</body>
</html>