* NOTICE OF LICENSE * * This source file is subject to the Academic Free License (AFL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/afl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to license@prestashop.com so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade PrestaShop to newer * versions in the future. If you wish to customize PrestaShop for your * needs please refer to http://www.prestashop.com for more information. * * @author PrestaShop SA <*****@*****.**> * @copyright 2007-2011 PrestaShop SA * @version Release: $Revision: 6594 $ * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA */ include dirname(__FILE__) . '/../../config/config.inc.php'; include dirname(__FILE__) . '/followup.php'; if (isset($_GET['secure_key'])) { $secureKey = Configuration::get('PS_FOLLOWUP_SECURE_KEY'); if (!empty($secureKey) and $secureKey === $_GET['secure_key']) { $followup = new Followup(); $followup->cronTask(); } }
/** * Remove the specified caloncustomer from storage. * * @param int $id * @return Response */ public function destroy($id) { CalonCustomer::destroy($id); Followup::where('calon_customer_id', '=', $id)->delete(); return Redirect::route('admin.calon_customer.index')->with('message', 'berhasil hapus calon customer'); }
public function ConductApplicatorFollowup($followupId, $data) { try { if (Followup::ConductApplicatorFollowup($followupId, $data)) { echo AppUtil::getReturnStatus("Successful", "Conduction Successful"); } else { echo AppUtil::getReturnStatus("Unsuccessful", "Database Error Occurred"); } } catch (Exception $e) { echo AppUtil::getReturnStatus("Unsuccessful", $e->getMessage()); } }
public function index() { $widget = ['baru' => Penjualan::where('status', 1)->whereBetween('tgl_order', [Carbon::now()->startOfMonth(), Carbon::today()])->count(), 'poBaru' => Penjualan::whereBetween('tgl_order', [Carbon::now()->startOfMonth(), Carbon::today()])->count(), 'rls' => Penjualan::where('status', '!=', 1)->whereBetween('tgl_order', [Carbon::now()->startOfMonth(), Carbon::today()])->count(), 'orders' => Order::where('status', 1)->count(), 'agen' => Customer::where('tipe', 2)->orWhere('tipe', 3)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year)->count(), 'mitra' => Customer::where('tipe', 1)->orWhere('tipe', 6)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year)->count(), 'biasa' => Customer::where('tipe', 4)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year)->count(), 'agenLastYear' => Customer::where('tipe', 2)->orWhere('tipe', 3)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year - 1)->count(), 'mitraLastYear' => Customer::where('tipe', 1)->orWhere('tipe', 6)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year - 1)->count(), 'biasaLastYear' => Customer::where('tipe', 4)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year - 1)->count()]; $box = ['penjualans' => Penjualan::orderBy('tgl_order', 'DESC')->take(7)->get(), 'barangs' => Barang::orderBy('id', 'DESC')->take(4)->get(), 'customers' => Penjualan::with('customer')->orderBy('tgl_order', 'DESC')->take(8)->get(), 'followups' => Followup::orderBy('created_at', 'desc')->take(6)->get(), 'bahan' => DB::table('bahan')->where('stok', 0)->take(5)->get(), 'menipis' => DB::table('bahan')->where('stok', 0)->count()]; // CHART ========================================================================================= $laporanTahunan = Penjualan::select(DB::raw('MONTH(tgl_transfer) as month, count(`id`) as count, sum(`nominal`) as nominal'))->where('status', '!=', 1)->where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year)->groupBy(DB::raw('YEAR(tgl_transfer)'))->groupBy(DB::raw('MONTH(tgl_transfer)'))->orderBy('tgl_transfer', 'asc')->get(); $total = ['thisMonth' => Penjualan::where('status', '!=', 1)->where('tgl_transfer', '>=', Carbon::now()->startOfMonth())->sum('nominal'), 'thisMonthLastYear' => Penjualan::where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year - 1)->where(DB::raw('MONTH(tgl_transfer)'), Carbon::now()->month)->where('status', '!=', 1)->sum('nominal'), 'lastYear' => Penjualan::where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year - 1)->where('status', '!=', 1)->sum('nominal'), 'thisYear' => Penjualan::where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year)->where('status', '!=', 1)->sum('nominal')]; // END OF CHART ========================================================================================= // dd($total['thisMonth']); return View::make('admin', compact('box', 'widget', 'total', 'laporanTahunan')); }
public static function saveProject($data, $userId) { $projnum = AppUtil::generateId(); $projectBasicDetails = $data->projectDetails; $t = time(); $current = date("Y-m-d", $t); $object = array(); $rollBack = true; $db = Database::getInstance(); $conn = $db->getConnection(); $conn->beginTransaction(); $stmt = $conn->prepare("SELECT `ProjectName` FROM `project_master` WHERE `ProjectName`= :projectName"); $stmt->bindParam(':projectName', $projectBasicDetails->ProjectName, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); if (count($result) > 0) { return 2; } $stmt = $conn->prepare("INSERT INTO project_master (ProjectId, ProjectName, ProjectManagerId, ProjectSource, IsSiteTrackingProject, ProjectStatus, CustomerId, IsClosedProject, isDeleted, CreationDate, CreatedBy, LastModificationDate, LastModifiedBy)\n\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"); if ($stmt->execute([$projnum, $projectBasicDetails->ProjectName, $projectBasicDetails->ProjectManagerId, $projectBasicDetails->ProjectSource, '0', 'Initiated', $projectBasicDetails->CustomerId, '0', '0', $current, $userId, $current, $userId]) === TRUE) { $stmt2 = $conn->prepare("INSERT INTO project_address_details (ProjectId, Address, City, State, Country, Pincode) VALUES (?,?,?,?,?,?)"); if ($stmt2->execute([$projnum, $projectBasicDetails->Address, $projectBasicDetails->City, $projectBasicDetails->State, $projectBasicDetails->Country, $projectBasicDetails->Pincode]) === TRUE) { $stmt3 = $conn->prepare("INSERT INTO project_point_of_contact_details (ProjectId, PointContactName, MobileNo, LandlineNo, EmailId) VALUES (?,?,?,?,?)"); if ($stmt3->execute([$projnum, $projectBasicDetails->PointContactName, $projectBasicDetails->MobileNo, $projectBasicDetails->LandlineNo, $projectBasicDetails->EmailId]) === TRUE) { $break = false; foreach ($data->companiesInvolved as $company) { $stmt4 = $conn->prepare("INSERT INTO companies_involved_in_project (ProjectID, CompanyID) VALUES (?,?)"); if (!$stmt4->execute([$projnum, $company->companyId])) { throw new Exception($stmt4->errorInfo); $break = true; break; } } if (!$break) { $conn->commit(); $rollBack = false; if (isset($data->followupData)) { if (Followup::CreateSiteTrackingFollowup($projnum, $data->followupData, $userId)) { // echo AppUtil::getReturnStatus("Successful", "Conduction Successful"); } else { // echo AppUtil::getReturnStatus("Unsuccessful", "Database Error Occurred"); } } } } else { throw new Exception($stmt3->errorInfo); } } else { throw new Exception($stmt2->errorInfo); } } else { throw new Exception($stmt->errorInfo); } if ($rollBack) { $conn->rollBack(); return 0; } $conn = null; return 1; }
/** * Remove the specified followup from storage. * * @param int $id * @return Response */ public function destroy($id) { Followup::destroy($id); return Redirect::route('admin.followup.index'); }