public function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$alertId = null;
$alertCode = "WM";
$alertFrequency = "D2";
$alertOperator = "L";
$alertPoint = 100.514;
$this->alertLevel = new AlertLevel($alertId, $alertCode, $alertFrequency, $alertPoint, $alertOperator);
$this->alertLevel->insert($this->getPDO());
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$locationId = null;
$description = "Back Stock";
$storageCode = 7;
$this->location = new Location($locationId, $storageCode, $description);
$this->location->insert($this->getPDO());
$unitId = null;
$unitCode = "pk";
$quantity = 10.5;
$this->unitOfMeasure = new UnitOfMeasure($unitId, $unitCode, $quantity);
$this->unitOfMeasure->insert($this->getPDO());
}
/**
* Set up to create vendor, product, unitOfMeasure objects
*
**/
public function setUp()
{
parent::setUp();
$this->guzzle = new \GuzzleHttp\Client(['cookies' => true]);
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$unitId = null;
$quantity = 3.5;
$unitCode = "ea";
$this->unitOfMeasure = new UnitOfMeasure($unitId, $unitCode, $quantity);
$this->unitOfMeasure->insert($this->getPDO());
}
public static function destroy($id)
{
self::check_logged_in();
$vendor = new Vendor(array('id' => $id));
$vendor->destroy();
Redirect::to('/vendors', array('message' => 'The vendor has been removed successfully!'));
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$name = "TruFork";
$contactName = "Trevor Rigler";
$email = "*****@*****.**";
$phoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $name, $contactName, $email, $phoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bracelet for any occasion to use";
$leadTime = 15;
$sku = "457847";
$title = "Bracelet-Green-Blue";
$this->finishedProduct = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->finishedProduct->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "354";
$title = "Bead-Green-Blue-Circular";
$this->rawMaterial = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->rawMaterial->insert($this->getPDO());
}
public function actionAdmin()
{
$model = new Vendor('search');
$model->unsetAttributes();
if (isset($_GET['Vendor'])) {
$model->setAttributes($_GET['Vendor']);
}
$this->render('admin', array('model' => $model));
}
function save()
{
if ($this->valid()) {
$attendee = new Vendor($this->params);
return $attendee->create_with_id();
} else {
return false;
}
}
public function createVendor()
{
if (isset($_POST['name']) && isset($_POST['username']) && isset($_POST['email']) && isset($_POST['password'])) {
$vendor = new Vendor();
$vendor->name = $_POST['name'];
$vendor->username = $_POST['username'];
$vendor->email = $_POST['email'];
$vendor->password = Hash::make($_POST['password']);
$vendor->save();
return Redirect::to('/')->with('error', 'Vendor Created!');
} else {
return Redirect::to('/')->with('error', 'Missing Information');
}
}
function save()
{
$id = $this->input->post("id");
if ($id == 0) {
$vendorObject = new Vendor();
} else {
$vendorObject = new Vendor($id);
}
$vendorObject->name = $vendorObject->input->post("name", TRUE);
$vendorObject->address = $vendorObject->input->post("address", TRUE);
$vendorObject->number = $vendorObject->input->post("number", TRUE);
$vendorObject->email = $vendorObject->input->post("email", TRUE);
$vendorObject->save();
echo $vendorObject->id;
}
public function action_emails()
{
$view = View::make('admin.emails');
$view->vendor_emails = Vendor::join('users', 'user_id', '=', 'users.id')->where_null('banned_at')->where('send_emails', '=', true)->lists('email');
$view->officer_emails = Officer::join('users', 'user_id', '=', 'users.id')->where_null('banned_at')->where('send_emails', '=', true)->lists('email');
$this->layout->content = $view;
}
public function importData(Vendor $vendor)
{
$vendorConfig = $vendor->getConfig();
while (!$vendor->endReached()) {
$vendorItemData = $vendor->getNextLine();
if (isset($vendorItemData['item']) && $vendorItemData['item'] != "") {
$itemIds = $this->baseData->getItemIds($vendorItemData['item'], $vendor->getBaseDataColumn());
if (!empty($itemIds)) {
foreach ($itemIds as $itemId) {
$query = "INSERT INTO " . $this->config['master-table'] . " (" . "item_id," . $vendorConfig['master-file-item-column-name'] . "," . $vendorConfig['master-file-price-column-name'] . "," . $vendorConfig['master-file-qty-column-name'] . ") VALUES (" . "'" . $itemId . "'," . "'" . $vendorItemData['item'] . "'," . $vendorItemData['price'] . "," . $vendorItemData['qty'] . ") ON DUPLICATE KEY UPDATE " . $vendorConfig['master-file-item-column-name'] . "='" . $vendorItemData['item'] . "'," . $vendorConfig['master-file-price-column-name'] . "= IF (" . $vendorConfig['master-file-price-column-name'] . "<" . $vendorItemData['price'] . "," . $vendorItemData['price'] . "," . $vendorConfig['master-file-price-column-name'] . ")," . $vendorConfig['master-file-qty-column-name'] . "=" . $vendorConfig['master-file-qty-column-name'] . "+" . $vendorItemData['qty'];
db_query($query);
}
}
}
}
}
/**
* Store a newly created resource in storage.
* POST /balancesheets
*
* @return Response
*/
public function store()
{
$balancesheet = new balancesheet();
/* $balancesheet->name = Input::get('name');
$balancesheet->save();
$balancesheet->vendor_type = Input::get('vendortype');
$balancesheet->save();*/
$vendor = Vendor::find(Input::get('vendor'));
$balancesheet->vendor_id = $vendor->id;
$balancesheet->save();
$balancesheet->total_amount = Input::get('Tamount');
$balancesheet->save();
$balancesheet->payable_amount = Input::get('Pamount');
$balancesheet->save();
$balancesheet->receivable_amount = Input::get('Ramount');
$balancesheet->save();
// $balancesheet->vendor_id = Input::get('vendor');
// $balancesheet->save();
if (Input::get('note') == '') {
$balancesheet->note = 'N/A';
} else {
$balancesheet->note = Input::get('note');
}
$balancesheet->save();
$balancesheet->balancesheet_id = "B0" . $balancesheet->id;
$balancesheet->save();
return Redirect::route('balancesheet.index');
}
public function store()
{
try {
$createOrder = Input::json()->all();
$addOrder = new Order();
$addOrder->status = 1;
$addOrder->save();
$addOrderId = $addOrder->id;
$numberOfItems = 0;
foreach ($createOrder['items'] as $OrderItem) {
$newOrderItem = new Order_Item();
$newOrderItem->order_id = $addOrderId;
$newOrderItem->item_id = $OrderItem['item_id'];
$newOrderItem->order_qty = $OrderItem['order_qty'];
$newOrderItem->save();
$numberOfItems = $numberOfItems + 1;
}
$addOrder->items = $createOrder['items'];
$addOrder->open = 'yes';
$vendorId = $createOrder['vendor_id'];
$addOrder->vendor_id = $vendorId;
$vendorName = Vendor::find($vendorId);
$addOrder->vendor_name = $vendorName->name;
$addOrder->item_count = $numberOfItems;
$this->addOrderToEmail($addOrder);
return $addOrder->toJson();
} catch (Exception $e) {
return '{"error":{"text":' . $e->getMessage() . '}}';
}
}
/**
* Show a list of all of the application's users.
*
* @return Response
*/
public function index()
{
$vendor = DB::table('vendors')->get();
$lap_jenis = tipe_lap::lists('tipe', 'id');
$vendor_name = Vendor::lists('nama', 'id');
return view('admin.views', ['vendor' => $vendor], compact('lap_jenis', 'vendor_name'));
}
public function hookCustomerAccount($params)
{
require_once dirname(__FILE__) . "/../ordervendor/Vendor.php";
if (Vendor::currentVendor() != null) {
return $this->display(__FILE__, 'menuitems.tpl');
}
}
public function delete()
{
$ids = explode(',', Input::get('javascriptArrayString'));
Vendor::destroy($ids);
$data['status'] = 'success';
$data['message'] = count($ids) . ' Row(s) was deleted successfully';
return Response::json($data);
}
public function forMode($mode_id)
{
$mode = Mode::FromId($mode_id);
$vendor = Vendor::FromId($mode->vendor_id());
$url = $vendor->csetURL();
if (strpos($url, "hg.mozilla.org") !== false) {
return new HGWeb($url);
}
throw new Exception("Not implemented version control system.");
}
public function action_index()
{
$view = View::make('vendors.index');
$page = intval(Input::get('page') ?: 1);
$view->vendors = Vendor::join('users', 'user_id', '=', 'users.id')->where_null('users.banned_at')->raw_where("EXISTS (SELECT service_id from service_vendor WHERE `vendor_id` = `vendors`.`id`)")->where(function ($q) {
$q->where(DB::raw("RIGHT(image_url, 4)"), '=', 'jpeg');
$q->or_where_in(DB::raw("RIGHT(image_url, 3)"), array('jpg', 'gif', 'png'));
})->select(array('*', 'vendors.id as vendor_id'))->skip(($page - 1) * 10)->take(10)->order_by('vendors.created_at', 'desc')->get();
$this->layout->content = $view;
}
public function update($id)
{
$vendor = Vendor::find($id);
$data = Input::all();
$vendor->update($data);
if (!$vendor) {
return Redirect::to('admin.vendor.show')->with('message', 'gagal update vendor (ngga tau kenapa, panggil tegar)');
}
return Redirect::back()->with('message', 'berhasil update vendor (mungkin)');
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
}
/**
* load initail data for employee form needed during
* creating and editing employee
* data
*/
public function getData()
{
global $database;
$depts = Department::find_all();
$area = Area::find_all();
$country = Country::find_all();
$vendors = Vendor::find_all();
$zone = Zone::find_by_sql("SELECT * FROM zone");
$startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "area" => $area);
return $startups;
}
public function vendors()
{
// Eloquent
$vendor_objs = Vendor::active();
$vendors = array();
foreach ($vendor_objs as $key => $vendor) {
//debug($vendor['name']);
$vendors[] = array('id' => $vendor['id'], 'name' => ucfirst(strtolower($vendor['name'])));
}
return Response::json($vendors);
}
public function getData()
{
global $database;
$depts = Department::find_all();
$role = Roles::find_all();
$country = Country::find_all();
$vendors = Vendor::find_all();
$zone = Zone::find_by_sql("SELECT * FROM zone");
$techEmp = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept='5'");
$startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "techemp" => $techEmp);
return $startups;
}
public function update($id)
{
try {
$updateModel = Input::json()->all();
$updateVendor = Vendor::find($id);
$updateVendor->name = $updateModel['name'];
$updateVendor->url = $updateModel['url'];
$updateVendor->save();
} catch (Exception $e) {
return json_encode('{"error":{"text":' . $e->getMessage() . '}}');
}
}
public function importData(Vendor $vendor)
{
$this->currentVendor = $vendor;
$baseActiveSheet = $vendor->getActiveSheet();
while (!$vendor->endReached()) {
$vendorItemData = $vendor->getNextLine();
if (isset($vendorItemData['item']) && $vendorItemData['item'] != "") {
$itemIds = $this->baseData->getItemIds($vendorItemData['item'], $vendor->getBaseDataColumn());
if (!empty($itemIds)) {
foreach ($itemIds as $itemId) {
$itemData = $this->findItem($itemId);
if (!isset($itemData['row'])) {
$itemData['row'] = $this->counter;
$this->counter++;
} else {
$vendorItemData['price'] = $vendorItemData['price'] > $itemData['price'] ? $vendorItemData['price'] : $itemData['price'];
$vendorItemData['qty'] += $itemData['qty'];
}
$this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue('A' . $itemData['row'], $itemId);
$vendorConfig = $vendor->getConfig();
$this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue($vendorConfig['master-file-item-column'] . $itemData['row'], $vendorItemData['item']);
$this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue($vendorConfig['master-file-price-column'] . $itemData['row'], $vendorItemData['price']);
$this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue($vendorConfig['master-file-qty-column'] . $itemData['row'], $vendorItemData['qty']);
}
}
}
}
}
/**
* System Constructor.
* Initializing the system, check the config file
*
* @author Puguh Wijayanto (www.metalgenix.com)
* @since 0.0.1
*/
public function __construct()
{
self::config('config');
new Db();
new Hooks();
self::lang(Options::get('system_lang'));
new Site();
Vendor::autoload();
Token::create();
Mod::loader();
Theme::loader();
Hooks::run('init');
}
public function getData()
{
global $database;
$depts = Department::find_all();
$role = Roles::find_all();
$country = Country::find_all();
$vendors = Vendor::find_all();
$countAcc = count(Cproduct::find_by_client($_SESSION["client_ident"]));
$schedule = Cproduct::getNextSchedule($_SESSION["client_ident"]);
$countTic = count(Ticket::find_by_client($_SESSION['client_ident']));
$zone = Zone::find_by_sql("SELECT * FROM zone");
$startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "countProd" => $countAcc, "countTick" => $countTic, "Schel" => $schedule);
return $startups;
}
public static function update($id)
{
self::check_logged_in();
$params = $_POST;
$attributes = array('id' => $id, 'vendor_id' => $params['vendor_id'], 'partnumber' => $params['partnumber'], 'datasheeturl' => $params['datasheeturl']);
$vendoritem = new VendorItem($attributes);
$errors = $vendoritem->errors();
if (count($errors) > 0) {
$vendoritem = VendorItem::find($id);
$vendors = Vendor::all();
View::make('vendoritem/edit.html', array('errors' => $errors, 'attributes' => $attributes, 'vendoritem' => $vendoritem, 'vendors' => $vendors));
} else {
$vendoritem->update();
Redirect::to('/vendoritem/' . $vendoritem->id, array('message' => 'The vendor item has been modified successfully!'));
}
}
public function getData()
{
global $database;
$depts = Department::find_all();
$role = Roles::find_all();
$country = Country::find_all();
$vendors = Vendor::find_all();
$countAcc = count(Cproduct::find_by_client($_SESSION["client_ident"]));
$schedule = Cproduct::getNextSchedule($_SESSION["client_ident"]);
$OnSchedule = Schedule::find_by_sql("SELECT * FROM schedule WHERE client_id='" . $_SESSION['client_ident'] . "' AND maint_type !='Activation' AND (status='Open' OR status='In Progress') ORDER BY id DESC LIMIT 10");
$OnScheduleAct = Schedule::find_by_sql("SELECT * FROM schedule WHERE client_id='" . $_SESSION['client_ident'] . "' AND maint_type='Activation' AND (status='Open' OR status='In Progress') ORDER BY id DESC LIMIT 10");
$countTicketOpen = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND status ='Open'"));
$countTicketClose = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND status ='Closed'"));
$countTicketPending = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND (status ='Admin Reply' OR status='Customer Reply')"));
$countTic = count(Ticket::find_by_client($_SESSION['client_ident']));
$countuser = count(Clientuser::find_by_client($_SESSION['client_ident']));
$zone = Zone::find_by_sql("SELECT * FROM zone");
$startups = array("cschedule" => $OnSchedule, "departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "countProd" => $countAcc, "countTick" => $countTic, "Schel" => $schedule, "SchelAct" => $OnScheduleAct, "CountPending" => $countTicketPending, "CountOpent" => $countTicketOpen, "CountClosed" => $countTicketClose, "CountUsers" => $countuser);
return $startups;
}
<?php
}
?>
<form id="form1" action="../controller/ItemController.php?opcion=saveInventory" method="post" >
<br/>
<table border="1" cellspacing="0" width="700" align="center" class="ui-corner-all">
<tr class="ui-widget-header">
<th> </th>
<th style="max-width: 200px">Item</th>
<th>Preferred Vendor</th>
</tr>
<?php
include_once "../model/Item.php";
include_once "../model/Vendor.php";
$itemObj = new Item();
$vendorObj = new Vendor();
$classes = $itemObj->getClasses();
$items = $itemObj->getItemsSetPreferredVendor();
$vendors = $vendorObj->getPreferredVendors();
$i = 0;
foreach ($items as $item) {
?>
<tr id="row<?php
echo $i;
?>
">
<td align="center">
<span><?php
echo $i + 1;
?>
</span>
