function delete($id = FALSE)
{
if ($id) {
$document = new Document($id);
$document->delete();
set_notify('success', lang('delete_data_complete'));
}
redirect('documents');
}
function reinitializeImport($itemtype, $items_id)
{
global $DB;
if ($this->getFromDBbyDevice($items_id, $itemtype)) {
$doc = new Document();
if ($doc->GetfromDB($this->fields["documents_id"])) {
$query = "DELETE\n FROM `glpi_documents_items`\n WHERE `documents_id` = '" . $this->fields["documents_id"] . "';";
$result = $DB->query($query);
if (is_file(GLPI_DOC_DIR . "/" . $doc->fields["filename"]) && !is_dir(GLPI_DOC_DIR . "/" . $doc->fields["filename"])) {
unlink(GLPI_DOC_DIR . "/" . $doc->fields["filename"]);
}
$doc->delete(array('id' => $this->fields["documents_id"]), true);
}
}
if (isset($this->fields["id"])) {
$this->delete(array('id' => $this->fields["id"]));
}
}
/**
* Transfer documents
*
* @param $itemtype original type of transfered item
* @param $ID original ID of the document
* @param $newID new ID of the document
**/
function transferDocuments($itemtype, $ID, $newID)
{
global $DB;
$need_clean_process = false;
// if keep
if ($this->options['keep_document']) {
$document = new Document();
// Get contracts for the item
$query = "SELECT *\n FROM `glpi_documents_items`\n WHERE `items_id` = '{$ID}'\n AND `itemtype` = '{$itemtype}'\n AND `documents_id` NOT IN " . $this->item_recurs['Document'];
if ($result = $DB->query($query)) {
if ($DB->numrows($result) > 0) {
// Foreach get item
while ($data = $DB->fetch_array($result)) {
$need_clean_process = false;
$item_ID = $data['documents_id'];
$newdocID = -1;
// is already transfer ?
if (isset($this->already_transfer['Document'][$item_ID])) {
$newdocID = $this->already_transfer['Document'][$item_ID];
if ($newdocID != $item_ID) {
$need_clean_process = true;
}
} else {
// No
// Can be transfer without copy ? = all linked items need to be transfer (so not copy)
$canbetransfer = true;
$query = "SELECT DISTINCT `itemtype`\n FROM `glpi_documents_items`\n WHERE `documents_id` = '{$item_ID}'";
if ($result_type = $DB->query($query)) {
if ($DB->numrows($result_type) > 0) {
while (($data_type = $DB->fetch_array($result_type)) && $canbetransfer) {
$dtype = $data_type['itemtype'];
if (isset($this->item_search[$dtype])) {
// No items to transfer -> exists links
$query_search = "SELECT count(*) AS CPT\n FROM `glpi_documents_items`\n WHERE `documents_id` = '{$item_ID}'\n AND `itemtype` = '{$dtype}'\n AND `items_id`\n NOT IN " . $this->item_search[$dtype];
// contacts, contracts, and enterprises are linked as device.
if (isset($this->item_recurs[$dtype])) {
$query_search .= " AND `items_id`\n NOT IN " . $this->item_recurs[$dtype];
}
$result_search = $DB->query($query_search);
if ($DB->result($result_search, 0, 'CPT') > 0) {
$canbetransfer = false;
}
}
}
}
}
// Yes : transfer
if ($canbetransfer) {
$this->transferItem('Document', $item_ID, $item_ID);
$newdocID = $item_ID;
} else {
$need_clean_process = true;
$document->getFromDB($item_ID);
// No : search contract
$query = "SELECT *\n FROM `glpi_documents`\n WHERE `entities_id` = '" . $this->to . "'\n AND `name` = '" . addslashes($document->fields['name']) . "'";
if ($result_search = $DB->query($query)) {
if ($DB->numrows($result_search) > 0) {
$newdocID = $DB->result($result_search, 0, 'id');
$this->addToAlreadyTransfer('Document', $item_ID, $newdocID);
}
}
// found : use it
// not found : copy doc
if ($newdocID < 0) {
// 1 - create new item
unset($document->fields['id']);
$input = $document->fields;
// Not set new entity Do by transferItem
unset($document->fields);
$newdocID = $document->add($input);
// 2 - transfer as copy
$this->transferItem('Document', $item_ID, $newdocID);
}
}
}
// Update links
if ($ID == $newID) {
if ($item_ID != $newdocID) {
$query = "UPDATE `glpi_documents_items`\n SET `documents_id` = '{$newdocID}'\n WHERE `id` = '" . $data['id'] . "'";
$DB->query($query);
}
// Same Item -> update links
} else {
// Copy Item -> copy links
if ($item_ID != $newdocID) {
$query = "INSERT\n INTO `glpi_documents_items`\n (`documents_id`, `items_id`, `itemtype`)\n VALUES ('{$newdocID}','{$newID}','{$itemtype}')";
$DB->query($query);
} else {
// same doc for new item update link
$query = "UPDATE\n `glpi_documents_items`\n SET `items_id` = '{$newID}'\n WHERE `id` = '" . $data['id'] . "'";
$DB->query($query);
}
}
// If clean and unused ->
if ($need_clean_process && $this->options['clean_document']) {
$query = "SELECT COUNT(*) AS CPT\n FROM `glpi_documents_items`\n WHERE `documents_id` = '{$item_ID}'";
if ($result_remaining = $DB->query($query)) {
if ($DB->result($result_remaining, 0, 'CPT') == 0) {
if ($this->options['clean_document'] == 1) {
$document->delete(array('id' => $item_ID));
}
if ($this->options['clean_document'] == 2) {
// purge
$document->delete(array('id' => $item_ID), 1);
}
}
}
}
}
}
}
} else {
// else unlink
$query = "DELETE\n FROM `glpi_documents_items`\n WHERE `items_id` = '{$ID}'\n AND `itemtype` = '{$itemtype}'";
$DB->query($query);
}
}
Session::checkLoginUser();
if (!isset($_GET["id"])) {
$_GET["id"] = -1;
}
$doc = new Document();
$documentitem = new Document_Item();
if (isset($_POST["add"])) {
$doc->check(-1, 'w', $_POST);
if ($newID = $doc->add($_POST)) {
Event::log($newID, "documents", 4, "login", sprintf(__('%1$s adds the item %2$s'), $_SESSION["glpiname"], $doc->fields["name"]));
}
Html::back();
} else {
if (isset($_POST["delete"])) {
$doc->check($_POST["id"], 'd');
if ($doc->delete($_POST)) {
Event::log($_POST["id"], "documents", 4, "document", sprintf(__('%s deletes an item'), $_SESSION["glpiname"]));
}
$doc->redirectToList();
} else {
if (isset($_POST["restore"])) {
$doc->check($_POST["id"], 'd');
if ($doc->restore($_POST)) {
Event::log($_POST["id"], "documents", 4, "document", sprintf(__('%s restores an item'), $_SESSION["glpiname"]));
}
$doc->redirectToList();
} else {
if (isset($_POST["purge"])) {
$doc->check($_POST["id"], 'd');
if ($doc->delete($_POST, 1)) {
Event::log($_POST["id"], "documents", 4, "document", sprintf(__('%s purges an item'), $_SESSION["glpiname"]));
public function removeLicense()
{
//delete all documents and associated expressions and SFX providers
$document = new Document();
foreach ($this->getDocuments() as $document) {
//delete all expressions and expression notes
$expression = new Expression();
foreach ($document->getExpressions() as $expression) {
$expressionNote = new ExpressionNote();
foreach ($expression->getExpressionNotes() as $expressionNote) {
$expressionNote->delete();
}
$expression->removeQualifiers();
$expression->delete();
}
$sfxProvider = new SFXProvider();
foreach ($document->getSFXProviders() as $sfxProvider) {
$sfxProvider->delete();
}
$signature = new Signature();
foreach ($document->getSignatures() as $signature) {
$signature->delete();
}
$document->delete();
}
//delete all attachments
$attachment = new Attachment();
foreach ($this->getAttachments() as $attachment) {
$attachmentFile = new AttachmentFile();
foreach ($attachment->getAttachmentFiles() as $attachmentFile) {
$attachmentFile->delete();
}
$attachment->delete();
}
$this->delete();
}
break;
case 'deleteDocument':
//note - does not delete physical document
$document = new Document(new NamedArguments(array('primaryKey' => $_GET['documentID'])));
//delete children sfx providers
$sfxProvider = new SFXProvider();
foreach ($document->getSFXProviders() as $sfxProvider) {
$sfxProvider->delete();
}
//delete children signatures
$signature = new Signature();
foreach ($document->getSignatures() as $signature) {
$signature->delete();
}
try {
$document->delete();
} catch (Exception $e) {
echo $e->getMessage();
}
break;
case 'submitSignature':
//set date for proper saving
if (isset($_POST['signatureDate']) && $_POST['signatureDate'] != '') {
$signatureDate = date("Y-m-d", strtotime($_POST['signatureDate']));
} else {
$signatureDate = "";
}
//if signatureID is sent then this is an update
if (isset($_POST['signatureID']) && $_POST['signatureID'] != '') {
$signature = new Signature(new NamedArguments(array('primaryKey' => $_POST['signatureID'])));
} else {
$groupname = getStringFromRequest('groupname');
$parent_doc_group = getIntFromRequest('parent_doc_group');
$dg = new DocumentGroup($g);
if ($dg->isError()) {
exit_error('Error', $dg->getErrorMessage());
}
if (!$dg->create($groupname, $parent_doc_group)) {
exit_error('Error', $dg->getErrorMessage());
}
$feedback = _('Created successfully');
} elseif (getStringFromRequest('deletedoc') && $docid && getStringFromRequest('sure') && getStringFromRequest('really_sure')) {
$d = new Document($g, $docid);
if ($d->isError()) {
exit_error('Error', $d->getErrorMessage());
}
if (!$d->delete()) {
exit_error('Error', $d->getErrorMessage());
}
$feedback = _('Deleted');
header('Location: index.php?group_id=' . $d->Group->getID() . '&feedback=' . urlencode($feedback));
die;
// End parsing file and redirect
}
}
//
//
// Edit a specific document
//
//
if ($editdoc && $docid) {
$d = new Document($g, $docid);
function document_delete($doc_id)
{
global $database;
// FIND THE DOCUMENT SETTINGS PARAMETER
$query = "SELECT * FROM se_document_parameters";
$params = $database->database_fetch_assoc($database->database_query($query));
$scribd_api_key = $params['api_key'];
$scribd_secret = $params['secret_key'];
// CRAETE DOCUMENT OBJECT
$scribd = new Document($scribd_api_key, $scribd_secret, $user->user_info['user_id']);
// IF DOCUMNET ID IS NUMERIC
if (is_numeric($doc_id)) {
$document = $database->database_fetch_assoc($database->database_query("SELECT document_user_id, document_doc_id, document_filepath FROM se_documents WHERE document_id = '{$doc_id}'"));
if (!empty($document)) {
$scribd->my_user_id = $document['document_user_id'];
$data = $scribd->delete($document['document_doc_id']);
if ($data) {
// DELETE THE DOCUMENTS
$database->database_query("DELETE FROM se_documents WHERE document_id = '{$doc_id}'");
// DELETE DOCUMENTS TAGS
$database->database_query("DELETE FROM se_documents_tags WHERE document_id = '{$doc_id}'");
// DELETE DOCUMENTS COMMENTS
$database->database_query("DELETE FROM se_documentcomments WHERE documentcomment_document_id = '{$doc_id}'");
// DELETE DOCUMENTS NOTIFICATIONS
$database->database_query("\r\n\t\t\t\t DELETE FROM\r\n\t\t\t\t se_notifys\r\n\t\t\t\t USING\r\n\t\t\t\t se_notifys\r\n\t\t\t\t LEFT JOIN\r\n\t\t\t\t se_notifytypes\r\n\t\t\t\t ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id\r\n\t\t\t\t WHERE\r\n\t\t\t\t se_notifytypes.notifytype_name='documentcomment' AND\r\n\t\t\t\t notify_object_id='{$doc_id}'\r\n\t\t\t\t ");
// UNLINK THE DOCUMENTS
if (!empty($document['document_filepath'])) {
unlink('.' . $document['document_filepath']);
}
}
} else {
return FALSE;
}
} elseif (is_array($doc_id)) {
// IF MORE THAN ONE DOCUMENTS IS GOING TO DELETE AT A ONE TIME
foreach ($doc_id as $document_id) {
$document = $database->database_fetch_assoc($database->database_query("SELECT document_user_id, document_doc_id, document_filepath FROM se_documents WHERE document_id = '{$document_id}'"));
if (!empty($document)) {
$scribd->my_user_id = $document['document_user_id'];
$data = $scribd->delete($document['document_doc_id']);
if ($data) {
// DELETE THE DOCUMENTS
$database->database_query("DELETE FROM se_documents WHERE document_id = '{$document_id}'");
// DELETE DOCUMENTS TAGS
$database->database_query("DELETE FROM se_documents_tags WHERE document_id = '{$document_id}'");
// DELETE DOCUMENTS COMMENTS
$database->database_query("DELETE FROM se_documentcomments WHERE documentcomment_document_id = '{$document_id}'");
// DELETE DOCUMENTS NOTIFICATIONS
$database->database_query("\r\n\t\t\t\t DELETE FROM\r\n\t\t\t\t se_notifys\r\n\t\t\t\t USING\r\n\t\t\t\t se_notifys\r\n\t\t\t\t LEFT JOIN\r\n\t\t\t\t se_notifytypes\r\n\t\t\t\t ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id\r\n\t\t\t\t WHERE\r\n\t\t\t\t se_notifytypes.notifytype_name='documentcomment' AND\r\n\t\t\t\t notify_object_id='{$document_id}'\r\n\t\t\t\t ");
// UNLINK THE DOCUMENTS
if (!empty($document['document_filepath'])) {
unlink('.' . $document['document_filepath']);
}
}
}
}
} else {
return FALSE;
}
}
/**
* @see Document::delete
* @return void
*/
public function delete()
{
$versions = $this->getVersions();
foreach ($versions as $version) {
$version->delete();
}
// remove all tasks
$this->getResource()->deleteAllTasks();
parent::delete();
}
public function create_submit()
{
//Image Upload
$users = DB::table('users')->get();
$purchasecheck = DB::table('purchase_request')->count();
if ($purchasecheck != 0) {
$purchase = Purchase::orderby('id', 'DESC')->first();
$docs = Document::orderby('id', 'DESC')->first();
$pr_id = $purchase->id + 1;
$doc_id = $docs->id + 1;
} else {
$pr_id = 1;
$doc_id = 1;
}
foreach (Input::file('file') as $file) {
$rules = array('file' => 'required|mimes:png,gif,jpeg,jpg|max:900000000000000000000');
$validator = \Validator::make(array('file' => $file), $rules);
$destine = public_path() . "/uploads";
if ($validator->passes()) {
$ext = $file->guessClientExtension();
// (Based on mime type)
$ext = $file->getClientOriginalExtension();
// (Based on filename)
$filename = $file->getClientOriginalName();
$archivo = value(function () use($file) {
$filename = str_random(10) . '.' . $file->getClientOriginalExtension();
return strtolower($filename);
});
$archivo = value(function () use($file) {
$date = date('m-d-Y-h-i-s', time());
$filename = $date . "-" . $file->getClientOriginalName();
return strtolower($filename);
});
$attach = new Attachments();
$attach->doc_id = $doc_id;
$attach->data = $archivo;
$attach->save();
$filename = $doc_id . "_" . $attach->id;
$file->move($destine, $archivo);
$target_folder = $destine;
$upload_image = $target_folder . "/" . $archivo;
$thumbnail = $target_folder . "/resize" . $archivo;
$actual = $target_folder . "/" . $archivo;
// THUMBNAIL SIZE
list($width, $height) = getimagesize($upload_image);
$newwidth = $width;
$newheight = $height;
while ($newheight > 525) {
$newheight = $newheight * 0.8;
$newwidth = $newwidth * 0.8;
}
$source = $upload_image;
$ext = strtolower($ext);
$thumb = imagecreatetruecolor($newwidth, $newheight);
if ($ext == "jpg" || $ext == "jpeg") {
$source = imagecreatefromjpeg($upload_image);
} elseif ($ext == "png") {
$source = imagecreatefrompng($upload_image);
} elseif ($ext == "gif") {
$source = imagecreatefromgif($upload_image);
} else {
continue;
}
// RESIZE
imagecopyresized($thumb, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
// MAKE NEW FILES
if ($ext == "jpg" || $ext == "jpeg") {
imagejpeg($thumb, $thumbnail, 100);
} elseif ($ext == "png") {
imagepng($thumb, $thumbnail, 9);
} elseif ($ext == "gif") {
imagegif($thumb, $thumbnail, 100);
} else {
echo "An invalid image";
}
unlink($actual);
// FILE RENAMES
rename($thumbnail, $actual);
} else {
$errors = $validator->errors();
Session::put('imgerror', 'Invalid file.');
}
}
//End Image Upload
$purchase = new Purchase();
$document = new Document();
$purchase->projectPurpose = strip_tags(Input::get('projectPurpose'));
$purchase->sourceOfFund = strip_tags(Input::get('sourceOfFund'));
$purchase->amount = Input::get('amount');
$purchase->office = Input::get('office');
$purchase->requisitioner = Input::get('requisitioner');
if (!Input::get('dateRequested') == '') {
$purchase->dateRequested = Input::get('dateRequested');
}
$purchase->dateReceived = Input::get('dateReceived');
$purchase->status = 'Active';
$purchase->otherType = Input::get('otherType');
// Get latest control number
$cn = Input::get('controlNo');
$checkUniqueControlNo = Purchase::where('controlNo', '=', "{$cn}")->count();
if ($checkUniqueControlNo != 0) {
$purchase->controlNo = '';
} else {
$purchase->controlNo = Input::get('controlNo');
}
if (Input::get('otherType') == 'Pakyaw') {
$purchase->projectType = "None";
} else {
$purchase->projectType = Input::get('projectType');
}
// Set creator id
$user_id = Auth::user()->id;
$purchase->created_by = $user_id;
$purchase_save = $purchase->save();
if ($purchase_save && (Session::get('imgerror') == NULL || !Input::hasfile('file'))) {
$document->pr_id = $purchase->id;
$document->work_id = Input::get('hide_modeOfProcurement');
$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 = Input::get('hide_modeOfProcurement');
$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');
if (!Input::hasfile('file')) {
Session::forget('imgerror');
}
$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. ";
} else {
$notice = "Purchase request created successfully. Email notice was not sent. ";
}
// 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
Session::put('notice', $notice);
$office = Office::all();
$users = User::all();
$workflow = Workflow::all();
return Redirect::to('purchaseRequest/view');
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');
$error_controlNo = $purchase->validationErrors->first('controlNo');
// 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);
Session::put('error_controlNo', $error_controlNo);
if ($checkUniqueControlNo != 0) {
Session::put('error_controlNo', 'This control no. already exists. Please enter a new one.');
}
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);
if (!Input::hasfile('file')) {
Session::forget('imgerror');
}
// 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');
$error_controlNo = $purchase->validationErrors->first('controlNo');
// 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);
Session::put('error_controlNo', $error_controlNo);
if ($checkUniqueControlNo != 0) {
Session::put('error_controlNo', 'This control no. already exists. Please enter a new one.');
}
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');
$error_controlNo = $purchase->validationErrors->first('controlNo');
// 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);
Session::put('error_controlNo', $error_controlNo);
if ($checkUniqueControlNo != 0) {
Session::put('error_controlNo', 'This control no. already exists. Please enter a new one.');
}
}
return Redirect::back()->withInput();
}
}
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++;
}
}
function showDocs()
{
global $connector;
global $result;
$course = new Course();
$doc = new Document();
$course->setConnector($connector);
$doc->setConnector($connector);
if (isset($_POST['operation'])) {
list($operation, $params) = explode("#", $_POST['operation']);
switch ($operation) {
case 'saveChanges':
$doc->storeFormValues($_POST, BASE_PATH . "/upload/");
$error_msg = $doc->insert();
break;
case 'delete':
$error_msg = $doc->delete($params);
break;
default:
$error_msg = "Operazione non valida";
}
if ($error_msg != "") {
$result["errorMessage"] = $error_msg;
} elseif ($operation != 'edit') {
$result["statusMessage"] = "Operazione completata!";
}
}
$result["courses"] = $course->getList("nome");
$result['docs'] = $doc->getList();
$page = "document.php";
include_once BASE_PATH . "template.php";
}
/**
* method Delete()
* Delete a record
*/
function Delete($param)
{
try {
// get the parameter $key
$key = $param['key'];
// open a transaction with database 'changeman'
TTransaction::open('changeman');
// instantiates object Document
$object = new Document($key);
// deletes the object from the database
$object->delete();
// close the transaction
TTransaction::close();
// reload the listing
$this->onReload();
// shows the success message
new TMessage('info', TAdiantiCoreTranslator::translate('Record deleted'));
} catch (Exception $e) {
// shows the exception error message
new TMessage('error', '<b>Error</b> ' . $e->getMessage());
// undo all pending operations
TTransaction::rollback();
}
}
function deleteuser_document($user_id)
{
global $database;
//GETTING SCRIBD PARAMETERS
$query = "SELECT * FROM se_document_parameters";
$params = $database->database_fetch_assoc($database->database_query($query));
$scribd_api_key = $params['api_key'];
$scribd_secret = $params['secret_key'];
$scribd = new Document($scribd_api_key, $scribd_secret, $user_id);
//GET ALL DOCUMENTS OWNED BY USER
$result = $database->database_query("SELECT document_id, document_doc_id, document_filepath FROM se_documents WHERE document_user_id = '{$user_id}'");
if ($database->database_num_rows($result) > 0) {
while ($doc_info = $database->database_fetch_assoc($result)) {
$scribd->delete($doc_info['document_doc_id']);
$database->database_query("DELETE FROM se_documents_tags WHERE document_id = '{$doc_info['document_id']}'");
if ($doc_info['document_filepath'] != '') {
unlink('.' . $doc_info['document_filepath']);
}
}
}
// DELETE DOCUMENT ENTRIES AND COMMENTS
$database->database_query("DELETE FROM se_documents, se_documentcomments USING se_documents LEFT JOIN se_documentcomments ON se_documents.document_id=se_documentcomments.documentcomment_document_id WHERE se_documents.document_user_id='{$user_id}'");
// DELETE COMMENTS POSTED BY USER
$database->database_query("DELETE FROM se_documentcomments WHERE documentcomment_authoruser_id='{$user_id}'");
}
