JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-} .
LIBYA CYBER ARMY
Logo of a company Instagram@3g86    Server : Apache
System : Linux uta-edu.server.ly 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64
User : utripoli ( 1001)
PHP Version : 7.4.33
Disable Function : NONE
Directory :  /home/utripoli/www/cp/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/utripoli/www/cp/dash_online.php
<?php

// اتصال بقاعدة بيانات
require_once("../connection/connect.php");
$page_title = "إحصائيات المنصة الإلكترونية";
$page_select = "44";
require_once("include/header.php");
require_once("include/check.php");
require_once("include/locked.php");

// استجلاب بيانات الإعدادات
$dirsa->select_db($database_dirsa);
$query_setting_y = sprintf("SELECT * FROM setting_online where set_on_id=%s",
                    GetSQLValueString(1, "int"));
$setting_y = $dirsa->query($query_setting_y) or die($dirsa->error);
$row_setting_y = $setting_y->fetch_assoc();
$totalRows_setting_y = $setting_y->num_rows;

// إحصائيات بالمقرر الدراسي
$dirsa->select_db($database_dirsa);
$query_how_subject = sprintf("SELECT * FROM course where is_deleted is null and course_state=%s",
                  GetSQLValueString(1, "int"));
$how_subject = $dirsa->query($query_how_subject) or die($dirsa->error);
$row_how_subject = $how_subject->fetch_assoc();
$totalRows_how_subject = $how_subject->num_rows;

// إحصائيات بالجلسات لهذا الفصل
$dirsa->select_db($database_dirsa);
$query_how_session = sprintf("SELECT * FROM course_group where is_deleted is null and co_yaer=%s and group_state=%s",
                  GetSQLValueString($row_setting_y['set_year_id'], "int"),
                GetSQLValueString(1, "int"));
$how_session = $dirsa->query($query_how_session) or die($dirsa->error);
$row_how_session = $how_session->fetch_assoc();
$totalRows_how_session = $how_session->num_rows;

// إحصائيات بالأقسام
$dirsa->select_db($database_dirsa);
$query_how_department = sprintf("SELECT * FROM section where is_deleted is null and section_start_or_stop=%s",
                GetSQLValueString(1, "int"));
$how_department = $dirsa->query($query_how_department) or die($dirsa->error);
$row_how_department = $how_department->fetch_assoc();
$totalRows_how_department = $how_department->num_rows;

// إحصائيات بالطلبة
$dirsa->select_db($database_dirsa);
$query_how_student = "SELECT * FROM student where is_deleted is null";
$how_student = $dirsa->query($query_how_student) or die($dirsa->error);
$row_how_student = $how_student->fetch_assoc();
$totalRows_how_student = $how_student->num_rows;

// إحصائيات طلبات الحجز
$dirsa->select_db($database_dirsa);
$query_how_booking = sprintf("SELECT * FROM coruse_booking where co_state=%s and co_year=%s",
                            GetSQLValueString(1, "int"),
                            GetSQLValueString($row_setting_y['set_year_id'], "int"));
