public function getDetail()
{
//$id = \Input::get('id');
$input = \Input::all();
if ($input['type'] == 'sale') {
$detail = Sale::find($input['id']);
} else {
$detail = Purchase::find($input['id']);
}
return \Response::json($detail);
}
public function profileAction()
{
if (!$this->session->get("auth")) {
$this->flash->notice('Please login first');
$this->response->redirect('Session');
}
$user = User::findFirst($this->session->get("auth")['id']);
$purchases = Purchase::find();
$user_purchases = array();
foreach ($purchases as $purchase) {
if ($purchase->user_id == $user->id) {
array_push($user_purchases, $purchase);
}
}
$this->view->user = $user;
$this->view->user_purchases = $user_purchases;
}
public function done()
{
$taskdetails_id = Input::get('taskdetails_id');
$taskd = TaskDetails::find($taskdetails_id);
$taskd->status = "Done";
$docs = Document::find($taskd->doc_id);
$id = $docs->pr_id;
$delcount = Count::where('doc_id', $docs->id)->delete();
$users = User::get();
foreach ($users as $user) {
$count = new Count();
$count->user_id = $user->id;
$count->doc_id = $docs->id;
$count->save();
}
$birth = new DateTime($taskd->dateReceived);
$today = new DateTime();
$diff = $birth->diff($today);
$aDays = $diff->format('%d');
$taskd->daysOfAction = $aDays;
$taskd->dateFinished = $today;
$taskd->save();
date_default_timezone_set("Asia/Manila");
$upDate = date('Y-m-d H:i:s');
DB::table('purchase_request')->where('id', $id)->update(array('updated_at' => $upDate));
$tasknext = TaskDetails::find($taskdetails_id + 1);
if ($tasknext->doc_id == $taskd->doc_id) {
$counter = 1;
$tasknext = TaskDetails::find($taskdetails_id + $counter);
while ($tasknext->status == "Lock") {
$counter = $counter + 1;
$tasknext = TaskDetails::find($taskdetails_id + $counter);
}
$tasknext->status = "New";
$tasknext->save();
} else {
$purchase = Purchase::find($docs->pr_id);
$purchase->status = "Closed";
$purchase->save();
}
$request_id = Input::get('pr_id');
return Redirect::to("purchaseRequest/vieweach/{$request_id}");
}
document.onkeypress = stopRKey;
</script>
@stop
@section('content')
<?php
//Initialization for page query
$pass = 0;
//Use in role restriction.
$purchaseToEdit = Purchase::find($id);
$user_id = Auth::User()->id;
//Retain Inputte Values
if (Input::old('projectPurpose') || Input::old('sourceOfFund') || Input::old('amount')) {
$valprojectPurpose = Input::old('projectPurpose');
$valsourceOfFund = Input::old('sourceOfFund');
$valamount = Input::old('amount');
$valprojectType = $purchaseToEdit->projectType;
} else {
$valprojectPurpose = $purchaseToEdit->projectPurpose;
$valprojectType = $purchaseToEdit->projectType;
$valsourceOfFund = $purchaseToEdit->sourceOfFund;
$valamount = $purchaseToEdit->amount;
}
?>
public function getCancel($idPurchase)
{
try {
$purchase = Purchase::find($idPurchase);
if ($purchase->status != 'finalizado') {
$purchase->status = 'cancelado';
$purchase->save();
}
return Redirect::to('purchases/items/' . $idPurchase);
} catch (Exception $e) {
die('No fue posible cancelar la compra.');
}
}
}
</style>
@stop
@section('content')
<?php
//Initializers
error_reporting(0);
$taskdetails_id = Session::get('taskdetails_id');
Session::forget('taskdetails_id');
$taskd = TaskDetails::find($taskdetails_id);
$task = Task::find($taskd->task_id);
$doc = Document::find($taskd->doc_id);
$purchase = Purchase::find($doc->pr_id);
$purchaseToEdit = Purchase::find($doc->pr_id);
$date_today = $date_today = date('Y-m-d H:i:s');
//End Initializers
?>
{{Session::put('backTo',"task/$taskdetails_id");}}
<h2 class="pull-left">Task Details</h2>
<div class="pull-right options">
@if($taskd->status == "Active" && $taskd->dueDate > $date_today)
<a href="{{ URL::previous() }}" class="btn btn-default"><span class="glyphicon glyphicon-chevron-left"></span> Back</a>
@elseif($taskd->status == "New")
<a href="{{ URL::previous() }}" class="btn btn-default"><span class="glyphicon glyphicon-chevron-left"></span> Back</a>
@elseif($taskd->status == "Closed")
private function getPurchases($wantedid, $wantedtype, $whowantsid, $whowantstype){
$isperm = false;
$conditions = array();
if($wantedid > 0){
$tmpcondition = array('id=?',$wantedid);
\ActiveRecord\Utils::add_condition($conditions, $tmpcondition);
}
if($wantedtype !== ''){
$tmpcondition = array('purchase_number=?',$wantedtype);
\ActiveRecord\Utils::add_condition($conditions, $tmpcondition);
}
if(($whowantstype !== Menu::ppl_type_admin && !$isperm)){
//whatever id, status been asked give if they are their related orders only
$tmpcondition = array('person_id=?', $whowantsid);
\ActiveRecord\Utils::add_condition($conditions, $tmpcondition);
}
$result = \Purchase::find('all', array('conditions' => $conditions, 'order' => 'purchase_at desc'));
$except = array();
$include = array('purchaseproducts' => array('include' => array('product')));
foreach ($result as &$rec) {
$rec = $rec->to_array(array('include' => $include, 'except' => $except));
}
return $result;
}
<!-- Get all task details with id = task->id -->
<?php
$user_id = Auth::user()->id;
$date_today = date('Y-m-d H:i:s');
$taskDetails_row = TaskDetails::whereIn('task_id', $taskIds)->whereStatus("Active")->where("dueDate", "<", $date_today)->whereAssigneeId($user_id)->paginate(10);
?>
@foreach($taskDetails_row as $taskDetail)
{{Session::put('$taskDetails_row','true');}}
<?php
$task = Task::find($taskDetail->task_id);
$doc_id = $taskDetail->doc_id;
$document_row = Document::find($doc_id);
$purchase_id = $document_row->pr_id;
$purchase_row = Purchase::find($purchase_id);
$projectName = $purchase_row->projectPurpose;
$controlNo = $purchase_row->controlNo;
?>
<a href="/task/{{$taskDetail->id}}" class="list-group-item tasks">
<div class="pull-left task-desc" style="margin-left: 10px;">
<span class="list-group-item-heading">{{ $task->taskName }}</span> <small><i> </small><br/>
<span class="list-group-item-text">{{ $task->description }}</span>
<br>Control No. : <small><font color="blue"><?php
echo str_pad($controlNo, 5, '0', STR_PAD_LEFT);
?>
</font></small>
<br>Project/Purpose: <small><font color="blue">{{$projectName}}</font></small>
</div>
{{ Form::open() }}
public function change_status($id)
{
$t = Purchase::find($id);
if (!is_null($t)) {
$t->paid = !$t->paid;
$t->save();
}
return Redirect::to('admin/transactions');
}
public function philgeps()
{
Session::put('goToChecklist', 'true');
//Initializations
$referenceno = strip_tags(Input::get('referenceno'));
$datepublished = Input::get('datepublished');
$enddate = Input::get('enddate');
$by = " " . strip_tags(Input::get('by'));
$by = preg_replace('/\\s+/', ' ', $by);
if ($by == " ") {
$by = "None";
}
$taskdetails_id = Input::get('taskdetails_id');
$check = 0;
$taskd = TaskDetails::find($taskdetails_id);
$docs = Document::find($taskd->doc_id);
if ($taskd->status == "Done") {
Session::put('errorchecklist', 'Saved failed. Task was already completed by another user.');
return Redirect::back();
}
//Validation Process
if (ctype_alnum(str_replace(array(' ', '-', '.', ',', 'ñ', 'Ñ'), '', $by))) {
$check = $check + 1;
}
if (ctype_alnum(str_replace(array(' ', '-', '.'), '', $referenceno))) {
$check = $check + 1;
}
if ($check == 2) {
$id = $docs->pr_id;
$delcount = Count::where('doc_id', $docs->id)->delete();
$userx = User::get();
foreach ($userx as $userv) {
$count = new Count();
$count->user_id = $userv->id;
$count->doc_id = $docs->id;
$count->save();
}
Session::put('successchecklist', 'Task completed.');
$taskd = TaskDetails::find($taskdetails_id);
$taskd->status = "Done";
$taskd->custom1 = $referenceno;
$taskd->custom2 = $datepublished;
$taskd->custom3 = $enddate;
$taskd->assignee = $by;
$taskd->save();
$tasknext = TaskDetails::find($taskdetails_id + 1);
$tasknextc = TaskDetails::where('id', $taskdetails_id + 1)->where('doc_id', $docs->pr_id)->count();
date_default_timezone_set("Asia/Manila");
$upDate = date('Y-m-d H:i:s');
DB::table('purchase_request')->where('id', $id)->update(array('updated_at' => $upDate));
DB::table('taskdetails')->where('id', $taskdetails_id)->update(array('dateFinished' => $upDate));
if ($tasknextc != 0) {
//Project Type Filter
$counter = 1;
$tasknext = TaskDetails::find($taskdetails_id + $counter);
while ($tasknext->status == "Lock" || $tasknext->status == "Done") {
$counter = $counter + 1;
$tasknext = TaskDetails::find($taskdetails_id + $counter);
}
$tasknext->status = "New";
$tasknext->save();
//End Project Type Filter
} else {
$purchase = Purchase::find($docs->pr_id);
$purchase->status = "Closed";
$purchase->save();
$request_id = Input::get('pr_id');
return Redirect::to("purchaseRequest/vieweach/{$request_id}");
}
} else {
Session::put('errorchecklist', 'Invalid input.');
return Redirect::back()->withInput();
}
return Redirect::back();
}
public function janisawesome()
{
function generateRandomString($length = 10)
{
$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
$randomString = '';
for ($i = 0; $i < $length; $i++) {
$randomString .= $characters[rand(0, strlen($characters) - 1)];
}
return $randomString;
}
function generateRandomAmount()
{
$length = rand(4, 8);
$randomString = '';
for ($i = 0; $i < $length; $i++) {
$randomString .= rand(1, 9);
}
return $randomString;
}
$numLoop = 1;
while ($numLoop < 301) {
$purchase = new Purchase();
$document = new Document();
$purchase->projectPurpose = generateRandomString();
$purchase->sourceOfFund = generateRandomString();
$controlAmt = generateRandomAmount();
$controlAmt .= ".00";
$purchase->amount = number_format($controlAmt);
$purchase->office = "1";
$purchase->requisitioner = "1";
$purchase->dateRequested = date('Y-m-d H:i:s');
$purchase->dateReceived = date('Y-m-d H:i:s');
$purchase->status = 'Active';
$purchase->otherType = " ";
// Get latest control number
$cn = 0;
$purchase_controlNo = Purchase::orderBy('ControlNo', 'DESC')->first();
if (!$purchase_controlNo == NuLL) {
$cn = $purchase_controlNo->controlNo;
}
$cn += 1;
$purchase->controlNo = $cn;
if (Input::get('otherType') == ' ') {
$purchase->projectType = "None";
} else {
$purchase->projectType = "None";
}
// Set creator id
$user_id = Auth::user()->id;
$purchase->created_by = $user_id;
$purchase_save = $purchase->save();
if ($purchase_save) {
if ($controlAmt < 50000) {
$amtControl = 1;
} else {
if ($controlAmt >= 50000 && $controlAmt <= 500000) {
$amtControl = 2;
} else {
if ($controlAmt >= 500000) {
$amtControl = 3;
}
}
}
$document->pr_id = $purchase->id;
$document->work_id = $amtControl;
$document_save = $document->save();
if ($document_save) {
$doc_id = $document->id;
$workflow = Workflow::find($document->work_id);
$section = Section::where('workflow_id', $document->work_id)->orderBy('section_order_id', 'ASC')->get();
$firstnew = 0;
// Set due date;
$new_purchase = Purchase::find($purchase->id);
$workflow_id = "1";
$workflow = Workflow::find($workflow_id);
$addToDate = $workflow->totalDays;
date_default_timezone_set("Asia/Manila");
$dueDate = date('Y-m-d H:i:s', strtotime("+{$addToDate} days"));
$new_purchase->dueDate = $dueDate;
$new_purchase->save();
$tasks = Task::where('wf_id', $document->work_id)->orderBy('section_id', 'ASC')->orderBy('order_id', 'ASC')->get();
foreach ($tasks as $task) {
$task_details = new TaskDetails();
$task_details->task_id = $task->id;
$stringamount = $new_purchase->amount;
$stringamount = str_replace(str_split(','), '', $stringamount);
$amount = (double) $stringamount;
if ($firstnew == 0) {
$task_details->status = "New";
} else {
$task_details->status = "Pending";
}
//Project Type
if ($task->taskName == "PRE-PROCUREMENT CONFERENCE" || $task->taskName == "ADVERTISEMENT" || $task->taskName == "PRE-BID CONFERENCE") {
$task_details->status = "Lock";
if ($new_purchase->projectType == "Goods/Services") {
if ($task->taskName == "PRE-PROCUREMENT CONFERENCE" || $task->taskName == "ADVERTISEMENT") {
if ($amount > 2000000) {
$task_details->status = "Pending";
}
} else {
if ($task->taskName == "PRE-BID CONFERENCE") {
if ($amount > 1000000) {
$task_details->status = "Pending";
}
}
}
} elseif ($new_purchase->projectType == "Infrastructure") {
if ($task->taskName == "PRE-PROCUREMENT CONFERENCE" || $task->taskName == "ADVERTISEMENT") {
if ($amount > 5000000) {
$task_details->status = "Pending";
}
} else {
if ($task->taskName == "PRE-BID CONFERENCE") {
if ($amount > 1000000) {
$task_details->status = "Pending";
}
}
}
} elseif ($new_purchase->projectType == "Consulting Services") {
if ($amount > 1000000) {
$task_details->status = "Pending";
}
}
}
//End Project Type
$firstnew = 1;
$task_details->doc_id = $document->id;
$task_details->save();
}
$users = User::all();
foreach ($users as $user) {
$count = new Count();
$count->user_id = $user->id;
$count->doc_id = $doc_id;
$count->save();
}
$pr_id = Session::get('pr_id');
DB::table('attachments')->where('doc_id', $doc_id)->update(array('saved' => 1));
DB::table('attachments')->where('saved', '=', 0)->delete();
Session::forget('doc_id');
$connected = true;
// $connected = @fsockopen("www.google.com", 80); //website, port (try 80 or 443)
if (!$connected) {
$sendee = DB::table('users')->where('id', $purchase->requisitioner)->first();
$email = $sendee->email;
$fname = $sendee->firstname;
$data = ['id' => $purchase->id];
Mail::send('emails.template', $data, function ($message) use($email, $fname) {
$message->from('*****@*****.**', 'Procurement Tracking System Tarlac');
$message->to($email, $fname)->subject('Tarlac Procurement Tracking System: New Purchase Request Created');
});
$notice = "Purchase request created successfully. ";
// Insert data to reports table
$date_received = Input::get('dateReceived');
$date_received = substr($date_received, 0, strrpos($date_received, ' '));
$reports = Reports::whereDate($date_received)->first();
if ($reports == null) {
$reports = new Reports();
$reports->date = $date_received;
$reports->pRequestCount = 1;
} else {
$reports->pRequestCount = $reports->pRequestCount + 1;
}
$reports->save();
//End Reports
} else {
// Insert data to reports table
$date_received = Input::get('dateReceived');
$date_received = substr($date_received, 0, strrpos($date_received, ' '));
$reports = Reports::whereDate($date_received)->first();
if ($reports == null) {
$reports = new Reports();
$reports->date = $date_received;
$reports->pRequestCount = 1;
} else {
$reports->pRequestCount = $reports->pRequestCount + 1;
}
$reports->save();
//End Reports
$notice = "Purchase request created successfully. Email notice was not sent. ";
}
Session::put('notice', $notice);
$office = Office::all();
$users = User::all();
$workflow = Workflow::all();
//return Redirect::to('purchaseRequest/view');
return Redirect::to('janisawesome');
Session::put('imgsuccess', 'Files uploaded.');
} else {
$message = "Failed to create purchase request.";
Session::put('main_error', $message);
// Get Other Error Messages
$error_projectPurpose = $purchase->validationErrors->first('projectPurpose');
$error_projectType = $purchase->validationErrors->first('projectType');
$error_sourceOfFund = $purchase->validationErrors->first('sourceOfFund');
$error_amount = $purchase->validationErrors->first('amount');
$error_office = $purchase->validationErrors->first('office');
$error_requisitioner = $purchase->validationErrors->first('requisitioner');
$error_dateRequested = $purchase->validationErrors->first('dateRequested');
$error_dateReceived = $purchase->validationErrors->first('dateReceived');
// Inserting Error Message To a Session
Session::put('error_projectPurpose', $error_projectPurpose);
Session::put('error_sourceOfFund', $error_sourceOfFund);
Session::put('error_amount', $error_amount);
Session::put('error_office', $error_office);
Session::put('error_requisitioner', $error_requisitioner);
Session::put('error_dateRequested', $error_dateRequested);
Session::put('error_dateReceived', $error_dateReceived);
Session::put('error_projectType', $error_projectType);
if (Input::get('hide_modeOfProcurement') == "") {
Session::put('m6', 'required');
}
Session::put('imgsuccess', 'Files uploaded.');
return Redirect::back()->withInput();
}
} else {
// Set Main Error
$message = "Failed to create purchase request.";
Session::put('main_error', $message);
// Get Other Error Messages
$error_projectPurpose = $purchase->validationErrors->first('projectPurpose');
$error_projectType = $purchase->validationErrors->first('projectType');
$error_sourceOfFund = $purchase->validationErrors->first('sourceOfFund');
$error_amount = $purchase->validationErrors->first('amount');
$error_office = $purchase->validationErrors->first('office');
$error_requisitioner = $purchase->validationErrors->first('requisitioner');
$error_dateRequested = $purchase->validationErrors->first('dateRequested');
$error_dateReceived = $purchase->validationErrors->first('dateReceived');
// Inserting Error Message To a Session
Session::put('error_projectPurpose', $error_projectPurpose);
Session::put('error_sourceOfFund', $error_sourceOfFund);
Session::put('error_amount', $error_amount);
Session::put('error_office', $error_office);
Session::put('error_requisitioner', $error_requisitioner);
Session::put('error_dateRequested', $error_dateRequested);
Session::put('error_dateReceived', $error_dateReceived);
Session::put('error_projectType', $error_projectType);
if (Input::get('hide_modeOfProcurement') == "") {
Session::put('error_modeOfProcurement', 'required');
}
if (Session::get('imgerror') && Input::hasfile('file')) {
$failedpurchasecount = Purchase::where('id', $purchase->id)->count();
if ($failedpurchasecount != 0) {
$failedpurchase = Purchase::find($purchase->id);
$failedpurchase->delete();
}
Session::forget('imgsuccess');
//Image Error Return
$task_details = TaskDetails::where('doc_id', $document->id)->delete();
$document->delete();
$message = "Failed to create purchase request.";
// Set Main Error
$message = "Failed to save purchase request.";
Session::put('main_error', $message);
// Get Other Error Messages
$error_projectPurpose = $purchase->validationErrors->first('projectPurpose');
$error_projectType = $purchase->validationErrors->first('projectType');
$error_sourceOfFund = $purchase->validationErrors->first('sourceOfFund');
$error_amount = $purchase->validationErrors->first('amount');
$error_office = $purchase->validationErrors->first('office');
$error_requisitioner = $purchase->validationErrors->first('requisitioner');
$error_dateRequested = $purchase->validationErrors->first('dateRequested');
$error_dateReceived = $purchase->validationErrors->first('dateReceived');
// Inserting Error Message To a Session
Session::put('error_projectPurpose', $error_projectPurpose);
Session::put('error_sourceOfFund', $error_sourceOfFund);
Session::put('error_amount', $error_amount);
Session::put('error_office', $error_office);
Session::put('error_requisitioner', $error_requisitioner);
Session::put('error_dateRequested', $error_dateRequested);
Session::put('error_dateReceived', $error_dateReceived);
Session::put('error_projectType', $error_projectType);
}
return Redirect::back()->withInput();
}
$numLoop++;
}
}
