public function run()
{
$faker = Faker::create();
foreach (range(1, 10) as $index) {
Transaction::create([]);
}
}
public function run()
{
$faker = Faker::create();
foreach (range(1, 5) as $index) {
// Receita
Transaction::create(array('user_id' => 1, 'type' => array_rand(['receita', 'despesa'], 1), 'description' => array_rand(['Hospedagem', 'Empréstimo', "Aluguel"], 1), 'amount' => (string) rand(1, 100000) * 0.01, 'done' => array_rand(['true', 'false'], 1), 'date' => $faker->date('Y-m-d'), 'recurring_type' => array_rand(['daily', 'weekly', 'biweekly', 'monthly', 'bimonthly', 'trimonthly', 'sixmonthly', 'yearly'], 1), 'recurring_times' => 3, 'recurring_cycle' => 2, 'owner_id' => 1, 'owner_type' => 'User'));
}
}
public function testBenefFields()
{
$tx = Transaction::create((object) ['date' => new \DateTime(), 'amount' => 200.0, 'currency' => 'CAD', 'benefName' => 'Petr Kramar', 'benefStreet' => 'Andelova 12', 'benefCity' => 'Ostrava', 'benefCountry' => 'CZ']);
$this->assertEquals('Petr Kramar', $tx->getBenefName());
$this->assertEquals('Andelova 12', $tx->getBenefStreet());
$this->assertEquals('Ostrava', $tx->getBenefCity());
$this->assertEquals('CZ', $tx->getBenefCountry());
}
/**
* Store a newly created resource in storage.
* POST /transactions
*
* @return Response
*/
public function store()
{
$transactions = Transaction::create(Input::all());
if ($transactions) {
return ['status' => true, 'data' => $transactions];
} else {
return ['status' => false];
}
}
/**
* @param \stdClass $data Data from JSON API response
* @return TransactionList
*/
public static function create(\stdClass $data)
{
$account = new Account($data->info->accountId, $data->info->bankId, $data->info->currency, $data->info->iban, $data->info->bic);
$transactionList = new self($data->info->openingBalance, $data->info->closingBalance, new \DateTime($data->info->dateStart), new \DateTime($data->info->dateEnd), $data->info->idFrom, $data->info->idTo, $data->info->idLastDownload, $account);
foreach ($data->transactionList->transaction as $transaction) {
$transactionList->addTransaction(Transaction::create($transaction));
}
return $transactionList;
}
/**
* Store a newly created resource in storage.
* POST /transactions
*
* @return Response
*/
public function store()
{
//
$trans = Transaction::create(array('user_id' => Input::get('user_id'), 'amount' => Input::get('amount'), 'description' => Input::get('description')));
$brokers = array();
foreach (Input::get('brokers') as $row) {
$brokers[] = new Broker(array('broker' => $row));
}
$trans->brokers()->saveMany($brokers);
return Transaction::with('brokers')->find($trans->id)->toJson();
}
public function testAccountValuesAreProperlySet()
{
$transaction = json_decode(file_get_contents(__DIR__ . '/data/example-transaction.json'));
$transaction = Transaction::create($transaction);
$this->assertSame(1111111111, $transaction->getId());
$this->assertEquals(new \DateTime('2015-03-30+0200'), $transaction->getDate());
$this->assertSame(127.0, $transaction->getAmount());
$this->assertSame('CZK', $transaction->getCurrency());
$this->assertSame('214498596', $transaction->getSenderAccountNumber());
$this->assertSame('2100', $transaction->getSenderBankCode());
$this->assertSame('0', $transaction->getVariableSymbol());
$this->assertSame(null, $transaction->getConstantSymbol());
$this->assertSame(null, $transaction->getSpecificSymbol());
$this->assertSame('Banka, a.s.', $transaction->getSenderBankName());
$this->assertSame('HUJER MARTIN', $transaction->getUserIdentity());
$this->assertSame('Platba eshop', $transaction->getUserMessage());
$this->assertSame('Bezhotovostní příjem', $transaction->getTransactionType());
$this->assertSame(null, $transaction->getPerformedBy());
$this->assertSame('Comment? Comment!', $transaction->getComment());
$this->assertSame(1111122222, $transaction->getPaymentOrderId());
}
public function createAddPart()
{
if (isset($_REQUEST['itemid']) && !empty($_REQUEST['wid'])) {
$worksheet = Worksheet::find_by_id($_REQUEST['wid']);
$myItem = Items::find_by_id($_REQUEST['itemid']);
$propart = new Prodpart();
$propart->part_name = $myItem->item_name;
$propart->qty = $_REQUEST['qty'];
$propart->works_id = $_REQUEST['wid'];
$propart->prod_id = $worksheet->prod_id;
$propart->item_id = $_REQUEST['itemid'];
$propart->datecreated = date("Y:m:d H:i:s");
$propart->des = "";
$propart->unit_cost = $_REQUEST['price'];
$propart->total_cost = (int) $_REQUEST['price'] * (int) $_REQUEST['qty'];
$Tlog = new Transaction();
$Tlog->com_id = $myItem->item_id;
$Tlog->trans_type = "WORKSHEET PART SUPPLY";
$Tlog->trans_description = "allocation of resources to worksheet";
$Tlog->datecreated = date("Y-m-d H:i:s");
$Tlog->user_id = $_SESSION['emp_ident'];
if ($propart->create()) {
$Tlog->create();
return $propart;
} else {
return false;
}
}
}
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]));
print_r(Schedule::search(["semester_no" => 2]));
echo isset($_SESSION["basket"]);
?>
<html>
<script type="text/javascript">
function display(msg){
alert(msg);
}
</script>
</html>
/**
* Store a newly created resource in storage.
* POST /transactions
*
* @return Response
*/
public function store($id)
{
$visit = $this->getVisit($id);
if (!isset($visit) || $visit->done != 0) {
return Redirect::back()->with('global', 'Bill already settled or No Pending Bills!');
}
$data = ['patient_id' => $id, 'visit_id' => $visit->id, 'total' => $this->getTotal($id), 'payment_mode' => Input::get('payment_mode')];
$validator = Validator::make($data, Transaction::$rules);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator);
}
if ($trans = Transaction::create($data)) {
$bima = Bima::where('company', '=', $trans->payment_mode)->where('medical_insurance', '=', $this->getPatient($id)->medical_insurance)->first();
if ($bima) {
$bima_balance = $bima->balance;
if ($bima_balance < 0 && $bima_balance < $trans['total']) {
return Redirect::back()->with('global', 'You have an insufficient account to make this transaction!');
} else {
$balance = $bima_balance - $trans['total'];
$bima->balance = $balance;
$bima->save();
}
}
$visit = $this->getVisit($id);
$visit->done = 1;
$visit->save();
return Redirect::route('transaction-create-get')->with('global', 'Bill successfully settled with ' . $trans->payment_mode);
}
return Redirect::route('transaction-create-get')->with('global', 'Error, please try again!');
}
public function createSchedule_Detail($id = "")
{
header('Content-Type: application/json');
$data = json_decode(stripslashes($_POST['data']));
foreach ($data as $d => $value) {
$cntdata[] = $d;
}
if (!empty($data->taskdate) && !empty($data->cid) && !empty($data->empid)) {
$issuefield = get_object_vars($data);
// get the properties of an object into an array
$thisclientproduct = Cproduct::find_by_id((int) preg_replace('#[^0-9]#i', '', $data->cid));
$thisemployee = Employee::find_by_id((int) preg_replace('#[^0-9]#i', '', $data->empid));
$thisSchedule = new Schedule();
$thisSchedule->emp_id = $issuefield['empid'];
$thisSchedule->emp_name = $thisemployee->emp_fname . " " . $thisemployee->emp_lname;
$thisSchedule->client_id = $thisclientproduct->client_id;
$thisClient = Client::find_by_id($thisclientproduct->client_id);
//print_r($thisclientproduct);
//print_r($thisClient);
//print_r($thisemployee);
$thisSchedule->prod_id = $issuefield['cid'];
$thisSchedule->prod_name = $thisclientproduct->prod_name;
/**
* this is to check if ticket
* is in existence
*/
//print_r($theUser);
global $session;
//$partTicket = ($id!="") ? Ticket::find_by_id($id) : ""; // get the ticket to get details needed for sending mail
$theUser = Employee::find_by_id($_SESSION["emp_ident"]);
// get cse detail to retrieve email
$thisSchedule->s_date = $data->taskdate;
/**
* section to configure and setup sms and email message
*/
$issue = array();
$objIssue = Issue::find_all();
// creating the issue log object
$message_issue = "";
//$thisemployee->emp_phone
foreach ($objIssue as $objI) {
foreach ($issuefield as $key => $value) {
if ($key == $objI->issue_accronym) {
$message_issue .= $objI->issue_name . ", ";
}
}
}
$cemail = array();
$cemail = isset($_POST['cemail']) && !empty($_POST['cemail']) ? explode(",", $_POST['cemail']) : array('*****@*****.**');
array_push($cemail, $thisemployee->emp_email, is_array($partTicket) ? $partTicket->contact_email : "", $theUser->emp_email, $thisClient->email);
//print_r($cemail);
$thisSchedule->status = "Open";
$thisSchedule->issue = $message_issue;
$thisSchedule->datecreated = date("Y-m-d H:i:s");
$thisSchedule->maint_type = $_POST['mtype'];
$subject = "Maintenance Alert";
$smsmsg = "Maintenance alert for {$thisclientproduct->prod_name} at";
$smsmsg .= $thisclientproduct->install_location . "," . $thisclientproduct->branch;
$smsmsg .= "\r\n Issue:" . $message_issue . "\r\n";
$smsmsg .= "\r\n Comment:" . $issuefield["tissue"] . "\r\n";
$msg = "<h3>Maintenance Detail</h3> <hr />";
$msg .= "<p><strong>Machine: </strong>{$thisclientproduct->prod_name} </p>";
$msg .= "<p><strong>Client: </strong> {$thisClient->name}</p>";
$msg .= "<p><strong>Location: </strong>{$thisclientproduct->install_location} {$thisclientproduct->branch} {$thisclientproduct->install_city} </p>";
$msg .= "<p><strong>Issues: </strong>" . $message_issue . "</p>";
$msg .= "<p><strong>Comment: </strong>" . $issuefield["tissue"] . "</p>";
$msg .= "<br /><br /> <h4>Technician Details</h4> <hr />";
$msg .= "<p><strong>Name: </strong>" . $thisemployee->emp_fname . " " . $thisemployee->emp_lname . "</p>";
$msg .= "<p><strong>Email: </strong>" . $thisemployee->emp_email . "</p>";
$msg .= "<p><strong>Telephone: </strong>" . $thisemployee->emp_phone . "</p>";
$msg .= "<br /><br /><h4>Scheduled Date</h4> <hr />";
$msg .= "<p><strong>{$thisSchedule->s_date}</strong></p><br /><br /><br /><br />";
/**
* the transaction log is created
* to ensure that the product already
* has history and cannot be deleted
*/
$Tlog2 = new Transaction();
$Tlog2->com_id = $thisclientproduct->main_id;
$Tlog2->trans_type = "TASK ASSIGNMENT";
$Tlog2->trans_description = $issuefield["mtype"] . " task assigned to " . $thisemployee->emp_fname . " " . $thisemployee->emp_lname . "";
$Tlog2->datecreated = date("Y-m-d H:i:s");
$Tlog2->user_id = $_SESSION['emp_ident'];
// print_r($msg);
if ($thisSchedule->create()) {
$Tlog2->create();
/**
* this section is needed
* to post issues to database table
* issuelog for statistical analysis on
* issues
*/
//$thisemployee->emp_phone
foreach ($objIssue as $objI) {
foreach ($issuefield as $key => $value) {
if ($key == $objI->issue_accronym) {
$issueLog = new Issuelog();
$issueLog->ticket_id = 0;
$issueLog->issue_id = $objI->id;
$issueLog->issue_accronym = $objI->issue_accronym;
$issueLog->issue_name = $objI->issue_name;
$issueLog->prod_id = $issuefield['cid'];
$issueLog->datecreated = date("Y-m-d H:i:s");
//$ddticket->subject .= $_POST[$objI->issue_accronym]. ", ";
$issueLog->create();
}
}
}
sendSms($thisemployee->emp_phone, $smsmsg);
//method in function.php in the library folder helps to send sms
$this->sendMail($thisSchedule->emp_name, $subject, $msg, $cemail);
// sends email to employee
return 1;
} else {
return 2;
}
}
}
<?php
use Guzzle\Http\Client;
Route::get('/', 'PagesController@index');
Route::get('/answered_questions', 'PagesController@getAnsweredQuestions');
Route::get('/dashboard', 'PagesController@getDashboard');
Route::get('mobile/friends/{id}', function ($id) {
return User::where('id', '!=', $id)->orderByRaw('RAND()')->get();
});
Route::get('mobile/friends/{id}/{friendId}', function ($id, $friendId) {
return User::where('id', $friendId)->first();
});
Route::get('mobile/transactions/{userId}', function ($userId) {
return Transaction::with('sender')->where('user_id', $userId)->orderBy('id', 'DESC')->get();
});
Route::post('mobile/transactions', function () {
$transactionPayload = Input::only('sender_id', 'user_id', 'amount', 'message');
Transaction::create($transactionPayload);
$user = User::findOrFail(Input::get('user_id'));
$user->balance += Input::get('amount');
$user->save();
$sender = User::findOrFail(Input::get('sender_id'));
$sender->balance -= Input::get('amount');
$sender->save();
// publish to colu server the transaction details
// $client = new Client();
// $request = $client->post('http://168.63.245.167:9000/test', null, Input::all());
});
Route::get('mobile/transactions/{transactionId}/view', function ($transactionId) {
return Transaction::with('sender')->findOrFail($transactionId);
});
<?php
require_once 'core/init.php';
$member_role = $_SESSION['roles'];
if (in_array("Laboratory Assistant", $member_role)) {
} else {
header('location:restricted_page.php');
}
if (isset($_SESSION["basket"]) && isset($_SESSION["items"])) {
$state = true;
DB::getInstance()->startTr();
$newTransaction = new Transaction();
$rdate = $_POST["expected_return_date"];
$member = $_SESSION["member_details"]["id"];
$data = array("id" => null, "purpose" => $_POST["purpose"], "borrow_comment" => $_POST["comments"], "return_comment" => null, "member_id" => $_SESSION["member_details"]["id"], "borrowed_date" => date("Y-m-d"), "expected_return_date" => $_POST["expected_return_date"]);
$newTransaction->create($data);
if ($newTransaction->add()) {
$transaction_id = DB::getInstance()->getLastId();
foreach ($_SESSION["basket"] as $key => $value) {
$newItemTransaction = new ItemTransaction();
$data = array("item_copy_id" => $value["item_copy_id"], "transaction_id" => $transaction_id, "borrowed_quantity" => $value["quantity"], "returned_date" => null, "returned_quantity" => null, "status" => 0);
$newItemTransaction->create($data);
if ($newItemTransaction->add()) {
$sql = "UPDATE item_copy SET item_copy_status=0 WHERE item_copy_id='" . $value["item_copy_id"] . "';";
if (!DB::getInstance()->directUpdate($sql)) {
$state = false;
break;
}
} else {
$state = false;
break;
$userId = $user->data()->id;
$curDate = date("Y-m-d");
$curTime = date("h:i:sa");
//data from the session
$paymentType = $_SESSION['type'];
$de_transactionID = $transaction->decodeEasyID($transactionID);
$f = $user->data()->fname;
$l = $user->data()->lname;
$name = $f . " " . $l;
$index = $user->data()->indexNumber;
if (isset($_SESSION['payeeID'])) {
$payeeID = $_SESSION['payeeID'];
} else {
$payeeID = $userId;
}
$transaction->create(array('transactionID' => $de_transactionID, 'payeeID' => $payeeID, 'payerID' => $userId, 'date' => $curDate, 'time' => $curTime, 'statusCode' => $statusCode, 'walletRefID' => $walletReferenceID, 'statusDescription' => $statusDescription, 'amount' => $transactionAmount));
$type = "";
switch ($statusCode) {
case 2:
//Completed transaction
////Type success code here
$str = "<div class='alert alert-info'>Transaction is completed. Payment receipt will be sent to your email <i>{$email} </i>. You can also download it by clicking the download button below.</div>";
if ($paymentType === 1) {
$type = "UCSC registration fee";
//payment type = UCSC registration fee
$t = DB::getInstance()->query('UPDATE ucsc_registration SET paymentStatus = 1 WHERE transactionID = ?', array($de_transactionID));
} elseif ($paymentType === 2) {
$type = "New academic year fee";
//payment type = New academic year fee
$t = DB::getInstance()->query('UPDATE new_academic_year SET paymentStatus = 1 WHERE transactionID = ?', array($de_transactionID));
} elseif ($paymentType === 3) {
public function formObject()
{
$this->data->Transaction = Transaction::create($this->data->id)->getData();
$this->render();
}
public function searchPendingReturns($tid)
{
$items = array();
$result1 = DB::getInstance()->search("transaction", ["transaction_id" => $tid]);
$result2 = DB::getInstance()->search("item_transaction", ["transaction_id" => $tid, "status" => 0]);
foreach ($result2 as $key => $value) {
$data1 = array("item_copy_id" => $value["item_copy_id"], "transaction_id" => $value["transaction_id"], "borrowed_quantity" => $value["borrowed_quantity"], "returned_date" => $value["returned_date"], "returned_quantity" => $value["returned_quantity"], "status" => $value["status"]);
$it = new ItemTransaction();
$it->create($data1);
$items[] = $it;
}
$data2 = array("id" => $result1[0]["transaction_id"], "purpose" => $result1[0]["transaction_description"], "borrow_comment" => $result1[0]["transaction_comment"], "return_comment" => $result1[0]["return_comment"], "member_id" => $result1[0]["member_id"], "borrowed_date" => $result1[0]["borrowed_date"], "expected_return_date" => $result1[0]["expected_return_date"]);
$t = new Transaction();
$t->create($data2);
$t->setItems($items);
return $t;
}
public function run()
{
DB::table('transactions')->delete();
$n = User::where('firstname', '=', 'Nathanael')->first()->id;
$i = User::where('firstname', '=', 'IndiAna')->first()->id;
Transaction::create(array('user_id' => $n, 'amount' => '100.00', 'item' => 'Lucy Will Wedding Gift', 'date_purchased' => date('Y-m-d H:i:s', strtotime('6/5/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '115.00', 'item' => 'Bedding', 'date_purchased' => date('Y-m-d H:i:s', strtotime('6/17/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '16.00', 'item' => 'Dollar Store', 'date_purchased' => date('Y-m-d H:i:s', strtotime('7/3/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '99.00', 'item' => 'Target -- home items', 'date_purchased' => date('Y-m-d H:i:s', strtotime('7/4/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '104.00', 'item' => 'Target -- home items', 'date_purchased' => date('Y-m-d H:i:s', strtotime('7/5/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '387.00', 'item' => 'Flight to Memphis July 4th', 'date_purchased' => date('Y-m-d H:i:s', strtotime('6/9/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '23.00', 'item' => 'India Palace', 'date_purchased' => date('Y-m-d H:i:s', strtotime('7/6/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '50.00', 'item' => 'Curtains', 'date_purchased' => date('Y-m-d H:i:s', strtotime('7/7/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '300.00', 'item' => 'Table and Chairs', 'date_purchased' => date('Y-m-d H:i:s', strtotime('7/29/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '300.00', 'item' => 'TV', 'date_purchased' => date('Y-m-d H:i:s', strtotime('8/30/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '80.99', 'item' => 'Target', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/1/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '49.16', 'item' => 'TV Stand', 'date_purchased' => date('Y-m-d H:i:s', strtotime('8/31/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '-22.06', 'item' => 'Target -- Return Curtain Rod', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/3/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '23.47', 'item' => 'Target -- Bed Stands', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/4/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '8.84', 'item' => 'Target -- Bed Stands', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/3/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '100.00', 'item' => 'Quincy Adoption Fee', 'date_purchased' => date('Y-m-d H:i:s', strtotime('8/22/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '100.95', 'item' => 'Bedroom Art', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/1/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '20.66', 'item' => 'Young Ave Deli', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/12/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '16.41', 'item' => 'Home Depot', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/13/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '7.00', 'item' => 'Mouthwash', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/15/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '13.09', 'item' => '3M Strips', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/18/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '35.00', 'item' => 'Curtains', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/22/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '31.00', 'item' => 'Target', 'date_purchased' => date('Y-m-d H:i:s', strtotime('9/22/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '1453.00', 'item' => 'Quincy Vet Visit', 'date_purchased' => date('Y-m-d H:i:s', strtotime('11/3/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '30.00', 'item' => 'Zoo', 'date_purchased' => date('Y-m-d H:i:s', strtotime('11/9/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '39.90', 'item' => 'Kroger', 'date_purchased' => date('Y-m-d H:i:s', strtotime('11/10/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '5.46', 'item' => 'Dollar Store', 'date_purchased' => date('Y-m-d H:i:s', strtotime('11/17/2013'))));
Transaction::create(array('user_id' => $i, 'amount' => '118.66', 'item' => 'Gas for Madison', 'date_purchased' => date('Y-m-d H:i:s', strtotime('11/30/2013'))));
Transaction::create(array('user_id' => $n, 'amount' => '40.00', 'item' => 'Tea Kettle', 'date_purchased' => date('Y-m-d H:i:s', strtotime('1/24/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '300.00', 'item' => 'South Bluffs Deposit', 'date_purchased' => date('Y-m-d H:i:s', strtotime('3/29/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '15.00', 'item' => 'Little Italy Pizza', 'date_purchased' => date('Y-m-d H:i:s', strtotime('4/27/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '53.58', 'item' => 'Kitchen Stuff', 'date_purchased' => date('Y-m-d H:i:s', strtotime('4/27/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '89.09', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('1/24/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '22.17', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('4/30/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '44.69', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/2/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '78.29', 'item' => 'Bedding / Picinic Blanket', 'date_purchased' => date('Y-m-d H:i:s', strtotime('4/20/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '213.57', 'item' => 'Target', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/10/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '10.37', 'item' => 'Spices', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/10/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '75.98', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/10/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '7.60', 'item' => 'Bread Knife', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/10/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '13.01', 'item' => 'Bread Knife', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/10/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '12.00', 'item' => 'Bagels', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/10/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '37.52', 'item' => 'Home Depot', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/11/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '84.11', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/11/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '24.44', 'item' => 'Bagels', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/18/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '15.00', 'item' => 'Pizza', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/16/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '71.00', 'item' => 'Target', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/18/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '138.29', 'item' => 'Home Depot', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/17/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '14.00', 'item' => 'Patio Chairs', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/26/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '505.76', 'item' => 'Rent', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/16/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '180.00', 'item' => 'May Rent Bristol', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/16/2014'))));
Transaction::create(array('user_id' => $i, 'amount' => '980.00', 'item' => 'June Rent', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/30/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '96.08', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/25/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '99.17', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/18/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '5.01', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('6/5/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '39.85', 'item' => 'Target', 'date_purchased' => date('Y-m-d H:i:s', strtotime('6/1/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '8.18', 'item' => 'Target (les return)', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/26/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '39.77', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/29/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '9.17', 'item' => 'Groceries', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/18/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '12.06', 'item' => 'Bagels', 'date_purchased' => date('Y-m-d H:i:s', strtotime('6/1/2014'))));
Transaction::create(array('user_id' => $n, 'amount' => '60.08', 'item' => 'Bedroom Chest', 'date_purchased' => date('Y-m-d H:i:s', strtotime('5/25/2014'))));
}
/**
* this section is required
* to update employee role
*/
public function UpdateEmpRole()
{
$rEmployee = Employee::find_by_id($_POST['empid']);
$rEmployee->emp_post = $_POST['emppost'];
$rEmployee->emp_dept = $_POST['empdept'];
$empDept = Department::find_by_id($_POST['empdept']);
$Tlog = new Transaction();
$Tlog->com_id = $empDept->dept_code;
$Tlog->trans_type = "HR DEPARTMENT";
$Tlog->trans_description = "Employee assigned to " . $empDept->dept_name . " Department";
$Tlog->datecreated = date("Y-m-d H:i:s");
$Tlog->user_id = $_SESSION['emp_ident'];
$empRole = Roles::find_by_id($_POST['emppost']);
$Tlog2 = new Transaction();
$Tlog2->com_id = $empRole->main_id;
$Tlog2->trans_type = "HR DEPARTMENT";
$Tlog2->trans_description = "Employee assigned " . $empRole->role_name . " Role";
$Tlog2->datecreated = date("Y-m-d H:i:s");
$Tlog2->user_id = $_SESSION['emp_ident'];
if ($rEmployee->update()) {
$Tlog2->create();
$Tlog->create();
return true;
} else {
return false;
}
}
