
<div class="row">
    <?php 
    if($pvge==1){
    ?>
    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="<?php echo web_root;?>res/gate?b=mytsk">
            <div class="p-3 bg-primary-500 rounded overflow-hidden position-relative text-white mb-g">
                <div class="">
                    <h3 class="display-4 d-block l-h-n m-0 fw-500">
                        <?php 
                        $infQue = $db->prepare('SELECT *FROM tbl_info_register i
                        INNER JOIN tbl_con_infos c ON c.reg_info_id=i.regst_id 
                        WHERE dRcv="'.$role_id.'" AND i.reqtype=1 AND con_doctype=3 AND i.stts_reg=5');
                        $infQue->execute();
                        echo $infQue->rowCount();
                        ?>
                        <small class="m-0 l-h-n">My Task(s)</small>
                    </h3>
                </div>
                <i class="fa fa-bell position-absolute pos-right pos-bottom opacity-15 mb-n1 mr-n1" style="font-size:6rem"></i>
            </div>        
        </a>   
    </div>
    <?php 
    }
    ?>

    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="<?php echo web_root;?>res/gate?b=ontsk">
            <div class="p-3 bg-primary-500 rounded overflow-hidden position-relative text-white mb-g">
                <div class="">
                    <h3 class="display-4 d-block l-h-n m-0 fw-500">
                        <?php 
                        if($pvge==2){
                        $infQue = $db->prepare('SELECT *FROM tbl_info_register i
                        INNER JOIN tbl_con_infos c ON c.reg_info_id=i.regst_id 
                        INNER JOIN tbl_assign_reqs a ON a.conasgn=c.con_info_id 
                        WHERE dRcv="'.$role_id.'" AND i.reqtype=1 AND asgn_appoint="'.$tle_id.'" AND con_doctype=3 AND i.stts_reg=6');
                        }else{
                        $infQue = $db->prepare('SELECT *FROM tbl_info_register i
                        INNER JOIN tbl_con_infos c ON c.reg_info_id=i.regst_id 
                        WHERE dRcv="'.$role_id.'" AND i.reqtype=1 AND con_doctype=3 AND i.stts_reg=6');  
                        }
                        $infQue->execute();
                        echo $infQue->rowCount();
                        ?>
                        <small class="m-0 l-h-n">On-Task(s)</small>
                    </h3>
                </div>
                <i class="fa fa-exchange position-absolute pos-right pos-bottom opacity-15 mb-n1 mr-n1" style="font-size:6rem"></i>
            </div>        
        </a>   
    </div>
   
    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="<?php echo web_root;?>res/gate?b=awaitboqd">
            <div class="p-3 bg-primary-500 rounded overflow-hidden position-relative text-white mb-g">
                <div class="">
                    <h3 class="display-4 d-block l-h-n m-0 fw-500">
                      <?php 
                        $checkBoq = $db->prepare('SELECT *FROM tbl_con_infos c
                        INNER JOIN tbl_info_register i ON i.regst_id=c.reg_info_id
                        WHERE dRcv="'.$role_id.'" AND con_doctype=3 AND c.info_sts=8');
                        $checkBoq->execute();                        
                        echo $checkBoq->rowCount();
                      ?>
                      <small class="m-0 l-h-n">Awaiting for BoQ & Design</small>
                    </h3>
                </div>
                <i class="fa fa-spinner position-absolute pos-right pos-bottom opacity-15 mb-n1 mr-n1" style="font-size:6rem"></i>
            </div>        
        </a>   
    </div>

    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="#">
            <div class="p-3 bg-primary-500 rounded overflow-hidden position-relative text-white mb-g">
                <div class="">
                    <h3 class="display-4 d-block l-h-n m-0 fw-500">
                      0
                      <small class="m-0 l-h-n">Handover</small>
                    </h3>
                </div>
                <i class="fa fa-bell position-absolute pos-right pos-bottom opacity-15 mb-n1 mr-n1" style="font-size:6rem"></i>
            </div>        
        </a>   
    </div>

    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="<?php echo web_root;?>res/gate?b=cptereq">
            <div class="p-3 bg-primary-500 rounded overflow-hidden position-relative text-white mb-g">
                <div class="">
                    <h3 class="display-4 d-block l-h-n m-0 fw-500">
                      <?php 
                        $completeReq=$db->prepare('SELECT *FROM tbl_con_infos c
                        INNER JOIN tbl_info_register i ON i.regst_id=c.reg_info_id
                        WHERE dRcv="'.$role_id.'" AND con_doctype=3 AND c.info_sts=3');
                        $completeReq->execute();
                        echo $completeReq->rowCount();
                      ?>
                      <small class="m-0 l-h-n">Completed Requests</small>
                    </h3>
                </div>
                <i class="fa fa-check position-absolute pos-right pos-bottom opacity-15 mb-n1 mr-n1" style="font-size:6rem"></i>
            </div>        
        </a> 
          
    </div>

    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="<?php echo web_root;?>/res/gate?b=ongoingp">
            <div class="p-3 bg-primary-500 rounded overflow-hidden position-relative text-white mb-g">
                <div class="">
                    <h3 class="display-4 d-block l-h-n m-0 fw-500">
                        <?php 
                        $newpj=$db->prepare('SELECT *FROM tbl_projects WHERE prjsts=12');      
                        $newpj->execute();    
                        echo $newpj->rowCount();         
                        ?>                        
                        <small class="m-0 l-h-n">Ongoing Project(s)</small>
                    </h3>
                </div>

                <i class="fa fa-circle-o-notch position-absolute pos-right pos-bottom opacity-15 mb-n1 mr-n1" style="font-size:6rem"></i>
            </div>        
        </a>   
    </div>

    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="<?php echo web_root;?>/res/gate?b=cpteproj">
            <div class="p-3 bg-primary-500 rounded overflow-hidden position-relative text-white mb-g">
                <div class="">
                    <h3 class="display-4 d-block l-h-n m-0 fw-500">
                        <?php 
                        $newpj=$db->prepare('SELECT *FROM tbl_projects WHERE prjsts=10');      
                        $newpj->execute();    
                        echo $newpj->rowCount();         
                        ?>                        
                        <small class="m-0 l-h-n">Completed Project(s)</small>
                    </h3>
                </div>

                <i class="fa fa-check-circle position-absolute pos-right pos-bottom opacity-15 mb-n1 mr-n1" style="font-size:6rem"></i>
            </div>        
        </a>   
    </div>

</div>