public function stockUpdate() { Larasset::start('header')->css('daterangepicker'); Larasset::start('footer')->js('moment', 'daterangepicker'); $daterange = Input::get('record_range'); if (strpos($daterange, '-') !== FALSE) { $fromandto = explode('-', $daterange); $from = sqldate($fromandto[0]); $to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]); $to = sqldate(date('Y/n/d', $to_plus_1day)); $data['todate'] = $fromandto[1]; } else { $from = sqldate(date('Y/n/d', strtotime('first day of this month'))); $to = sqldate('+1day'); $data['todate'] = $to; } $data['fromdate'] = $from; $data['todate'] = $to; $time = array($data['fromdate'], $data['todate']); $activities = Usersactivity::where('activity_type', '=', 'stock')->whereBetween('created_at', $time)->orderBy('id', 'desc')->get(); //$data = array(); if ($activities != null) { $data['activities'] = $activities; } $this->layout->title = "Welcome to Admin Area"; $this->layout->content = View::make('admin.stockupdate_record.index', $data); }
private function updateloggedTime($data) { $user = User::find(Auth::user()->id); $user->isloggedin = $data[0]; $user->loggedtime = sqldate(); $user->save(); }
public function add(array $values) { $users = tusers::i(); $email = trim($values['email']); if ($users->emailexists($email)) { return false; } $groups = tusergroups::i(); if (isset($values['idgroups'])) { $idgroups = $this->cleangroups($values['idgroups']); if (count($idgroups) == 0) { $idgroups = $groups->defaults; } } else { $idgroups = $groups->defaults; } $password = empty($values['password']) ? md5uniq() : $values['password']; $item = array('email' => $email, 'name' => isset($values['name']) ? trim($values['name']) : '', 'website' => isset($values['website']) ? trim($values['website']) : '', 'password' => litepublisher::$options->hash($email . $password), 'cookie' => md5uniq(), 'expired' => sqldate(), 'idgroups' => implode(',', $idgroups), 'trust' => 0, 'status' => isset($values['status']) ? $values['status'] : 'approved'); $id = $users->db->add($item); $item['idgroups'] = $idgroups; $users->items[$id] = $item; $users->setgroups($id, $item['idgroups']); if ('approved' == $item['status']) { tuserpages::i()->add($id); } $users->added($id); return $id; }
public function run() { // Uncomment the below to wipe the table clean before populating DB::table('systemsettings')->truncate(); $systemsettings = array('payment_mode' => 'Cash, Pos, Coupon', 'dob_alert_day' => '5', 'created_at' => sqldate(), 'updated_at' => sqldate()); // Uncomment the below to run the seeder DB::table('systemsettings')->insert($systemsettings); }
public function import($url, $title, $posted, $ip, $status) { $item = array('url' => $url, 'title' => $title, 'post' => $this->pid, 'posted' => sqldate($posted), 'status' => $status, 'ip' => $ip); $id = $this->db->add($item); $item['id'] = $id; $this->items[$id] = $item; $this->updatecount($this->pid); return $id; }
/** * Lite Publisher * Copyright (C) 2010 - 2015 Vladimir Yushko http://litepublisher.ru/ http://litepublisher.com/ * Dual licensed under the MIT (mit.txt) * and GPL (gpl.txt) licenses. **/ function tusersInstall($self) { $manager = tdbmanager::i(); $dir = dirname(__FILE__) . DIRECTORY_SEPARATOR; $manager->CreateTable($self->table, file_get_contents($dir . 'users.sql')); //$manager->setautoincrement($self->table, 2); $manager->CreateTable($self->grouptable, file_get_contents($dir . 'usersgroups.sql')); $id = $self->db->add(array('email' => litepublisher::$options->email, 'name' => litepublisher::$site->author, 'website' => litepublisher::$site->url . '/', 'password' => '', 'cookie' => '', 'expired' => sqldate(), 'status' => 'approved', 'idgroups' => '1')); $self->setgroups($id, array(1)); }
public function run() { // Uncomment the below to wipe the table clean before populating DB::table('modes')->truncate(); $list = array('retail' => 1, 'wholesale' => 1, 'distributor' => 0, 'majordistributor' => 0); $modes = array(); foreach ($list as $name => $status) { $modes[] = array('name' => $name, 'status' => $status, 'created_at' => sqldate(), 'updated_at' => sqldate()); } // Uncomment the below to run the seeder DB::table('modes')->insert($modes); }
public function run() { // Uncomment the below to wipe the table clean before populating DB::table('productcategories')->truncate(); $list = array('Nail', 'Lips', 'Face', 'Eye', 'Others'); $productcategories = array(); foreach ($list as $cat) { $productcategories[] = array('name' => $cat, 'created_at' => sqldate(), 'updated_at' => sqldate()); } // Uncomment the below to run the seeder DB::table('productcategories')->insert($productcategories); }
public function run() { // Uncomment the below to wipe the table clean before populating DB::table('menus')->truncate(); $list = array('Dashboard' => 'admindashboard', 'Stock' => 'adminstock'); $menus = array(); foreach ($list as $name => $urlname) { $menus[] = array('name' => $name, 'urlname' => $urlname, 'created_at' => sqldate(), 'updated_at' => sqldate()); } // Uncomment the below to run the seeder DB::table('menus')->insert($menus); }
public function run() { // Uncomment the below to wipe the table clean before populating DB::table('role_user')->truncate(); $list = [1 => 1]; $roleuser = []; foreach ($list as $userid => $roleid) { $roleuser[] = ['user_id' => $userid, 'role_id' => $roleid, 'created_at' => sqldate(), 'updated_at' => sqldate()]; } // Uncomment the below to run the seeder DB::table('role_user')->insert($roleuser); }
public function run() { // Uncomment the below to wipe the table clean before populating DB::table('brands')->truncate(); $list = array('flp' => 'Forever living product', 'sleek' => 'Sleek makeup', 'glamour56' => 'Glamour56 makeup', 'iman' => 'Iman makeup', 'marykay' => 'MaryKay makeup', 'mac' => 'Mac makeup'); $brands = array(); foreach ($list as $name => $caption) { $brands[] = array('name' => $name, 'caption' => $caption, 'created_at' => sqldate(), 'updated_at' => sqldate()); } // Uncomment the below to run the seeder DB::table('brands')->insert($brands); }
public function run() { // Uncomment the below to wipe the table clean before populating DB::table('users')->truncate(); $list = array('debola1' => 1, 'fresh2' => 2, 'melee3' => 3); $users = array(); foreach ($list as $username => $role) { $users[] = array('username' => $username, 'usertoken' => Makehash::random('number', 6), 'password' => Hash::make('demo'), 'created_at' => sqldate(), 'updated_at' => sqldate()); } // Uncomment the below to run the seeder DB::table('users')->insert($users); }
public function save() { $r = Input::all(); $r['date'] = sqldate($r['date']); $r['amount'] = unformat_money($r['amount']); $r['user_id'] = Auth::user()->id; $r['status'] = User::permitted('role.admin') === true ? 1 : 0; //Insert into database $created = Expenditure::create($r); $data['status'] = 'success'; $data['message'] = 'Record saved successfully!'; return Response::json($data); }
public function create() { $all = Input::all(); $all['user_id'] = Auth::user()->id; $all['deposit_date'] = sqldate($all['deposit_date']); $all['amount'] = unformat_money($all['amount']); $all['status'] = 0; //Insert into database $created = Bankentry::create($all); $data['status'] = 'success'; $data['message'] = 'saved!'; return Response::json($data); }
function tpostsGetsitemap($self, $from, $count) { $result = array(); $commentpages = litepublisher::$options->commentpages; $commentsperpage = litepublisher::$options->commentsperpage; $db = $self->db; $now = sqldate(); $res = $db->query("select {$db->posts}.title, {$db->posts}.pagescount, {$db->posts}.commentscount, {$db->urlmap}.url\n from {$db->posts}, {$db->urlmap}\n where {$db->posts}.status = 'published' and {$db->posts}.posted < '{$now}' and {$db->urlmap}.id = {$db->posts}.idurl\n order by {$db->posts}.posted desc limit {$from}, {$count}"); while ($item = $db->fetchassoc($res)) { $comments = $commentpages ? ceil($item['commentscount'] / $commentsperpage) : 1; $result[] = array('url' => $item['url'], 'title' => $item['title'], 'pages' => max($item['pagescount'], $comments)); } return $result; }
public function create() { $all = Input::all(); $all['user_id'] = Auth::user()->id; $all['deposit_date'] = sqldate($all['deposit_date']); $all['amount'] = unformat_money($all['amount']); //Lets check if the current user is admin to determine the assigned status $all['status'] = User::permitted('role.admin') ? 1 : 0; //Insert into database $created = Bankentry::create($all); $data['status'] = 'success'; $data['message'] = 'saved!'; return Response::json($data); }
public function additem(array $item) { $realfile = litepublisher::$paths->files . str_replace('/', DIRECTORY_SEPARATOR, $item['filename']); $item['author'] = litepublisher::$options->user; $item['posted'] = sqldate(); $item['hash'] = $this->gethash($realfile); $item['size'] = filesize($realfile); //fix empty props foreach (array('mime', 'title', 'description', 'keywords') as $prop) { if (!isset($item[$prop])) { $item[$prop] = ''; } } return $this->insert($item); }
public function add($nick, $url, $foafurl, $status) { $item = array('nick' => $nick, 'url' => $url, 'foafurl' => $foafurl, 'added' => sqldate(), 'errors' => 0, 'status' => $status); if ($this->dbversion) { $id = $this->db->add($item); } else { $id = ++$this->autoid; } $this->items[$id] = $item; if (!$this->dbversion) { $this->save(); } $this->added($id); $urlmap = turlmap::i(); $urlmap->clearcache(); return $id; }
public function registerNewCustomer() { $customer = new Customer(); $customer->name = $name = Input::get('name'); $customer->phone = Input::get('phone'); $customer->email = Input::get('email'); $customer->birthday = sqldate(Input::get('birthday')); $customer->mode_id = (int) Input::get('customer_type'); $customer->token = $token = Makehash::random('number', 6); $customer->createdby = Auth::user()->username; if (!$customer->save()) { $data = $customer->validatorStatus; } else { $message = "<p>Registration successful!</p>\n\t\t\t\t\t<p>" . $name . " token is: <span class='label label-large label-info new-token'>" . $token . "</span>\n\t\t\t\t\t</p>"; $data['status'] = 'success'; $data['message'] = $message; $data['detail'] = "Name: {$name} | Token-ID: {$token}"; } return Response::json($data); }
private function _fetchRecord() { $record_type = Input::get('record_type'); $daterange = Input::get('record_range'); if (strpos($daterange, '-') !== FALSE) { $fromandto = explode('-', $daterange); $from = sqldate($fromandto[0]); $to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]); $to = sqldate(date('Y/n/d', $to_plus_1day)); $data['todate'] = $fromandto[1]; } else { $from = sqldate(date('Y/n/d', strtotime('first day of this month'))); $to = sqldate('+1day'); $data['todate'] = $to; } $data['records'] = $this->_dbSyntax($record_type, $from, $to); //tt($data['records']->toArray()); $data['fromdate'] = $from; return $data; }
private function _fetchRecord() { $record_type = Input::get('record_type') != NULL ? Input::get('record_type') : 'sales'; $daterange = Input::get('record_range') !== NULL ? Input::get('record_range') : ''; if (strpos($daterange, '-') !== FALSE) { $fromandto = explode('-', $daterange); $from = sqldate($fromandto[0]); $to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]); $to = sqldate(date('Y/n/d', $to_plus_1day)); $data['todate'] = $fromandto[1]; } else { $from = sqldate('today'); $to = sqldate('now'); $data['todate'] = $to; } //$dbTableInfo = $this->tableName[$record_type]; $data['records'] = $this->_dbSyntax($record_type, $from, $to); $data['fromdate'] = $from; return $data; }
private function _dateSetter($date) { $date = str_replace('_', '', strchr($date, '_')); if (strtolower($date) == 'lastweek') { return array(sqldate('last week'), sqldate('last week +6 days')); } if (strtolower($date) == 'lastmonth') { $start_of_last_month = sqldate(date('Y/n/d', strtotime('first day of last month'))); $end_of_last_month = sqldate(date('Y/n/d', strtotime('last day of last month'))); return array($start_of_last_month, $end_of_last_month); } if (strtolower($date) == 'today') { return array(sqldate('today'), sqldate('tomorrow')); } if (strtolower($date) == 'yesterday') { return array(sqldate('yesterday'), sqldate('today')); } if (strtolower($date) == 'tomorrow') { return array(sqldate('tomorrow'), sqldate('tomorrow +1 day')); } }
public function request($arg) { $this->cache = false; if (!($this->iduser = litepublisher::$options->user)) { //trick - hidden registration of comuser. Auth by get $users = tusers::i(); if (isset($_GET['auth']) && ($cookie = trim($_GET['auth']))) { if (($this->iduser = $users->findcookie($cookie)) && litepublisher::$options->reguser) { if ('comuser' == $users->getvalue($this->iduser, 'status')) { // bingo! $this->newreg = true; $item = $users->getitem($this->iduser); $item['status'] = 'approved'; $item['password'] = ''; $item['idgroups'] = 'commentator'; $cookie = md5uniq(); $expired = time() + 31536000; $item['cookie'] = litepublisher::$options->hash($cookie); $item['expired'] = sqldate($expired); $users->edit($this->iduser, $item); litepublisher::$options->user = $this->iduser; litepublisher::$options->updategroup(); litepublisher::$options->setcookie('litepubl_user_id', $this->iduser, $expired); litepublisher::$options->setcookie('litepubl_user', $cookie, $expired); } else { $this->iduser = false; } } } } if (!$this->iduser) { $url = litepublisher::$site->url . '/admin/login/' . litepublisher::$site->q . 'backurl=' . rawurlencode('/admin/subscribers/'); return litepublisher::$urlmap->redir($url); } if ('hold' == tusers::i()->getvalue($this->iduser, 'status')) { return 403; } return parent::request($arg); }
} $where = "(" . substr($where, 4) . ") AND "; } } elseif ($_POST['newRight']) { $reassign = $_POST['newRight']; $u = $slave->select("SELECT First_Name, Last_Name From Users WHERE User_ID=" . $reassign); $assigned_to = display_name($u[0]['First_Name'], $u[0]['Last_Name']); $tdata['User_ID'] = $reassign; $tdata['Department_ID'] = 0; $where = "User_ID=" . $reassign . " AND "; } $data['Reassigned_ID'] = $reassign; } $tdata['Priority'] = $_POST['priority']; if ($_POST['finish_date']) { $tdata['Finish_Date'] = sqldate($_POST['finish_date']); } else { $tdata['Finish_Date'] = NULL; } $data['User_ID'] = $_SESSION['user_id']; $data['Acknowledged'] = date("Y-m-d H:i:s"); $data['Task_ID'] = $_POST['task_id']; $data['Progress'] = $_POST['progress']; if ($_POST['doaction'] == "Reassign") { $data['Accepted'] = 0; } elseif ($_POST['doaction'] == "Accept") { $data['Accepted'] = 1; } elseif ($_POST['doaction'] == "Close") { $tdata['Progress'] = '100'; $data['Progress'] = '100'; }
private function _processHistory($id, $daterange) { Larasset::start('header')->css('daterangepicker'); Larasset::start('footer')->js('moment', 'daterangepicker'); if (strpos($daterange, '-') !== FALSE) { $fromandto = explode('-', $daterange); $from = sqldate($fromandto[0]); $to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]); $to = sqldate(date('Y/n/d', $to_plus_1day)); $data['todate'] = $fromandto[1]; } else { $from = sqldate(date('Y/n/d', strtotime('first day of this month'))); $to = sqldate('+1day'); $data['todate'] = $to; } $customerlog = Salelog::with(array('product' => function ($q) { $q->select('id', 'name', 'productcat_id')->with(array('categories' => function ($qr) { $qr->select('id', 'type'); })); }))->where('customer_id', '=', $id)->whereBetween('created_at', array($from, $to))->orderBy('id', 'desc'); //tt(groupThem($customerlog->get()->toArray(), 'receipt_id')); $customerDetails = Customer::where('id', '=', $id)->first(); //$data['customerhistory'] = $customerlog->get()->toArray(); $data['customerhistory'] = groupThem($customerlog->get()->toArray(), 'receipt_id'); $data['customerdetail'] = $customerDetails; $data['fromdate'] = $from; $this->layout->title = 'Customer History'; $this->layout->content = View::make('admin.customerhistory', $data); }
} if ($_POST['friday']) { $data['Friday'] = 1; } if ($_POST['saturday']) { $data['Saturday'] = 1; } if ($_POST['sunday']) { $data['Sunday'] = 1; } } if ($_POST['start_range']) { $data['Start_Range'] = sqldate($_POST['start_range']); } if ($_POST['ends'] == 1) { $data['End_Range'] = sqldate($_POST['end_range']); } } if ($_POST['task_id'] == "new") { if (!$_POST['finish_date']) { $task_days = $slave->select("SELECT Default_Days FROM Task_Priority WHERE Priority_ID=" . $_POST['priority']); if ($task_days) { //$data['Finish_Date']=date("Y-m-d",mktime(0,0,0,date(m),date(d)+,date(y))); } } $data['Creator_ID'] = $_SESSION['user_id']; //if ($_SESSION[user_id]==6) { //print_r($data); //exit; //} $insert = $db->insert("Tasks", $data);
$email = trim(str_replace(" ", "", $email)); $email = str_replace(",", "", $email); // Everything approved. Save the profile $MEMBER->FirstName = $fname; $MEMBER->MiddleName = $mname; $MEMBER->LastName = $lname; $MEMBER->Email = $email; $MEMBER->HideEmail = $hideEmail; $MEMBER->Gender = $gender; if ($pwd1 && $pwd2) { $MEMBER->ChangePassword($pwd1, $oldpwd); } $MEMBER->PhoneNumber = $phone; $MEMBER->HidePhone = $hidePhone; $MEMBER->ReceiveTexts = $receiveSms; $MEMBER->Birthday = sqldate($dob); $MEMBER->HideBirthday = $hideBirthday; // Here follows the logic of the member's Residence. // If there's a custom Residence, it has no "Name" // and the Member's "Apartment" field is blank too. // If it's a regular residence, it has a "Name", // and the "Apartment" field has the unit number. function setNewCustomResidence(&$MEMBER, &$WARD, $streetAddress, $city, $state, $zipcode) { $newRes = $WARD->AddResidence("", $streetAddress, $city, $state, $zipcode, true); $MEMBER->ResidenceID = $newRes->ID(); $MEMBER->Apartment = ""; } function setNewRegularResidence(&$MEMBER, $resID, $aptnum) { $MEMBER->ResidenceID = $resID;
protected function setclosed($value) { $this->childdata['closed'] = is_int($value) ? sqldate($value) : $value; }
public function getsqldate() { return sqldate($this->posted); }
if (mysql_num_rows(DB::Run($q)) == 0) { continue; } $sq = SurveyQuestion::Load($qid); // Load question $ansObj = $sq->Answers($memID); // Load this members' answer to it $ansChanged = false; // Make sure it's not a required question with an empty // or no answer. If so, skip it. if ($sq->Required && !$ans) { continue; } // For Timestamp-style answers, format them accordingly if ($sq->QuestionType == QuestionType::Timestamp) { $ans = sqldate($ans); } // Free-response should be capitalized at the beginning if ($sq->QuestionType == QuestionType::FreeResponse) { $ans = ucfirst(trim($ans)); } if (!$ansObj) { // No previous answer? No problem! Create it. $ansObj = $sq->AddAnswer($ans, $memID); $ansChanged = true; } else { // Update existing answer if necessary if ($ans != $ansObj->AnswerValue) { $ansObj->AnswerValue = $ans; $ansChanged = true; }