public function indexAction()
{
$auth = $this->session->get('auth');
$id = $auth[uid];
$orders = Orders::find(array("conditions" => "u_id = :uid:", "bind" => array("uid" => $id), "order" => "o_id DESC"));
$this->view->orders = $orders;
}
public function indexAction()
{
$undeliveredorders = Orders::find(array("o_delivery = 0", "order" => "o_id"));
$this->view->undelivered = $undeliveredorders;
$deliveredorders = Orders::find(array("o_delivery = 1", "order" => "o_id"));
$this->view->delivered = $deliveredorders;
}
public function getSend($id)
{
date_default_timezone_set('Asia/Shanghai');
$date = date('Y-m-d H:i:s');
$order = Orders::find($id);
$order->status = 'sent';
$order->SendDate = $date;
$order->save();
return Redirect::to(URL::route('incomplete'));
}
public function indexAction()
{
$auth = $this->session->get('auth');
$this->view->name = $auth[name];
$date = date('Y-m-d');
echo $date;
$orders = Orders::find("o_delivery = 0");
$nosorders = count($orders);
$contact = Contact::find("co_status = 0");
$noscontact = count($contact);
$users = Userdetails::find();
$nosusers = count($users);
$result = Orders::sum(array('column' => 'o_price', "conditions" => "o_date = :date:", "bind" => array("date" => $date)));
/*$phql="SELECT SUM(o_price) AS costs FROM Orders where o_date='2015-12-11'";
$result = $this->modelsManager->executeQuery($phql);*/
$this->view->nosorders = $nosorders;
$this->view->noscontact = $noscontact;
$this->view->nosusers = $nosusers;
$this->view->nossale = $result;
}
/**
* Attach a hosting service to a domain name
*
*
* @param integer $orderID
* @param integer $domainID
*/
public static function addDomain($orderID, $domainID)
{
if (is_numeric($orderID) && is_numeric($domainID)) {
$order = Orders::find($orderID);
if (!empty($order)) {
foreach ($order->OrdersItems as $detail) {
// if ($detail->Products['type'] == "hosting") {
#if(FALSE === self::check_domains_in_order($orderID, $domainID)){
$domain = new OrdersItemsDomains();
$domain['domain_id'] = $domainID;
$domain['order_id'] = $orderID;
$domain['orderitem_id'] = $detail['detail_id'];
$domain->save();
#}
// }
}
return true;
}
}
return false;
}
public function postFaxOrders()
{
$pid = Session::get('pid');
if (Session::get('job_id') == FALSE) {
$job_id = '';
} else {
$job_id = Session::get('job_id');
}
$orders_id = Input::get('orders_id');
$html = $this->page_orders($orders_id)->render();
$filename = __DIR__ . "/../../public/temp/orders_" . time() . "_" . Session::get('user_id') . ".pdf";
$this->generate_pdf($html, $filename);
while (!file_exists($filename)) {
sleep(2);
}
$row1 = Orders::find($orders_id);
if ($row1->orders_labs != '') {
$file_original = "Laboratory Order";
}
if ($row1->orders_radiology != '') {
$file_original = "Imaging Order";
}
if ($row1->orders_cp != '') {
$file_original = "Cardiopulmonary Order";
}
if ($row1->orders_referrals != '') {
$file_original = "Referral Order";
}
$row2 = Addressbook::find($row1->address_id);
$result_message = $this->fax_document($pid, $file_original, 'yes', $filename, $file_original, $row2->fax, $row2->displayname, $job_id, 'yes');
Session::forget('job_id');
unlink($filename);
echo $result_message;
}
public function cancelOrder($id)
{
$response = array();
$output = array();
try {
/**
* TODO: include user id to ensure validation before cancelling the order.
*/
// Update the order in the database
$order = Orders::find($id);
$order->status = AppConstants::$avialable_status['cancelled'];
$order->save();
$response['response_code'] = ResponseCodes::$response_code['success']['code'];
$response['response_message'] = ResponseCodes::$response_code['success']['response_message'];
$response['output'] = $output;
echo json_encode($response);
} catch (Exception $e) {
Log::error($e->getMessage());
$response['response_code'] = ResponseCodes::$response_code['internal_server_error']['code'];
$response['response_message'] = ResponseCodes::$response_code['internal_server_error']['response_message'];
$response['output'] = $output;
echo json_encode($response);
}
}
/**
* Create a new Order
*
* @return boolean
*/
public function createOrder()
{
if (!$this->getOrderid()) {
$theOrder = Orders::create($this->getCustomerId(), Statuses::id('tobepaid', 'orders'), null);
// For each item in the cart
foreach ($this->getItems() as $item) {
$item = Orders::addOrderItem($item);
}
$this->setOrderid($theOrder['order_id']);
// Send the email to confirm the order
Orders::sendOrder($theOrder['order_id']);
return Orders::getOrder();
} else {
return Orders::find($this->getOrderid());
}
}
public function sendInvoice($uuid, $order_uuid = null, $service_uuid = null, $urlemail)
{
$this->authenticate();
$customers = Customers::findWithUuid($uuid);
if (empty($customers)) {
throw new Shineisp_Api_Exceptions(400007, ":: 'uuid' not valid");
exit;
}
$id = $customers['customer_id'];
if ($order_uuid == null && $service_uuid == null) {
throw new Shineisp_Api_Exceptions(400007, ":: 'order_uuid' not valid and 'service_uuid' not valid");
}
#TODO get order from $order_uuid
if ($service_uuid != null) {
$objService = OrdersItems::findByUUID($service_uuid);
if ($objService == false) {
return false;
}
$service = $objService->toArray();
$orderid = $service['order_id'];
$order = Orders::find($orderid);
$fastlink = Invoices::sendInvoice($order->invoice_id, $urlemail);
}
}
