PHP Employee::find_by_sql方法代码示例

 /**
  * the getList method is used to 
  * pupolate the listing table 
  */
 public function getList($id = "", $pg)
 {
     $purl = array();
     if (isset($_GET['url'])) {
         $purl = $_GET['url'];
         $purl = rtrim($purl);
         $purl = explode('/', $_GET['url']);
     } else {
         $purl = null;
     }
     if (!isset($purl['2'])) {
         $pn = 1;
     } else {
         $pn = $purl['2'];
     }
     global $database;
     $resultEmployee = $database->db_query("SELECT * FROM employee");
     $pagin = new Pagination();
     //create the pagination object;
     $pagin->nr = $database->dbNumRows($resultEmployee);
     $pagin->itemsPerPage = 20;
     $customers = Employee::find_by_sql("SELECT * FROM employee " . $pagin->pgLimit($pn));
     $index_array = array("myemployee" => $customers, "mypagin" => $pagin->render($pg));
     return $index_array;
     return $index_array;
 }

 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $techEmp = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept='5'");
     $startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "techemp" => $techEmp);
     return $startups;
 }

 /**
  * the getList method is used to 
  * pupolate the listing table 
  */
 public function getList($id = "", $pg)
 {
     $purl = array();
     if (isset($_GET['url'])) {
         $purl = $_GET['url'];
         $purl = rtrim($purl);
         $purl = explode('/', $_GET['url']);
     } else {
         $purl = null;
     }
     if (!isset($purl['2'])) {
         $pn = 1;
     } else {
         $pn = $purl['2'];
     }
     $empname = "";
     $empdept = "";
     $emppost = "";
     /**
      * of all the filter fields if only one field is set
      */
     $filterResult = "";
     if (isset($_POST['empname']) && !empty($_POST['empname'])) {
         $empname .= " AND emp_fname = '" . $_POST['empname'] . "' OR emp_lname = '" . $_POST['empname'] . "' ";
     }
     if (isset($_POST['empdept']) && !empty($_POST['empdept'])) {
         $empdept .= " AND emp_dept='" . $_POST['empdept'] . "' ";
     }
     if (isset($_POST['emppost']) && !empty($_POST['emppost'])) {
         $emppost .= " AND emp_post='" . $_POST['emppost'] . "' ";
     }
     $filterResult .= " WHERE id !='' " . $empname . $empdept . $emppost;
     global $database;
     $resultEmployee = $database->db_query("SELECT * FROM employee");
     $pagin = new Pagination();
     //create the pagination object;
     $pagin->nr = $database->dbNumRows($resultEmployee);
     $pagin->itemsPerPage = 50;
     $customers = Employee::find_by_sql("SELECT * FROM employee " . $filterResult . " ORDER BY id DESC ");
     $index_array = array("myemployee" => $customers, "mypagin" => $pagin->render($pg));
     return $index_array;
 }

 /**
  * load initail data for support ticket form needed during 
  * creating and editing support ticket
  * data 
  */
 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $myproducts = Cproduct::find_all();
     /**
      * issues may arise that when database
      * is cleared emp_dept may not be 5
      */
     $techEmployee = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept = 5");
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "myproducts" => $myproducts, "techstaff" => $techEmployee);
     return $startups;
 }

 /**
  * load initail data for support ticket form needed during 
  * creating and editing support ticket
  * data 
  */
 public function getData()
 {
     global $database;
     $depts = Department::find_all();
     $role = Roles::find_all();
     $country = Country::find_all();
     $vendors = Vendor::find_all();
     $myproducts = Cproduct::find_all();
     $lastSignoff = array_shift($database->fetch_assoc($database->db_query("SELECT MAX(id) as lastID, prod_id FROM sign_off_form ")));
     $lastWorkSheet = array_shift($database->fetch_assoc($database->db_query("SELECT MAX(id) as lastID, prod_id FROM work_sheet_form ")));
     /**
      * issues may arise that when database
      * is cleared emp_dept may not be 5
      */
     $clients = Client::find_all();
     // print_r($clients);
     $techEmployee = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept = 5");
     $zone = Zone::find_by_sql("SELECT * FROM zone");
     $startups = array("clients" => $clients, "departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "myproducts" => $myproducts, "techstaff" => $techEmployee, "lastsf" => $lastSignoff, "lastws" => $lastWorkSheet);
     return $startups;
 }

$per_page = JOBS_PER_SEARCH;
$total_count = Employee::count_all_deactive();
$smarty->assign('total_count', $total_count);
$smarty->assign('page', $page);
$pagination = new Pagination($page, $per_page, $total_count);
$smarty->assign('previous_page', $pagination->previous_page());
$smarty->assign('has_previous_page', $pagination->has_previous_page());
$smarty->assign('total_pages', $pagination->total_pages());
$smarty->assign('has_next_page', $pagination->has_next_page());
$smarty->assign('next_page', $pagination->next_page());
$offset = $pagination->offset();
$sql = " SELECT * FROM " . TBL_EMPLOYEE;
$sql .= " WHERE is_active ='N' ";
$sql .= " LIMIT {$per_page} ";
$sql .= " OFFSET {$offset} ";
$lists = Employee::find_by_sql($sql);
$manage_lists = array();
if ($lists && is_array($lists)) {
    $i = 1;
    foreach ($lists as $list) {
        $manage_lists[$i]['id'] = $list->id;
        $manage_lists[$i]['employee_id'] = $list->id;
        $manage_lists[$i]['username'] = $list->username;
        $manage_lists[$i]['email_address'] = $list->email_address;
        $manage_lists[$i]['date_register'] = strftime(DATE_FORMAT, strtotime($list->date_register));
        $manage_lists[$i]['last_login'] = strftime(DATE_FORMAT, strtotime($list->last_login));
        $manage_lists[$i]['is_active'] = $list->is_active;
        $manage_lists[$i]['job_status'] = $list->employee_status;
        $i++;
    }
    $smarty->assign('manage_lists', $manage_lists);