<div class="row">

    <div class="col-lg-3 col-md-3 col-sm-3">        
        <a href="<?php echo web_root;?>/res/gate?b=vawaitreq">
            <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 DISTINCT(regst_id) AS regid, track_id, ct_names, sub_matt, reqtype_name,
                        requestDate FROM tbl_info_register i
                        INNER JOIN tbl_con_infos cn ON cn.reg_info_id=i.regst_id 
                        INNER JOIN tbl_clients c ON c.ct_id=i.clnt_id 
                        INNER JOIN tbl_reqs_type r ON r.reqtype_id=i.reqtype
                        WHERE reg_dept="'.$role_id.'" AND info_sts=2 AND con_doctype=3');
                        $infQue->execute();
                        echo $infQue->rowCount();
                        ?>
                        <small class="m-0 l-h-n">Awaiting Request(s)</small>
                    </h3>
                </div>
                <i class="fa fa-exclamation-circle 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=vrecreq">
            <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 DISTINCT(regst_id) AS regid, track_id, ct_names, sub_matt, reqtype_name,
                        requestDate FROM tbl_info_register i
                        INNER JOIN tbl_con_infos cn ON cn.reg_info_id=i.regst_id 
                        INNER JOIN tbl_clients c ON c.ct_id=i.clnt_id 
                        INNER JOIN tbl_reqs_type r ON r.reqtype_id=i.reqtype
                        WHERE reg_dept="'.$role_id.'" AND info_sts=9 AND con_doctype=3');
                        $infQue->execute();
                        echo $infQue->rowCount();
                        ?>
                        <small class="m-0 l-h-n">Received Request(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>