$how_booking = $dirsa->query($query_how_booking) or die($dirsa->error);
$row_how_booking = $how_booking->fetch_assoc();
$totalRows_how_booking = $how_booking->num_rows;
?>



          <!-- / Navbar -->

          <!-- Content wrapper -->
          <div class="content-wrapper">
            <!-- Content -->
            <div class="container-xxl flex-grow-1 container-p-y">
            <div class="row">
                <div class="col-lg-8 mb-4 order-0">
                  <div class="card">
                    <div class="d-flex align-items-end row">
                      <div class="col-sm-7">
                        <div class="card-body">
                          <h5 class="card-title text-primary">أهلا وسهلا بكم 🎉</h5>
                          <p class="mb-4">
                          المنصة الإلكترونية لجامعة طرابلس الأهلية
                          </p>
                          <p><b>الفصل الدراسي الحالي :  </b>
                            <?php
                           // استجلاب السنة الدراسية
                           $dirsa->select_db($database_dirsa);
                           $query_w_years = sprintf("SELECT * FROM years where year_id=%s",
                                               GetSQLValueString($row_setting_y['set_year_id'], "int"));
                           $w_years = $dirsa->query($query_w_years) or die($dirsa->error);
                           $row_w_years = $w_years->fetch_assoc();
                           $totalRows_w_years = $w_years->num_rows;
                            echo $row_w_years['year_name'];
                            ?>
                          </p>
                          <a href="setting_online.php" class="btn btn-sm btn-outline-primary">إعدادات</a>
                        </div>

                      </div>
                      <div class="col-sm-5 text-center text-sm-left">
                        <div class="card-body pb-0 px-0 px-md-4">
                          <img src="assets/img/illustrations/man-with-laptop-light.png" height="140" alt="View Badge User" data-app-dark-img="illustrations/man-with-laptop-dark.png" data-app-light-img="illustrations/man-with-laptop-light.png">
                        </div>
                      </div>
                    </div>
                  </div>
                </div>

                <div class="col-lg-4 col-md-4 order-1">
                  <div class="row">
                    <div class="col-lg-6 col-md-12 col-6 mb-4">
                      <div class="card">
                        <div class="card-body">
                          <div class="card-title d-flex align-items-start justify-content-between">
                            <div class="avatar flex-shrink-0">
                            <i class='bx bxs-book' style="font-size:42px;"></i>
                            </div>
                          </div>
                          <span class="fw-semibold d-block mb-1">المقررات</span>
                          <h3 class="card-title mb-2"><?php echo $totalRows_how_subject; ?></h3>
                        </div>
                      </div>
                    </div>
                    <div class="col-lg-6 col-md-12 col-6 mb-4">
                      <div class="card">
                        <div class="card-body">
                          <div class="card-title d-flex align-items-start justify-content-between">
                            <div class="avatar flex-shrink-0">
                            <i class='bx bxl-zoom' style="font-size:42px;"></i>
                            </div>
                           
                          </div>
                          <span class="fw-semibold d-block mb-1">الجلسات</span>
                          <h3 class="card-title text-nowrap mb-1"><?php echo $totalRows_how_session; ?></h3>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
                <!-- Total Revenue -->
                <div class="col-12 col-lg-8 order-2 order-md-3 order-lg-2 mb-4">
                    <div class="row">
                        <div class="col-sm-6">
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title">أخر الجلسات المضافة</h5>
                                    <?php
                                    // إحصائيات بالطلبة
                                 $dirsa->select_db($database_dirsa);
                                 $query_oop_cou = sprintf("SELECT * FROM course_group where is_deleted is null and co_yaer=%s and group_state=%s order by group_id desc LIMIT 10",
                                                      GetSQLValueString($row_setting_y['set_year_id'], "int"),
                                                      GetSQLValueString(1, "int"));
                                 $oop_cou = $dirsa->query($query_oop_cou) or die($dirsa->error);
                                 $row_oop_cou = $oop_cou->fetch_assoc();
                                 $totalRows_oop_cou = $oop_cou->num_rows;
