/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $organization = Organization::find($id); $organization->delete(); Session::flash('successMessage', 'Your delete was successful.'); return Redirect::action('OrganizationsController@index'); }
/** * Signup a new account with the given parameters * * @param array $input Array containing 'username', 'email' and 'password'. * * @return User User object that may or may not be saved successfully. Check the id to make sure. */ public function signup($input) { // $name = array_get($input, 'organization'); $org = new Organization(); $lcode = $org->encode($name); $organization = Organization::find(array_get($input, 'organization_id')); $organization->licensed = 100; $organization->license_code = $lcode; $organization->update(); $user = new User(); $user->username = array_get($input, 'username'); $user->email = array_get($input, 'email'); $user->password = array_get($input, 'password'); $user->user_type = array_get($input, 'user_type'); $user->username = array_get($input, 'username'); $user->organization_id = '1'; // The password confirmation will be removed from model // before saving. This field will be used in Ardent's // auto validation. $user->password_confirmation = array_get($input, 'password_confirmation'); // Generate a random confirmation code $user->confirmation_code = md5(uniqid(mt_rand(), true)); // Save if valid. Password field will be hashed before save $this->save($user); return $user; }
public static function balanceSheet($date) { $accounts = Account::all(); $organization = Organization::find(1); $pdf = PDF::loadView('pdf.financials.balancesheet', compact('accounts', 'date', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Balance Sheet.pdf'); }
public function getOrgDocs($id) { $organization = Organization::find($id); $user = Organization::find($id)->user(); $documents = User::find($organization->user->id)->documents; return View::make('inspector.documents_view', ['organization' => $organization, 'user' => $user, 'documents' => $documents]); }
public function payments() { $payments = Payment::all(); $erporders = Erporder::all(); $erporderitems = Erporderitem::all(); $organization = Organization::find(1); $pdf = PDF::loadView('erpreports.paymentsReport', compact('payments', 'erporders', 'erporderitems', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Payment List.pdf'); }
public function edit($id) { $organization = Organization::find($id); if (!Auth::user()->hasPermissionTo('edit', $organization)) { Session::put('status', 'error'); Session::put('message', 'You do not have permission to edit this organization!'); return Redirect::to('organization/' . $organization->id); } elseif (Input::has('_token')) { return $this->save($organization, array_except(Input::all(), '_token')); } else { return View::make('organization.edit', array('organization' => $organization)); } }
/** * **/ public function postUpdate() { $organization = Organization::find(Input::get('id')); $organization->name = Input::get('name'); $file = Input::file('image'); if ($file != null) { $upload_success = Input::file('image')->move('public/uploads', $file->getClientOriginalName()); $organization->logo = $file->getClientOriginalName(); } $organization->address = Input::get('address'); $organization->webPage = Input::get('webPage'); $organization->save(); return Redirect::to('organization/edit')->with('message', 'Registro actualizado con exito'); }
public function addAction($f3) { $data = json_decode($f3->get('BODY')); //allows to use one loop for both array and object input if (!is_array($data)) { $data = array($data); } $organization = new Organization(); $is_error = false; $message = ""; $result = array(); foreach ($data as $item) { //create the data in local DB only if it is created in the API //attention - id's do not match $res = $this->checkDuplicateNamesLocal($item); if (max(array_count_values($res)) > 1) { $is_error = true; $message = "Your request data contains duplicate customer names"; continue; } //if first step pass - check if new items already exist in database //(could be optimized into one query using IN() operator, depending on real data purpose ) foreach ($res as $item2) { $organization->find(array('name = ?', $item2)); if ($organization->loaded()) { $is_error = true; $message = "Organization {$organization->name} already added to the database"; continue; } } if (!$this->createAPIOrganizationRecursive($item)) { $is_error = true; $message = "Error while adding organization tree to the pipedrive API"; continue; } $this->createOrganizationRecursive($item, $result); } if ($is_error) { $f3->set('content', $this->errorResponse($message)); } else { $f3->set('content', $this->successResponse($result)); } }
public function addNote() { $user_id = Input::get('user_id'); $org_id = Input::get('org_id'); $body = Input::get('body'); $flag = Input::get('flag'); $user = User::find($user_id); $org = Organization::find($org_id); if (!$user or !$org) { err('Something went wrong with your submission'); return Redirect::back(); } if (!me()->isOrgAdmin($org)) { err('You do not have permission to leave organizational notes for that organization'); return Redirect::back(); } $note = new OrganizationNote(); $note->organization_id = $org_id; $note->body = $body; $user->notes()->save($note); msg('Note left successfully'); return Redirect::back(); }
public function financials() { $report = Input::get('report_type'); $date = Input::get('date'); $accounts = Account::all(); $organization = Organization::find(1); if ($report == 'balancesheet') { $pdf = PDF::loadView('pdf.financials.balancesheet', compact('accounts', 'date', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Balance Sheet.pdf'); } if ($report == 'income') { $pdf = PDF::loadView('pdf.financials.incomestatement', compact('accounts', 'date', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Income Statement.pdf'); } if ($report == 'trialbalance') { $pdf = PDF::loadView('pdf.financials.trialbalance', compact('accounts', 'date', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Trial Balance.pdf'); } }
public function sendEmail() { if (!empty(Input::get('sel'))) { $period = Input::get('period'); $employees = Employee::all(); $emps = DB::table('employee')->count(); foreach ($employees as $user) { $transacts = DB::table('transact')->join('employee', 'transact.employee_id', '=', 'employee.personal_file_number')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->get(); $allws = DB::table('transact_allowances')->join('employee', 'transact_allowances.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->groupBy('allowance_name')->get(); $earnings = DB::table('transact_earnings')->join('employee', 'transact_earnings.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->groupBy('earning_name')->get(); $deds = DB::table('transact_deductions')->join('employee', 'transact_deductions.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->groupBy('deduction_name')->get(); $currencies = DB::table('currencies')->select('shortname')->get(); $organization = Organization::find(1); $fyear = ''; $fperiod = ''; $part = explode("-", $period); if ($part[0] == 1) { $fyear = 'January_' . $part[1]; } else { if ($part[0] == 2) { $fyear = 'Febraury_' . $part[1]; } else { if ($part[0] == 3) { $fyear = 'March_' . $part[1]; } else { if ($part[0] == 4) { $fyear = 'April_' . $part[1]; } else { if ($part[0] == 5) { $fyear = 'May_' . $part[1]; } else { if ($part[0] == 6) { $fyear = 'June_' . $part[1]; } else { if ($part[0] == 7) { $fyear = 'July_' . $part[1]; } else { if ($part[0] == 8) { $fyear = 'August_' . $part[1]; } else { if ($part[0] == 9) { $fyear = 'September_' . $part[1]; } else { if ($part[0] == 10) { $fyear = 'October_' . $part[1]; } else { if ($part[0] == 11) { $fyear = 'November_' . $part[1]; } else { if ($part[0] == 12) { $fyear = 'December_' . $part[1]; } } } } } } } } } } } } if ($part[0] == 1) { $fperiod = 'January-' . $part[1]; } else { if ($part[0] == 2) { $fperiod = 'Febraury-' . $part[1]; } else { if ($part[0] == 3) { $fperiod = 'March-' . $part[1]; } else { if ($part[0] == 4) { $fperiod = 'April-' . $part[1]; } else { if ($part[0] == 5) { $fperiod = 'May-' . $part[1]; } else { if ($part[0] == 6) { $fperiod = 'June-' . $part[1]; } else { if ($part[0] == 7) { $fperiod = 'July-' . $part[1]; } else { if ($part[0] == 8) { $fperiod = 'August-' . $part[1]; } else { if ($part[0] == 9) { $fperiod = 'September-' . $part[1]; } else { if ($part[0] == 10) { $fperiod = 'October-' . $part[1]; } else { if ($part[0] == 11) { $fperiod = 'November-' . $part[1]; } else { if ($part[0] == 12) { $fperiod = 'December-' . $part[1]; } } } } } } } } } } } } $fileName = $user->first_name . '_' . $user->last_name . '_' . $fyear . '.pdf'; $filePath = 'app/views/temp/'; $pdf = PDF::loadView('pdf.monthlySlip', compact('employee', 'transacts', 'allws', 'deds', 'earnings', 'period', 'currencies', 'organization'))->setPaper('a4')->setOrientation('potrait'); $pdf->save($filePath . $fileName); Mail::send('payslips.message', compact('fperiod', 'user'), function ($message) use($user, $filePath, $fileName) { $message->to($user->email_office, $user->first_name . ' ' . $user->last_name)->subject('Payslip'); $message->attach($filePath . $fileName); }); unlink($filePath . $fileName); } return Redirect::back()->with('success', 'Email Sent!'); } else { if (empty(Input::get('sel')) && !empty(Input::get('employeeid'))) { $period = Input::get('period'); $employees = Employee::all(); $emps = DB::table('employee')->count(); $id = Input::get('employeeid'); $employee = Employee::find($id); $transacts = DB::table('transact')->join('employee', 'transact.employee_id', '=', 'employee.personal_file_number')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->get(); $allws = DB::table('transact_allowances')->join('employee', 'transact_allowances.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('allowance_name')->get(); $earnings = DB::table('transact_earnings')->join('employee', 'transact_earnings.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('earning_name')->get(); $deds = DB::table('transact_deductions')->join('employee', 'transact_deductions.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('deduction_name')->get(); $currencies = DB::table('currencies')->select('shortname')->get(); $organization = Organization::find(1); $fyear = ''; $fperiod = ''; $part = explode("-", $period); if ($part[0] == 1) { $fyear = 'January_' . $part[1]; } else { if ($part[0] == 2) { $fyear = 'Febraury_' . $part[1]; } else { if ($part[0] == 3) { $fyear = 'March_' . $part[1]; } else { if ($part[0] == 4) { $fyear = 'April_' . $part[1]; } else { if ($part[0] == 5) { $fyear = 'May_' . $part[1]; } else { if ($part[0] == 6) { $fyear = 'June_' . $part[1]; } else { if ($part[0] == 7) { $fyear = 'July_' . $part[1]; } else { if ($part[0] == 8) { $fyear = 'August_' . $part[1]; } else { if ($part[0] == 9) { $fyear = 'September_' . $part[1]; } else { if ($part[0] == 10) { $fyear = 'October_' . $part[1]; } else { if ($part[0] == 11) { $fyear = 'November_' . $part[1]; } else { if ($part[0] == 12) { $fyear = 'December_' . $part[1]; } } } } } } } } } } } } if ($part[0] == 1) { $fperiod = 'January-' . $part[1]; } else { if ($part[0] == 2) { $fperiod = 'Febraury-' . $part[1]; } else { if ($part[0] == 3) { $fperiod = 'March-' . $part[1]; } else { if ($part[0] == 4) { $fperiod = 'April-' . $part[1]; } else { if ($part[0] == 5) { $fperiod = 'May-' . $part[1]; } else { if ($part[0] == 6) { $fperiod = 'June-' . $part[1]; } else { if ($part[0] == 7) { $fperiod = 'July-' . $part[1]; } else { if ($part[0] == 8) { $fperiod = 'August-' . $part[1]; } else { if ($part[0] == 9) { $fperiod = 'September-' . $part[1]; } else { if ($part[0] == 10) { $fperiod = 'October-' . $part[1]; } else { if ($part[0] == 11) { $fperiod = 'November-' . $part[1]; } else { if ($part[0] == 12) { $fperiod = 'December-' . $part[1]; } } } } } } } } } } } } $fileName = $employee->first_name . '_' . $employee->last_name . '_' . $fyear . '.pdf'; $filePath = 'app/views/temp/'; $pdf = PDF::loadView('pdf.monthlySlip', compact('employee', 'transacts', 'allws', 'deds', 'earnings', 'period', 'currencies', 'organization'))->setPaper('a4')->setOrientation('potrait'); $pdf->save($filePath . $fileName); $user = Employee::find($id); Mail::send('payslips.message', compact('fperiod', 'user'), function ($message) use($user, $filePath, $fileName) { $message->to($user->email_office, $user->first_name . ' ' . $user->last_name)->subject('Payslip'); $message->attach($filePath . $fileName); }); unlink($filePath . $fileName); } } return Redirect::back()->with('success', 'Email Sent!'); }
/** * Show the form for editing the specified organization. * * @param int $id * @return Response */ public function edit($id) { $organization = Organization::find($id); return View::make('organizations.edit', compact('organization')); }
public static function getUserOrganization() { $organization_id = Confide::user()->organization_id; $organization = Organization::find($organization_id); return $organization; }
break; case 'organizations': $object = Organization::all(); break; default: $object = ''; } return Response::json($object); })); Route::get('{object_name}/{id}/json', array('as' => 'json', function ($object_name, $id) { switch ($object_name) { case 'user': $object = User::find($id); break; case 'organization': $object = Organization::find($id); break; default: $object = ''; } return Response::json($object); })); Route::post('{object_name}/search/json', array('as' => 'search', function ($object_name) { if (!Input::has('query')) { return Response::json(array()); } $query = Input::get('query', ''); $query = '%' . str_replace(' ', '%', $query) . '%'; switch ($object_name) { case 'user': $results = User::where('email', 'LIKE', $query)->orWhere('first_name', 'LIKE', $query)->get()->toArray();
/** * Process the Meta table for campaign urls and create the * campaign from the corresponding URL */ protected function importCampaigns() { $metas = \Meta::all(['prop = ?' => 'campImport']); $users = []; $orgs = []; foreach ($metas as $m) { $user = Usr::find($users, $m->propid, ['_id', 'org_id', 'email', 'meta']); $org = \Organization::find($orgs, $user->org_id); $categories = \Category::all(['org_id' => $org->_id], ['_id', 'name']); $categories = array_values($categories); $category = $categories[array_rand($categories)]; // fetch ad info foreach URL $advert_id = $m->value['advert_id']; $comm = $m->value['campaign'] ?? $org->meta; if (!isset($comm['model']) || !isset($comm['rate'])) { continue; } $urls = $m->value['urls']; foreach ($urls as $url) { $ad = \Ad::first(['org_id' => $org->_id, 'url' => $url]); if ($ad) { continue; } // already crawled URL may be due to failed cron earlier $data = Utils::fetchCampaign($url); $image = Utils::downloadImage($data['image']); if (!$image) { $image = ''; } $ad = new \Ad(['user_id' => $advert_id, 'org_id' => $org->_id, 'title' => $data['title'], 'description' => $data['description'], 'url' => $url, 'image' => $image, 'category' => [$category->_id], 'type' => 'article', 'live' => false, 'device' => ['ALL']]); if ($ad->validate()) { $ad->save(); $rev = $comm['revenue'] ?? 1.25 * (double) $comm['rate']; $commission = new \Commission(['ad_id' => $ad->_id, 'model' => $comm['model'], 'rate' => $comm['rate'], 'revenue' => round($rev, 6), 'coverage' => ['ALL']]); $commission->save(); } else { var_dump($ad->getErrors()); } } $msg = 'Campaigns imported for the user: ' . $user->email; $this->log($msg); $m->delete(); } }
Route::get('roles/create', 'RolesController@create'); Route::get('roles/edit/{id}', 'RolesController@edit'); Route::post('roles/update/{id}', 'RolesController@update'); Route::get('roles/delete/{id}', 'RolesController@destroy'); }); Route::get('import', function () { return View::make('import'); }); Route::group(['before' => 'manage_system'], function () { Route::get('system', function () { $organization = Organization::find(1); return View::make('system.index', compact('organization')); }); }); Route::get('license', function () { $organization = Organization::find(1); return View::make('system.license', compact('organization')); }); /** * Organization routes */ Route::group(['before' => 'manage_organization'], function () { Route::resource('organizations', 'OrganizationsController'); Route::post('organizations/update/{id}', 'OrganizationsController@update'); Route::post('organizations/logo/{id}', 'OrganizationsController@logo'); }); Route::get('language/{lang}', array('as' => 'language.select', 'uses' => 'OrganizationsController@language')); Route::resource('clients', 'ClientsController'); Route::get('clients/edit/{id}', 'ClientsController@edit'); Route::post('clients/update/{id}', 'ClientsController@update'); Route::get('clients/delete/{id}', 'ClientsController@destroy');
public function offprint($id) { $loanaccount = Loanaccount::findOrFail($id); $organization = Organization::find(1); $principal_paid = Loanrepayment::getPrincipalPaid($loanaccount); $principal_due = $loanaccount->amount_disbursed - $principal_paid; $interest_due = $principal_due * ($loanaccount->interest_rate / 100); $pdf = PDF::loadView('pdf.offset', compact('loanaccount', 'organization', 'principal_paid', 'interest_due', 'principal_due'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Offset.pdf'); }
function index() { $this->layout('default'); $this->documents = Organization::find($_SESSION['organization_id'])->documents; }
public function quotation($id) { $orders = DB::table('erporders')->join('erporderitems', 'erporders.id', '=', 'erporderitems.erporder_id')->join('items', 'erporderitems.item_id', '=', 'items.id')->join('clients', 'erporders.client_id', '=', 'clients.id')->where('erporders.id', '=', $id)->select('clients.name as client', 'items.name as item', 'quantity', 'clients.address as address', 'clients.phone as phone', 'clients.email as email', 'date', 'erporders.id as id', 'discount_amount', 'erporders.order_number as order_number', 'price', 'description')->get(); $txorders = DB::table('tax_orders')->join('erporders', 'tax_orders.order_number', '=', 'erporders.order_number')->join('taxes', 'tax_orders.tax_id', '=', 'taxes.id')->where('erporders.id', '=', $id)->get(); $count = DB::table('tax_orders')->count(); $erporder = Erporder::findorfail($id); $organization = Organization::find(1); $pdf = PDF::loadView('erpreports.quotation', compact('orders', 'erporder', 'txorders', 'count', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('quotation.pdf'); }
public function individualleave() { $id = Input::get("employeeid"); $employee = Employee::find($id); $leavetypes = Leavetype::all(); $organization = Organization::find(1); $pdf = PDF::loadView('leavereports.individualReport', compact('leavetypes', 'employee', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream($employee->first_name . '_' . $employee->last_name . '_Leave_Report.pdf'); }
public static function getUserOrganization() { $organization_id = 1; $organization = Organization::find($organization_id); return $organization; }
public function postCalcDocs($id) { $user = User::find($id); $documents = User::find($id)->documents; $sum_org_movables_carrying_amount = 0; $sum_org_value_movables_carrying_amount = 0; $sum_org_buildings_carrying_amount = 0; $sum_org_parcels_carrying_amount = 0; $sum_org_movables_residual_value = 0; $sum_org_value_movables_residual_value = 0; $sum_org_buildings_residual_value = 0; $sum_org_cars_carrying_amount = 0; $sum_org_cars_residual_value = 0; foreach ($documents as $document) { $type = $document->os_type; $items = Document::find($document->id)->items; $sum_carrying_amount = 0; $sum_residual_value = 0; foreach ($items as $item) { if (isset($item->carrying_amount)) { $sum_carrying_amount = $sum_carrying_amount + $item->carrying_amount; } else { $sum_carrying_amount = $sum_carrying_amount; } if ($type != 'parcels') { $variable = Item::find($item->id)->variable; if (isset($variable->residual_value)) { $sum_residual_value = $sum_residual_value + $variable->residual_value; } $sum_residual_value = $sum_residual_value; } } $document->doc_carrying_amount = $sum_carrying_amount; if ($type != 'parcels') { $document->doc_residual_value = $sum_residual_value; } $document->save(); if ($type == 'movables') { $sum_org_movables_carrying_amount = $sum_org_movables_carrying_amount + $document->doc_carrying_amount; $sum_org_movables_residual_value = $sum_org_movables_residual_value + $document->doc_residual_value; } if ($type == 'value_movables') { $sum_org_value_movables_carrying_amount = $sum_org_value_movables_carrying_amount + $document->doc_carrying_amount; $sum_org_value_movables_residual_value = $sum_org_value_movables_residual_value + $document->doc_residual_value; } if ($type == 'cars') { $sum_org_cars_carrying_amount = $sum_org_cars_carrying_amount + $document->doc_carrying_amount; $sum_org_cars_residual_value = $sum_org_cars_residual_value + $document->doc_residual_value; } if ($type == 'buildings') { $sum_org_buildings_carrying_amount = $sum_org_buildings_carrying_amount + $document->doc_carrying_amount; $sum_org_buildings_residual_value = $sum_org_buildings_residual_value + $document->doc_residual_value; } if ($type == 'parcels') { $sum_org_parcels_carrying_amount = $sum_org_parcels_carrying_amount + $document->doc_carrying_amount; } } $organization_id = $user->organization_id; $organization = Organization::find($organization_id); $organization->org_movables_carrying_amount = $sum_org_movables_carrying_amount; $organization->org_value_movables_carrying_amount = $sum_org_value_movables_carrying_amount; $organization->org_cars_carrying_amount = $sum_org_cars_carrying_amount; $organization->org_buildings_carrying_amount = $sum_org_buildings_carrying_amount; $organization->org_parcels_carrying_amount = $sum_org_parcels_carrying_amount; $organization->org_movables_residual_value = $sum_org_movables_residual_value; $organization->org_value_movables_residual_value = $sum_org_value_movables_residual_value; $organization->org_buildings_residual_value = $sum_org_buildings_residual_value; $organization->org_cars_residual_value = $sum_org_cars_residual_value; $organization->org_carrying_amount = $organization->org_movables_carrying_amount + $organization->org_value_movables_carrying_amount + $organization->org_buildings_carrying_amount + $organization->org_parcels_carrying_amount; $organization->org_residual_value = $organization->org_movables_residual_value + $organization->org_value_movables_residual_value + $organization->org_buildings_residual_value; $organization->save(); return Redirect::action('AdminController@getOrgDocs', [$organization_id]); }
public function stock() { $items = Item::all(); $organization = Organization::find(1); $pdf = PDF::loadView('erpreports.stockReport', compact('items', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Stock Report.pdf'); }