public function actionExportExcel() { $model = new Member('search'); $model->unsetAttributes(); // clear any default values if (isset($_GET['Member'])) { $model->attributes = $_GET['Member']; } $this->widget('application.extensions.phpexcel.EExcelView', array('dataProvider' => $model->search(), 'title' => 'Member', 'autoWidth' => true, 'columns' => array('username', 'title', 'first_name', 'last_name', 'email', 'phone', 'company_name', 'address', 'birthday', 'gender', 'created_time', 'last_update_time', 'last_update_by', 'last_login', 'last_login_ip', 'status:status'))); }
public static function getPendingReturns($member_nic = null) { if (isset($member_nic)) { $member = Member::search(["member_nic" => $member_nic]); $extra = "AND member_id=" . $member->getId(); } else { $extra = ""; } $sql = "SELECT DISTINCT t.transaction_id,transaction_description,t.borrowed_date,t.expected_return_date,member_id FROM transaction t,item_transaction it WHERE t.transaction_id=it.transaction_id AND status=0 " . $extra . ";"; $result = DB::getInstance()->directSelect($sql); $trans = array(); foreach ($result as $key => $value) { $data = array("id" => $value["transaction_id"], "purpose" => $value["transaction_description"], "borrow_comment" => null, "return_comment" => null, "member_id" => $value["member_id"], "borrowed_date" => $value["borrowed_date"], "expected_return_date" => $value["expected_return_date"]); $t = new Transaction(); $t->create($data); $trans[] = $t; } return $trans; }
case "Temporary Member": $search_term = "tmp_mem"; break; //echo $search_term; } $results = DB::getInstance()->search("member_role", array("role" => $search_term)); //print_r($results); $members; foreach ($results as $result) { $members[] = Member::search(array("member_id" => $result['member_id'])); } } elseif ($search_methode == "2") { $members[] = Member::search(array("member_nic" => $search_term)); //print_r($members); } elseif ($search_methode == "3") { $members[] = Member::search(array("member_email" => $search_term)); //print_r($members); } //print_r($members); //echo $search_methode; //echo $search_term; echo "<br><br><div class='datagrid'><table>\n\t<thead><tr><th>Initials</th><th>Surname</th><th>Email</th><th>Remarks</th></tr></thead>"; $x = 0; foreach ($members as $member) { if (isset($member)) { $x = 1; $initials = $member->getInitials(); $surname = $member->getSurname(); $email = $member->getEmail(); $remarks = $member->getRemarks(); echo "\n <tbody><tr><td>{$initials}</td><td>{$surname}</td><td>{$email}</td><td>{$remarks}</td></tr>\n <tr class=\"alt\">\n </tr>\n </tbody>\n ";
<?php require_once './resource/config/connectDB.php'; require_once './resource/models/member.php'; $member = Member::search($searchTerms, $conn);
<?php require_once 'core/init.php'; if (isset($_SESSION["logged_in_user"])) { $username = $_SESSION["logged_in_user"]; $member = Member::search(array("member_email" => $username)); $name = $member->getInitials() . " " . $member->getSurname(); $r = explode(",", $member->getRoles()); $roles = array_map('trim', $r); $_SESSION["roles"] = $roles; } else { header("location: homepage.php"); } ?> <link rel="stylesheet" type="text/css" href="css/header.css" /> <div id="headerwrap"> <div id="header"> <div id="logo"> <img src="img/logo.png" width="70px" height="70px" alt="UCSC logo"/> </div> <div id="title"> <font face="Agency FB" color="#b5dfeb" size="6px" >Electronic Laboratory <br> Management System</font> </div> <div style="float:right; padding:27px;"> <font face="Calibri" color="white" size="4">You are logged in as <strong><span style="text-transform:uppercase;"><a class="head"><?php echo $name; ?> </a></span></strong></font>
<?php require_once 'core/init.php'; $password = "******"; $hash = crypt($password); $io = Member::search(["member_nic" => "931390473"]); print_r($io); ///echo $hash; if (password_verify("nalinda", $hash)) { //echo strlen($hash); } else { echo "invalid"; } echo "test"; //echo date_format(date_add(DateTime::createFromFormat('d/m/Y', date("d/m/Y")),date_interval_create_from_date_string("5 years")),"d/m/Y"); echo date("d/m/Y"); $a = Item::search(["item_id" => 2]); print_r($a); $sql = "UPDATE item_copy SET item_copy_status=1;"; DB::getInstance()->directUpdate($sql); $data = array("id" => null, "purpose" => "sdasd", "comment" => "asdsdf", "member_id" => 16); $salt = '5&JDDlwz%Rwh!t2Yg-Igae@QxPzFTSId'; $enc_pass = md5($salt . 'admin'); echo "paswowkjhkfjw"; DB::getInstance()->directUpdate("UPDATE member SET member_password='******' WHERE member_nic='000000000';"); $t = new Transaction(); $t->create($data); $t->add(); print_r(DB::getInstance()->search("schedule", ["semester_no" => 2]));
public static function login($username, $password) { $member = Member::search(array("member_email" => $username)); $salt = '5&JDDlwz%Rwh!t2Yg-Igae@QxPzFTSId'; $enc_pass = md5($salt . $password); if ($member != null) { if ($member->getPassword() == $enc_pass) { return true; } else { return false; } } else { return false; } }
public static function _doSearch() { $name = trim($_POST['name']); $results = Member::search($name); Flight::render('member/search', compact('results')); }
<?php require_once 'core/init.php'; $member_role = $_SESSION['roles']; if (in_array("Laboratory Assistant", $member_role)) { } else { header('location:restricted_page.php'); } $searchValue = $_GET["searchVal"]; $new_member = Member::search(["member_nic" => $searchValue]); $_SESSION["sv"] = $searchValue; if ($new_member) { $_SESSION["items"] = array(); $_SESSION["basket"] = array(); $remark = $new_member->getRemarks(); if ($remark == "Borrow Allowed") { $bgcolor = "#00FF00"; } else { $bgcolor = "#FF0000"; } echo "<div>"; echo "<fieldset>"; echo "<legend>Member Details</legend>"; echo "<div style='display:inline-block'>"; echo "<img src='img/profile_pictures/" . $new_member->getNicNo() . ".jpg' width='100' hight='120' style='border:1px solid #ccc;'/>"; echo "</div>"; echo "<div style='display:inline-block;vertical-align:top' class='datagrid'>"; echo "<table style='padding:20px;'>"; echo "<tbody><tr><td>Name :<th><td>" . $new_member->getInitials() . " " . $new_member->getSurname() . "<td><tr>"; echo "<tr><td>Role/s :<th><td>" . $new_member->getRoles() . "<td><tr>"; echo "<tr><td>Remarks :<th><td bgcolor=\"{$bgcolor}\">" . $remark . "<td><tr>";
include "includes/header.php"; ?> <?php include "includes/leftnav.php"; ?> <div id="contentwrap"> <div id="content"> <form id="returnForm" onsubmit="return completeReturn();"> <h3>Transaction Details</h3> <div class="datagrid"> <?php $value = Transaction::searchPendingReturns($_GET["t_id"]); $member = Member::search(["member_id" => $value->getMemberId()]); $name = $member->getInitials() . " " . $member->getSurname(); $nic = $member->getNicNo(); $tid = $value->getTransactionId(); $desc = $value->getPurpose(); $bdate = $value->getBorrowedDate(); $edate = $value->getExpectedReturnDate(); $bcomment = $value->getBorrowComment(); $rcomment = $value->getReturnComment(); ?> <table> <tr><th>Transaction ID</th><td><?php echo $tid; ?> </td></tr> <tr><th>Member Name</th><td><?php