<?php require_once 'link.php'; require_once 'class/Database.class.php'; $params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'source_link'); $database = new Database($params); $queryDate = "SELECT * FROM `source_link` WHERE `project_link` = '8'"; $arrayQueryDate = $database->listRecord($database->query($queryDate)); $currentWorkMonth = $arrayQueryDate[0]['link_month']; $currentWorkYear = $arrayQueryDate[0]['link_year']; foreach ($working_data as $key => $value) { array_pop($working_data[$key]); $working_data[$key] = array_values($working_data[$key]); } $finalArray = array(); $arrayDate = array(); foreach ($working_data[0] as $key => $value) { if (is_numeric($value) == 1 && trim($value) != '') { if ($value > 0 && $value <= 9) { $arrayDate[] = '0' . $value . '/' . $currentMonth . '/' . $currentWorkYear; } else { $arrayDate[] = $value . '/' . $currentMonth . '/' . $currentWorkYear; } } else { continue; } } unset($working_data[0]); unset($working_data[1]); $working_data = array_values($working_data); for ($i = 0; $i < count($working_data); $i++) {
<?php require_once 'function.php'; require_once 'class/Database.class.php'; $params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'source_link'); $database = new Database($params); $currentMonth = date('m'); /* New Custom */ for ($i = 1; $i <= 11; $i++) { $queryProject = "SELECT * FROM `source_link` WHERE `project_link` = " . $i . " ORDER BY `link_month` DESC LIMIT 1"; $arraySource[] = $database->listRecord($database->query($queryProject)); } /* End New Custom */ /* $querySource = "SELECT * FROM source_link WHERE `link_month` = '".$currentMonth."'"; $arraySource = $database->listRecord($database->query($querySource)); if(empty($arraySource)) { $currentMonth = date('m') - 1; $querySource = "SELECT * FROM source_link WHERE `link_month` = '".$currentMonth."'"; $arraySource = $database->listRecord($database->query($querySource)); } */ $today = date("d/m/Y"); for ($i = 0; $i < count($arraySource); $i++) { switch ($arraySource[$i][0]['project_link']) { case 1: $maintenance_url = $arraySource[$i][0]['link']; break; case 2: $newcoding_url = $arraySource[$i][0]['link']; break; case 3: $domestic_url = $arraySource[$i][0]['link'];
<?php require_once 'function.php'; require_once 'process_all.php'; require_once 'class/Database.class.php'; $paramsWork = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'work'); $paramsUser = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'user'); $paramsProject = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'project_type'); $databaseWork = new Database($paramsWork); $databaseUser = new Database($paramsUser); $databaseProject = new Database($paramsProject); $queryUser = '******'; $queryProject = 'SELECT * FROM project_type'; $arrayUser = $databaseUser->listRecord($databaseUser->query($queryUser)); $arrayProject = $databaseProject->listRecord($databaseProject->query($queryProject)); //Import Maintenance Data if (!empty($arrayMaintenance)) { foreach ($arrayMaintenance['Maintenance'] as $key => $value) { if (empty($arrayMaintenance['Maintenance'][$key])) { unset($arrayMaintenance['Maintenance'][$key]); } else { $arrayMaintenance['Maintenance'][$key] = array_change_key_case($arrayMaintenance['Maintenance'][$key], CASE_LOWER); foreach ($arrayUser as $k => $v) { if ($arrayMaintenance['Maintenance'][$key]['user'] == $arrayUser[$k]['nickname']) { $arrayMaintenance['Maintenance'][$key]['user'] = $arrayUser[$k]['id']; } } foreach ($arrayProject as $e => $q) { if ($arrayMaintenance['Maintenance'][$key]['project_type'] == $arrayProject[$e]['project_type']) { $arrayMaintenance['Maintenance'][$key]['project_type'] = $arrayProject[$e]['id']; }
Update successful! </div>'; } } else { $databaseSource->insert($arraySource, 'single'); if ($databaseSource->affectedRows() > 0) { $message = '<div class="alert alert-success"> <button class="close" data-dismiss="alert"></button> Insert successful! </div>'; } } } if (isset($_GET['type']) && $_GET['type'] == 'edit') { $queryEdit = "SELECT * FROM source_link WHERE `id` = {$_GET['idLink']}"; $arrayEdit = $databaseSource->listRecord($databaseSource->query($queryEdit)); } if (isset($_POST['form_edit']) && trim($_POST['form_edit']) != '') { $arraySource = array(); $arrayDate = explode(' ', $_POST['google_date']); $month = $arrayDate[0]; $year = $arrayDate[1]; foreach ($_POST as $key => $value) { $arraySource['link'] = $_POST['google_link']; $arraySource['link_month'] = $month; $arraySource['link_year'] = $year; $arraySource['project_link'] = $_POST['google_project']; } $arrayWhere = array(array('id', $_POST['form_edit'], null)); $databaseSource->update($arraySource, $arrayWhere); if ($databaseSource->affectedRows() > 0) {
<?php require_once 'function.php'; require_once 'class/Database.class.php'; $params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'source_link'); $database = new Database($params); $currentMonth = date('m'); $querySource = "SELECT * FROM source_link WHERE `link_month` = '" . $currentMonth . "'"; $arraySource = $database->listRecord($database->query($querySource)); $today = date("d/m/Y"); for ($i = 0; $i < count($arraySource); $i++) { switch ($arraySource[$i]['project_link']) { case 1: $maintenance_url = $arraySource[$i]['link']; break; case 2: $newcoding_url = $arraySource[$i]['link']; break; case 3: $domestic_url = $arraySource[$i]['link']; break; case 4: $newton_url = $arraySource[$i]['link']; break; case 5: $research_url = $arraySource[$i]['link']; break; case 6: $other_url = $arraySource[$i]['link']; break; case 7:
<?php require_once 'class/Database.class.php'; $params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'manage_user', 'table' => 'news'); $database = new Database($params); $position = $_GET['position']; $item = $_GET['item']; $query = "SELECT `id`, `title`, `description` FROM `news` LIMIT {$position}, {$item}"; $list = $database->listRecord($query); $xhtml = ''; if (!empty($list)) { foreach ($list as $key => $value) { $xhtml .= '<div class="item"> <h3 class="title">' . $value['title'] . '</h3> <p>' . $value['description'] . '</p> </div>'; } } echo $xhtml;
$databaseProject = new Database($paramsProject); $databaseWork = new Database($paramsWork); $arrayUser = $databaseUser->listRecord($databaseUser->query('SELECT * FROM user')); $arrayProject = $databaseProject->listRecord($databaseProject->query('SELECT * FROM project_type')); $datePost = ''; $userPost = ''; $arrayWork = array(); /* echo '<pre>'; print_r($arrayUser); echo '</pre>'; die(); */ if (isset($_POST['date_search']) && isset($_POST['user_name']) && trim($_POST['date_search']) != '' && trim($_POST['user_name']) != '') { $datePost = $_POST['date_search']; $userPost = $_POST['user_name']; $queryWork = "SELECT * FROM `work` WHERE `work_date` = '{$_POST['date_search']}' AND `user` = {$_POST['user_name']}"; $arrayWork = $databaseWork->listRecord($databaseWork->query($queryWork)); foreach ($arrayWork as $key => $value) { foreach ($arrayProject as $k => $v) { if ($arrayWork[$key]['project_type'] == $arrayProject[$k]['id']) { $arrayWork[$key]['project_type'] = $arrayProject[$k]['project_type']; } } } } if (isset($_POST['date_show'])) { $datePost = $_POST['date_show']; $queryWork = "SELECT * FROM `work` WHERE `work_date` = '{$datePost}' ORDER BY `user` ASC"; $arrayWork = $databaseWork->listRecord($databaseWork->query($queryWork)); foreach ($arrayWork as $key => $value) { foreach ($arrayProject as $k => $v) { if ($arrayWork[$key]['project_type'] == $arrayProject[$k]['id']) {
<?php require_once 'Database.class.php'; $paramsWorktime = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'work_time'); $dbWorktime = new Database($paramsWorktime); $queryWorktime = 'SELECT * FROM `work_time`'; $arraydbWorktime = $dbWorktime->listRecord($dbWorktime->query($queryWorktime));