<?php
include_once '../session.php';
include_once '../config.php';
$pagetitle="الشركات";
include_once "../header.php";
if (isset($_POST['add_new_comp'])) {
    $check_data_companies = row_one('companies',"name='".$_POST['name']."'","");
    if(empty($check_data_companies)){
      $val = array();
      $id= generate_rand_num("companies", "id", 1, 8, 4, 2);
      $val['id'] =$id;
      $val['name'] = $_POST['name'];
      $val['created_at'] = date('Y-m-d H:i:s');
      Insertdb("companies", $val);
      $response="تم إضافة الشركه بنجاح";
  }
}
//delete
if (isset($_POST["delete_comp"])) {
  $get_info_admin=row_one('companies',"id='".$_POST['comp_id']."'","");
  $val = array();
  Del("companies", "id='".$_POST["comp_id"]."'");
   $response="تم حذف الشركه بنجاح";
}
//show
if(isset($_GET['page_id'])) { $pid = $_GET['page_id']; }else{ $pid = 0; }
if(isset($_POST['search'])){
  $WHERE = "WHERE (".get_cols_using_LIKE("companies", $_POST['search_text']).")";
}else{
  $WHERE = "";
}
$get_companies = Pager("companies $WHERE","companies_page=",$pid,1,200,"created_at DESC");
?>
<div class="wrapper">
  <div class="container-fluid">
    <div class="row">
      <div class="col-12">
        <div class="page-title-box">
          <div class="page-title-right">
          </div>
          <h4 class="page-title">الشركات</h4>
        </div>
      </div>
    </div>
    <div class="row">
      <div class="col-lg-12">
        <div class="card-box">
          <?php if(!empty($response)){echo create_alert("info",$response,"");}?>
          <form method="post">
            <div class="row">
              <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12">
                <div class="form-group">
                  <?php echo tag_modal("add_new_comp","btn btn-success","fa fa-plus","إضافـة شركة جديدة");?>
                </div>
              </div>
              <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12">
                <div class="form-group">
                  <input type="text" class="form-control" name="search_text" placeholder="إسـم الشركة">
                </div>
              </div>
              <div class="col-lg-2 col-md-2 col-sm-6 col-xs-6">
                <div class="form-group">
                  <button type="submit" name="search" class="btn btn-danger"> <span class="fa fa-search"></span>  بحث وعرض </button>
                </div>
              </div>
              <div class="col-lg-2 col-md-2 col-sm-6 col-xs-6">
                <div class="form-group">
                  <p class="btn btn-danger" style="background-color: #435966 !important; border-color:#435966 !important;">
                    <span class="fas fa-user-friends"></span>
                    <?php
                    echo NUM_with_Text(
                      NUM("companies",""),
                      "شركه",
                      "شركه واحـده",
                      "شركتان",
                      "شركات",
                      "لا توجد شركات حتى الآن"
                    );
                    ?>
                  </p>
                </div>
              </div>
            </div>
          </form>
          <?php
           if(NUM("companies","") == 0){
          echo "<center>";
          echo "لا توجد شركات حتى الآن";
          echo "</center>";
          }else{
           if(!empty($get_companies[1])){echo '<hr>';} echo $get_companies[1]; if(!empty($get_companies[1])){echo '<hr>';} ?>
          <div class="table-responsive">
            <table class="table table-bordered mobile_tables mb-0">
              <thead>
                <tr>
                  <th>#</th>
                  <th>إسـم الشركة</th>
                  <th>أُضيـفت فـي</th>
                  <th>الإجـراءات</th>
                </tr>
              </thead>
              <tbody>
                <?php
                foreach ($get_companies as $companies):
                  if (is_array($companies) or is_object($companies)){
                    foreach ($companies as  $counetr => $get_info_company):?>
                      <tr>
                        <td class="text-center" data-title="#"><?php echo $counetr+1; ?></td>
                        <td data-title="إسـم الشركه"><?php echo $get_info_company['name'];?></td>

                          <td data-title="أُضيفت في"><?php echo datetime_to_string_ar($get_info_company['created_at']);?></td>
                          <td data-title="الإجرائات">
                            <?php

                            echo tag_modal("delete_comp_".$get_info_company['id'],"btn btn-xs btn-danger","mdi mdi-trash-can-outline","");
                            ?>
                          </td>
                        </tr>
                        <?php
                      endforeach;
                    }
                  endforeach;
                  ?>
                </tbody>
              </table>
            </div>
            <?php }
            if(!empty($get_companies[1])){echo '<hr>';} echo $get_companies[1]; if(!empty($get_companies[1])){echo '<hr>';} ?>
          </div>
        </div>
      </div>
      <?php
        foreach ($get_companies as $companies):
                  if (is_array($companies) or is_object($companies)){
                    foreach ($companies as  $counetr => $get_info_company):
            $add_new_requirement_body= '
            <div class="form-group">
            <label> هـل تـرغب بـحذف الشركه ؟</label>
            </div>';
            echo create_modal(
              "delete_comp_".$get_info_company['id'],
              '',
              'حذف الشركه ('.$get_info_company['name'].')',
              $add_new_requirement_body,
              'POST',
              '',
              '',
              'delete_comp',
              'btn btn-xs btn-success',
              'نعـم',
              'btn btn-xs btn-danger',
              'لا',
              create_input('','hidden','comp_id',$get_info_company['id'],"","")
            );
          endforeach;
        }
      endforeach;
      $add_new_requirement_body= '
      <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
      '.create_input('إسـم الشركه','text','name','','form-control','').'
      </div>';
      echo create_modal(
        'add_new_comp',
        '',
        'إضافـة شركه جديدة',
        $add_new_requirement_body,
        'POST',
        '',
        '',
        'add_new_comp',
        'btn btn-xs btn-primary',
        'إضافـة البـيانات',
        'btn btn-xs btn-warning',
        'إغـلاق النافـذة',
        '');
        ?>
      </div>
    </div>
    <?php include_once "../footer.php";?>