?>
                                    <table class="table">
                                        <thead>
                                        <tr>
                                            <th scope="col">#</th>
                                            <th scope="col">اسم المقرر</th>
                                            <th scope="col">إجراء</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        <?php
                                        $start_num_course = 1;
                                        do { ?>
                                        <tr>
                                            <th scope="row"><?php echo $start_num_course; ?></th>
                                            <td><?php
                                                $dirsa->select_db($database_dirsa);
                                                $query_w_cous = sprintf("SELECT * FROM course where course_id=%s",
                                                    GetSQLValueString($row_oop_cou['group_id_course'], "int"));
                                                $w_cous = $dirsa->query($query_w_cous) or die($dirsa->error);
                                                $row_w_cous = $w_cous->fetch_assoc();
                                                $totalRows_w_cous = $w_cous->num_rows;

                                                $dirsa->select_db($database_dirsa);
                                                $query_w_sections = sprintf("SELECT * FROM section where section_id=%s",
                                                    GetSQLValueString($row_oop_cou['co_section'], "int"));
                                                $w_sections = $dirsa->query($query_w_sections) or die($dirsa->error);
                                                $row_w_sections = $w_sections->fetch_assoc();
                                                $totalRows_w_sections = $w_sections->num_rows;

                                                $dirsa->select_db($database_dirsa);
                                                $query_w_teacher_b = sprintf("SELECT * FROM book_teacher where book_group_id=%s",
                                                    GetSQLValueString($row_oop_cou['group_id'], "int"));
                                                $w_teacher_b = $dirsa->query($query_w_teacher_b) or die($dirsa->error);
                                                $row_w_teacher_b = $w_teacher_b->fetch_assoc();
                                                $totalRows_w_teacher_b = $w_teacher_b->num_rows;

                                              echo $row_w_cous['course_title']; ?></td>
                                            <td><button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#exampleModal<?php echo $row_oop_cou['group_id']; ?>">
                                                    إطلاع
                                                </button></td>
                                        </tr>
                                            <!-- Modal -->
                                            <div class="modal fade" id="exampleModal<?php echo $row_oop_cou['group_id']; ?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
                                                <div class="modal-dialog">
                                                    <div class="modal-content">
                                                        <div class="modal-header">
                                                            <h5 class="modal-title" id="exampleModalLabel"><?php echo $row_w_cous['course_title']; ?></h5>
                                                            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                                                        </div>
                                                        <div class="modal-body">
                                                            <center>
                                                                <?php if($totalRows_w_sections > 0) { ?>
                                                                <p>التخصص :
                                                                <?php
                                                                echo $row_w_sections['section_name']; ?>
                                                                </p>
                                                                <?php } ?>
                                                                <p>تاريخ بدء التسجيل:
                                                                <?php echo $row_oop_cou['group_reg_date_start']; ?>
                                                                </p>
                                                                <p>تاريخ انتهاء التسجيل:
                                                                <?php echo $row_oop_cou['group_reg_date_end']; ?>
                                                                </p>
                                                                <p>تاريخ البدء:
                                                                <?php echo $row_oop_cou['group_date_from']; ?>
                                                                </p>
                                                                <p>تاريخ الانتهاء:
                                                                <?php echo $row_oop_cou['group_date_to']; ?>
                                                                </p>
                                                                <?php     if($totalRows_w_teacher_b > 0) {  ?>
                                                                <p>المحاضرين:
                                                                  <ul>
                                                                <?php
                                                                do { ?>

                                                                  <li><?php
                                                                   $dirsa->select_db($database_dirsa);
                                                $query_w_teacher_b_b = sprintf("SELECT * FROM teachers where teacher_id=%s",
                                                    GetSQLValueString($row_w_teacher_b['book_teacher_id'], "int"));
                                                $w_teacher_b_b = $dirsa->query($query_w_teacher_b_b) or die($dirsa->error);
                                                $row_w_teacher_b_b = $w_teacher_b_b->fetch_assoc();
                                                $totalRows_w_teacher_b_b = $w_teacher_b_b->num_rows;

                                                                  echo $row_w_teacher_b_b['teacher_name']; ?></li>

                                                                <?php } while ($row_w_teacher_b = $w_teacher_b->fetch_assoc());  ?>
                                                                   </ul>
                                                            </p>
                                                                <?php } ?>
                                                        </div>
                                                        <div class="modal-footer">
                                                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">إغلاق</button>
                         
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                       <?php
                                            $start_num_course++;
                                        } while ($row_oop_cou = $oop_cou->fetch_assoc()); ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                        <div class="col-sm-6">
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title">روابط سريعة</h5>
                                    <a href="list_student.php"><p class="card-text">ملفات الطلبة</p></a>
                                    <a href="teaching-staff.php"><p class="card-text">أعضاء هيئة التدريس</p></a>
                                    <a href="course.php"><p class="card-text">المقررات الدراسية</p></a>
                                    <a href="madegroup.php"><p class="card-text">الجلسات</p></a>
                                    <a href="results.php"><p class="card-text">النتائج</p></a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!--/ Total Revenue -->
                <div class="col-12 col-md-8 col-lg-4 order-3 order-md-2">
                  <div class="row">
                    <div class="col-6 mb-4">
                      <div class="card">
                        <div class="card-body">
                          <div class="card-title d-flex align-items-start justify-content-between">
                            <div class="avatar flex-shrink-0">
                            <i class='bx bxs-vector' style="font-size:42px;"></i>
                            </div>

                          </div>
                          <span class="fw-semibold d-block mb-1">الاقسام</span>
                          <h3 class="card-title text-nowrap mb-2"><?php echo $totalRows_how_department; ?></h3>
                        </div>
                      </div>
                    </div>
                    <div class="col-6 mb-4">
                      <div class="card">
                        <div class="card-body">
                          <div class="card-title d-flex align-items-start justify-content-between">
                            <div class="avatar flex-shrink-0">
                            <i class='bx bxs-user' style="font-size:42px;"></i>
                            </div>

                          </div>
                          <span class="fw-semibold d-block mb-1">الطلبة</span>
                          <h3 class="card-title mb-2"><?php echo $totalRows_how_student; ?></h3>
                        </div>
                      </div>
                    </div>
                    <!-- </div>
    <div class="row"> -->
                    <div class="col-12 mb-4">
                      <div class="card">
                        <div class="card-body">
                          <div class="d-flex justify-content-between flex-sm-row flex-column gap-3" style="position: relative;">
                            <div class="d-flex flex-sm-column flex-row align-items-start justify-content-between">
                              <div class="card-title">
                                <h5 class="text-nowrap mb-2">طلبات الحجز</h5>
                                <span class="badge bg-label-warning rounded-pill"><?php echo $row_w_years['year_name']; ?></span>
                              </div>
                              <div class="mt-sm-auto">
                                <h3 class="mb-0"><?php echo $totalRows_how_booking; ?></h3>
                              </div>
                            </div>
                            <div id="profileReportChart" style="min-height: 80px;"><div id="apexchartsq56hs8vj" class="apexcharts-canvas apexchartsq56hs8vj apexcharts-theme-light" style="width: 120px; height: 80px;"><svg id="SvgjsSvg1704" width="120" height="80" xmlns="http://www.w3.org/2000/svg" version="1.1" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:svgjs="http://svgjs.dev" class="apexcharts-svg" xmlns:data="ApexChartsNS" transform="translate(0, 0)" style="background: transparent;"><g id="SvgjsG1706" class="apexcharts-inner apexcharts-graphical" transform="translate(0, 0)"><defs id="SvgjsDefs1705"><clipPath id="gridRectMaskq56hs8vj"><rect id="SvgjsRect1711" width="121" height="85" x="-4.5" y="-2.5" rx="0" ry="0" opacity="1" stroke-width="0" stroke="none" stroke-dasharray="0" fill="#fff"></rect></clipPath><clipPath id="forecastMaskq56hs8vj"></clipPath><clipPath id="nonForecastMaskq56hs8vj"></clipPath><clipPath id="gridRectMarkerMaskq56hs8vj"><rect id="SvgjsRect1712" width="116" height="84" x="-2" y="-2" rx="0" ry="0" opacity="1" stroke-width="0" stroke="none" stroke-dasharray="0" fill="#fff"></rect></clipPath><filter id="SvgjsFilter1718" filterUnits="userSpaceOnUse" width="200%" height="200%" x="-50%" y="-50%"><feFlood id="SvgjsFeFlood1719" flood-color="#ffab00" flood-opacity="0.15" result="SvgjsFeFlood1719Out" in="SourceGraphic"></feFlood><feComposite id="SvgjsFeComposite1720" in="SvgjsFeFlood1719Out" in2="SourceAlpha" operator="in" result="SvgjsFeComposite1720Out"></feComposite><feOffset id="SvgjsFeOffset1721" dx="5" dy="10" result="SvgjsFeOffset1721Out" in="SvgjsFeComposite1720Out"></feOffset><feGaussianBlur id="SvgjsFeGaussianBlur1722" stdDeviation="3 " result="SvgjsFeGaussianBlur1722Out" in="SvgjsFeOffset1721Out"></feGaussianBlur><feMerge id="SvgjsFeMerge1723" result="SvgjsFeMerge1723Out" in="SourceGraphic"><feMergeNode id="SvgjsFeMergeNode1724" in="SvgjsFeGaussianBlur1722Out"></feMergeNode><feMergeNode id="SvgjsFeMergeNode1725" in="[object Arguments]"></feMergeNode></feMerge><feBlend id="SvgjsFeBlend1726" in="SourceGraphic" in2="SvgjsFeMerge1723Out" mode="normal" result="SvgjsFeBlend1726Out"></feBlend></filter></defs><line id="SvgjsLine1710" x1="0" y1="0" x2="0" y2="80" stroke="#b6b6b6" stroke-dasharray="3" stroke-linecap="butt" class="apexcharts-xcrosshairs" x="0" y="0" width="1" height="80" fill="#b1b9c4" filter="none" fill-opacity="0.9" stroke-width="1"></line><g id="SvgjsG1727" class="apexcharts-xaxis" transform="translate(0, 0)"><g id="SvgjsG1728" class="apexcharts-xaxis-texts-g" transform="translate(0, -4)"></g></g><g id="SvgjsG1736" class="apexcharts-grid"><g id="SvgjsG1737" class="apexcharts-gridlines-horizontal" style="display: none;"><line id="SvgjsLine1739" x1="0" y1="0" x2="112" y2="0" stroke="#e0e0e0" stroke-dasharray="0" stroke-linecap="butt" class="apexcharts-gridline"></line><line id="SvgjsLine1740" x1="0" y1="20" x2="112" y2="20" stroke="#e0e0e0" stroke-dasharray="0" stroke-linecap="butt" class="apexcharts-gridline"></line><line id="SvgjsLine1741" x1="0" y1="40" x2="112" y2="40" stroke="#e0e0e0" stroke-dasharray="0" stroke-linecap="butt" class="apexcharts-gridline"></line><line id="SvgjsLine1742" x1="0" y1="60" x2="112" y2="60" stroke="#e0e0e0" stroke-dasharray="0" stroke-linecap="butt" class="apexcharts-gridline"></line><line id="SvgjsLine1743" x1="0" y1="80" x2="112" y2="80" stroke="#e0e0e0" stroke-dasharray="0" stroke-linecap="butt" class="apexcharts-gridline"></line></g><g id="SvgjsG1738" class="apexcharts-gridlines-vertical" style="display: none;"></g><line id="SvgjsLine1745" x1="0" y1="80" x2="112" y2="80" stroke="transparent" stroke-dasharray="0" stroke-linecap="butt"></line><line id="SvgjsLine1744" x1="0" y1="1" x2="0" y2="80" stroke="transparent" stroke-dasharray="0" stroke-linecap="butt"></line></g><g id="SvgjsG1713" class="apexcharts-line-series apexcharts-plot-series"><g id="SvgjsG1714" class="apexcharts-series" seriesName="seriesx1" data:longestSeries="true" rel="1" data:realIndex="0"><path id="SvgjsPath1717" d="M 0 76C 7.839999999999999 76 14.559999999999999 12 22.4 12C 30.24 12 36.96 62 44.8 62C 52.64 62 59.36 22 67.2 22C 75.03999999999999 22 81.75999999999999 38 89.6 38C 97.44 38 104.16 6 112 6" fill="none" fill-opacity="1" stroke="rgba(255,171,0,0.85)" stroke-opacity="1" stroke-linecap="butt" stroke-width="5" stroke-dasharray="0" class="apexcharts-line" index="0" clip-path="url(#gridRectMaskq56hs8vj)" filter="url(#SvgjsFilter1718)" pathTo="M 0 76C 7.839999999999999 76 14.559999999999999 12 22.4 12C 30.24 12 36.96 62 44.8 62C 52.64 62 59.36 22 67.2 22C 75.03999999999999 22 81.75999999999999 38 89.6 38C 97.44 38 104.16 6 112 6" pathFrom="M -1 120L -1 120L 22.4 120L 44.8 120L 67.2 120L 89.6 120L 112 120"></path><g id="SvgjsG1715" class="apexcharts-series-markers-wrap" data:realIndex="0"><g class="apexcharts-series-markers"><circle id="SvgjsCircle1751" r="0" cx="0" cy="0" class="apexcharts-marker w217rw7aj no-pointer-events" stroke="#ffffff" fill="#ffab00" fill-opacity="1" stroke-width="2" stroke-opacity="0.9" default-marker-size="0"></circle></g></g></g><g id="SvgjsG1716" class="apexcharts-datalabels" data:realIndex="0"></g></g><line id="SvgjsLine1746" x1="0" y1="0" x2="112" y2="0" stroke="#b6b6b6" stroke-dasharray="0" stroke-width="1" stroke-linecap="butt" class="apexcharts-ycrosshairs"></line><line id="SvgjsLine1747" x1="0" y1="0" x2="112" y2="0" stroke-dasharray="0" stroke-width="0" stroke-linecap="butt" class="apexcharts-ycrosshairs-hidden"></line><g id="SvgjsG1748" class="apexcharts-yaxis-annotations"></g><g id="SvgjsG1749" class="apexcharts-xaxis-annotations"></g><g id="SvgjsG1750" class="apexcharts-point-annotations"></g></g><rect id="SvgjsRect1709" width="0" height="0" x="0" y="0" rx="0" ry="0" opacity="1" stroke-width="0" stroke="none" stroke-dasharray="0" fill="#fefefe"></rect><g id="SvgjsG1735" class="apexcharts-yaxis" rel="0" transform="translate(-18, 0)"></g><g id="SvgjsG1707" class="apexcharts-annotations"></g></svg><div class="apexcharts-legend" style="max-height: 40px;"></div><div class="apexcharts-tooltip apexcharts-theme-light"><div class="apexcharts-tooltip-title" style="font-family: Helvetica, Arial, sans-serif; font-size: 12px;"></div><div class="apexcharts-tooltip-series-group" style="order: 1;"><span class="apexcharts-tooltip-marker" style="background-color: rgb(255, 171, 0);"></span><div class="apexcharts-tooltip-text" style="font-family: Helvetica, Arial, sans-serif; font-size: 12px;"><div class="apexcharts-tooltip-y-group"><span class="apexcharts-tooltip-text-y-label"></span><span class="apexcharts-tooltip-text-y-value"></span></div><div class="apexcharts-tooltip-goals-group"><span class="apexcharts-tooltip-text-goals-label"></span><span class="apexcharts-tooltip-text-goals-value"></span></div><div class="apexcharts-tooltip-z-group"><span class="apexcharts-tooltip-text-z-label"></span><span class="apexcharts-tooltip-text-z-value"></span></div></div></div></div><div class="apexcharts-yaxistooltip apexcharts-yaxistooltip-0 apexcharts-yaxistooltip-left apexcharts-theme-light"><div class="apexcharts-yaxistooltip-text"></div></div></div></div>
                          <div class="resize-triggers"><div class="expand-trigger"><div style="width: 258px; height: 117px;"></div></div><div class="contract-trigger"></div></div></div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
              </div>

            </div>
            <!-- / Content -->

<?php require_once("include/footer.php"); ?>

3g86 2022