public function search($input)
{
$query = Shipment::query();
$columns = Schema::getColumnListing('shipments');
$attributes = array();
foreach ($columns as $attribute) {
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
} else {
$attributes[$attribute] = null;
}
}
return [$query->get(), $attributes];
}
public static function boot()
{
parent::boot();
Shipment::observe(new ShipmentObserver());
}
/**
* Display store customer order
*
* @return Response
*/
public function store()
{
if (!Input::has('order')) {
return new JSend('error', (array) Input::all(), 'Tidak ada data order.');
}
$errors = new MessageBag();
$order = Input::get('order');
DB::beginTransaction();
$user_id = Request::route()[2]['user_id'];
$order = Input::get('order');
if (is_null($order['id'])) {
$is_new = true;
} else {
$is_new = false;
}
if (isset($order['voucher_code'])) {
//a. check if voucher code is voucher
$voucher = \App\Models\Voucher::code($order['voucher_code'])->type(['free_shipping_cost', 'debit_point'])->first();
if (!$voucher) {
//b. check if voucher is referral
$voucher_data = \App\Models\Referral::code($order['voucher_code'])->first();
if (!$voucher_data) {
$voucher_data = \App\Models\Voucher::code($order['voucher_code'])->type('promo_referral')->ondate('now')->first();
}
if (!$voucher_data) {
return new JSend('error', (array) Input::all(), ['Voucher tidak valid.']);
} elseif ($voucher_data->quota <= 0) {
$errors->add('Redeem', 'Quota referral sudah habis.');
} else {
$store = \App\Models\StoreSetting::type('voucher_point_expired')->Ondate('now')->first();
if ($store) {
$expired_at = new Carbon($store->value);
} else {
$expired_at = new Carbon('+ 3 months');
}
//if validator passed, save voucher
if ($voucher_data['type'] == 'referral') {
$reference_id = $voucher_data['user_id'];
$reference_type = 'App\\Models\\User';
} else {
$reference_id = $voucher_data['id'];
$reference_type = 'App\\Models\\Voucher';
}
$point = ['user_id' => $user_id, 'reference_id' => $reference_id, 'reference_type' => $reference_type, 'expired_at' => $expired_at->format('Y-m-d H:i:s')];
$point_data = new \App\Models\PointLog();
$point_data->fill($point);
if (!$point_data->save()) {
$errors->add('Redeem', $point_data->getError());
}
}
} else {
$order['voucher_id'] = $voucher['id'];
}
}
if (isset($order['voucher_id']) && $order['voucher_id'] == 0) {
$order['voucher_id'] = '';
}
$order_rules = ['voucher_id' => 'exists:tmp_vouchers,id'];
//1a. Get original data
$order_data = \App\Models\Sale::findornew($order['id']);
//1b. Validate Basic Order Parameter
$validator = Validator::make($order, $order_rules);
if (!$validator->passes() && !$errors->count()) {
$errors->add('Sale', $validator->errors());
} elseif (!$errors->count()) {
//if validator passed, save order
$order_data = $order_data->fill(['user_id' => $user_id, 'voucher_id' => isset($order['voucher_id']) ? $order['voucher_id'] : '0']);
if (!$order_data->save()) {
$errors->add('Sale', $order_data->getError());
}
}
//2. Validate Order Detail Parameter
if (!$errors->count() && isset($order['transactiondetails']) && is_array($order['transactiondetails'])) {
$detail_current_ids = [];
foreach ($order['transactiondetails'] as $key => $value) {
if (!$errors->count() && isset($value['quantity']) && $value['quantity'] > 0) {
$detail_data = \App\Models\TransactionDetail::findornew($value['id']);
$detail_rules = ['transaction_id' => 'exists:transactions,id|' . ($is_new ? '' : 'in:' . $order_data['id']), 'varian_id' => 'required|exists:varians,id', 'quantity' => 'required|numeric', 'price' => 'required|numeric', 'discount' => 'numeric'];
$validator = Validator::make($value, $detail_rules);
//if there was detail and validator false
if (!$validator->passes()) {
$errors->add('Detail', $validator->errors());
} else {
$check_prev_trans = \App\Models\TransactionDetail::transactionid($order_data['id'])->varianid($value['varian_id'])->first();
if ($check_prev_trans) {
$detail_data = $check_prev_trans;
}
$value['transaction_id'] = $order_data['id'];
$detail_data = $detail_data->fill($value);
if (!$detail_data->save()) {
$errors->add('Detail', $detail_data->getError());
} else {
$detail_current_ids[] = $detail_data['id'];
}
}
}
}
//if there was no error, check if there were things need to be delete
if (!$errors->count()) {
$details = \App\Models\TransactionDetail::transactionid($order['id'])->get(['id'])->toArray();
$detail_should_be_ids = [];
foreach ($details as $key => $value) {
$detail_should_be_ids[] = $value['id'];
}
$difference_detail_ids = array_diff($detail_should_be_ids, $detail_current_ids);
if ($difference_detail_ids) {
foreach ($difference_detail_ids as $key => $value) {
$detail_data = \App\Models\TransactionDetail::find($value);
if (!$detail_data->delete()) {
$errors->add('Detail', $detail_data->getError());
}
}
}
}
}
//3. Validate Order Detail Parameter
if (!$errors->count() && isset($order['transactionextensions']) && is_array($order['transactionextensions'])) {
$extend_current_ids = [];
foreach ($order['transactionextensions'] as $key => $value) {
if (!$errors->count()) {
$extend_data = \App\Models\TransactionExtension::findornew($value['id']);
$extend_rules = ['transaction_id' => 'exists:transactions,id|' . ($is_new ? '' : 'in:' . $order_data['id']), 'product_extension_id' => 'required|exists:product_extensions,id', 'price' => 'required|numeric'];
$validator = Validator::make($value, $extend_rules);
//if there was extend and validator false
if (!$validator->passes()) {
$errors->add('Extend', $validator->errors());
} else {
$check_prev_trans = \App\Models\TransactionExtension::transactionid($order_data['id'])->productextensionid($value['product_extension_id'])->first();
if ($check_prev_trans) {
$extend_data = $check_prev_trans;
}
$value['transaction_id'] = $order_data['id'];
$extend_data = $extend_data->fill($value);
if (!$extend_data->save()) {
$errors->add('Extend', $extend_data->getError());
} else {
$extend_current_ids[] = $extend_data['id'];
}
}
}
}
//if there was no error, check if there were things need to be delete
if (!$errors->count()) {
$extends = \App\Models\TransactionExtension::transactionid($order['id'])->get(['id'])->toArray();
$extend_should_be_ids = [];
foreach ($extends as $key => $value) {
$extend_should_be_ids[] = $value['id'];
}
$difference_extend_ids = array_diff($extend_should_be_ids, $extend_current_ids);
if ($difference_extend_ids) {
foreach ($difference_extend_ids as $key => $value) {
$extend_data = \App\Models\TransactionExtension::find($value);
if (!$extend_data->delete()) {
$errors->add('Extend', $extend_data->getError());
}
}
}
}
}
//4. Check if need to save address
if (!$errors->count() && isset($order['shipment']['address'])) {
$address_data = \App\Models\Address::findornew($order['shipment']['address']['id']);
$address_rules = ['owner_id' => 'exists:users,id|' . ($is_new ? '' : 'in:' . $user_id), 'owner_type' => $is_new ? '' : 'in:App\\Models\\Customer', 'phone' => 'required|max:255', 'address' => 'required', 'zipcode' => 'required|max:255'];
$validator = Validator::make($order['shipment']['address'], $address_rules);
//4a. save address
//if there was address and validator false
if (!$validator->passes()) {
$errors->add('Sale', $validator->errors());
} else {
//if validator passed, save address
$order['shipment']['address']['owner_id'] = $user_id;
$order['shipment']['address']['owner_type'] = 'App\\Models\\Customer';
$address_data = $address_data->fill($order['shipment']['address']);
if (!$address_data->save()) {
$errors->add('Sale', $address_data->getError());
}
}
}
//4b. save shipment
if (!$errors->count() && isset($order['shipment'])) {
if ($order_data->shipment()->count()) {
$shipment_data = \App\Models\Shipment::findorfail($order_data->shipment->id);
} else {
$shipment_data = \App\Models\Shipment::findornew($order['shipment']['id']);
}
$shipment_rules = ['courier_id' => 'required|exists:couriers,id', 'receiver_name' => 'required|max:255'];
$validator = Validator::make($order['shipment'], $shipment_rules);
//4c. save shipment
//if there was shipment and validator false
if (!$validator->passes()) {
$errors->add('Sale', $validator->errors());
} else {
//if validator passed, save shipment
$order['shipment']['transaction_id'] = $order['id'];
if (isset($address_data['id'])) {
$order['shipment']['address_id'] = $address_data['id'];
}
$shipment_data = $shipment_data->fill($order['shipment']);
if (!$shipment_data->save()) {
$errors->add('Sale', $shipment_data->getError());
}
}
}
//5. update status
if (!$errors->count() && isset($order['status']) && $order_data['status'] != $order['status']) {
//3a. check cart price and product current price
if ($order['status'] == 'wait') {
foreach ($order_data['transactiondetails'] as $key => $value) {
$discount = $value['varian']['product']['promo_price'] == 0 ? 0 : $value['varian']['product']['price'] - $value['varian']['product']['promo_price'];
if ($value['price'] != $value['varian']['product']['price'] || $value['discount'] != $discount) {
$errors->add('Price', 'Harga item ' . $value['varian']['product']['name'] . ' telah berubah sejak ' . $value['varian']['product']['price_start'] . '. Silahkan update keranjang Anda.');
}
}
foreach ($order_data['transactionextensions'] as $key => $value) {
if ($value['price'] != $value['productextension']['price']) {
$errors->add('Price', 'Biaya ' . $value['productextension']['name'] . ' telah berubah sejak ' . $value['productextension']['updated_at'] . '. Silahkan update keranjang Anda.');
}
if (!$value['productextension']['is_active']) {
$errors->add('Active', $value['productextension']['name'] . ' telah di non aktif kan sejak ' . $value['productextension']['updated_at'] . '. Silahkan update keranjang Anda.');
}
}
}
if (!$errors->count()) {
$log_data = new \App\Models\TransactionLog();
$log_data = $log_data->fill(['status' => $order['status'], 'transaction_id' => $order_data['id']]);
if (!$log_data->save()) {
$errors->add('Log', $log_data->getError());
}
}
}
if ($errors->count()) {
DB::rollback();
return new JSend('error', (array) Input::all(), $errors);
}
DB::commit();
$final_order = \App\Models\Sale::userid($user_id)->id($order_data['id'])->status(['cart', 'wait', 'payment_process', 'canceled', 'paid', 'shipping', 'packed', 'delivered'])->with(['payment', 'orderlogs', 'transactiondetails', 'transactiondetails.varian', 'transactiondetails.varian.product', 'shipment', 'shipment.courier', 'shipment.address', 'voucher', 'user', 'transactionextensions', 'transactionextensions.productextension'])->first()->toArray();
return new JSend('success', (array) $final_order);
}
/**
* Store a sale
*
* 1. Save Sale
* 2. Save Payment or shipment
* 3. Save Transaction Log
*
* @return Response
*/
public function status()
{
if (!Input::has('sale')) {
return new JSend('error', (array) Input::all(), 'Tidak ada data sale.');
}
$errors = new MessageBag();
DB::beginTransaction();
//1. Validate Sale Parameter
$sale = Input::get('sale');
if (is_null($sale['id'])) {
return new JSend('error', (array) Input::all(), 'Tidak ada data sale.');
} else {
$is_new = false;
}
//1a. Get original data
$sale_data = \App\Models\Sale::findorfail($sale['id']);
//1b. Check if there were statuses differences
if ($sale_data['status'] == $sale['status']) {
$errors->add('Sale', 'Tidak ada perubahan status.');
}
//2. Check if status = paid
if (!$errors->count() && in_array($sale['status'], ['paid'])) {
if (!isset($sale['payment']) || is_null($sale['payment'])) {
$errors->add('Sale', 'Tidak ada data pembayaran.');
} else {
$paid_data = \App\Models\Payment::findornew($sale['payment']['id']);
$payment_rule = ['transaction_id' => 'exists:transactions,id|' . (!$paid_data ? '' : 'in:' . $sale_data['id']), 'method' => 'required|max:255', 'destination' => 'required|max:255', 'account_name' => 'required|max:255', 'account_number' => 'required|max:255', 'ondate' => 'required|date_format:"Y-m-d H:i:s"', 'amount' => 'required|numeric|in:' . $sale_data['bills']];
$validator = Validator::make($sale['payment'], $payment_rule);
//if there was log and validator false
if (!$validator->passes()) {
$errors->add('Log', $validator->errors());
} else {
$sale['payment']['transaction_id'] = $sale['id'];
$paid_data = $paid_data->fill($sale['payment']);
if (!$paid_data->save()) {
$errors->add('Log', $paid_data->getError());
}
}
}
}
//2. Check if status = shipping
if (!$errors->count() && in_array($sale['status'], ['shipping'])) {
if (is_null($sale['shipment']['receipt_number'])) {
$errors->add('Sale', 'Tidak ada nomor resi.');
} else {
$shipping_data = \App\Models\Shipment::id($sale['shipment']['id'])->first();
if ($shipping_data) {
$shipment_rule = ['receipt_number' => 'required|max:255'];
$validator = Validator::make($sale['shipment'], $shipment_rule);
//if there was log and validator false
if (!$validator->passes()) {
$errors->add('Log', $validator->errors());
} else {
$sale['shipment']['transaction_id'] = $sale['id'];
$shipping_data = $shipping_data->fill($sale['shipment']);
if (!$shipping_data->save()) {
$errors->add('Log', $shipping_data->getError());
}
}
} else {
$errors->add('Log', 'Shipment tidak valid.');
}
}
}
//3. Check if status = others
if (!$errors->count() && !in_array($sale['status'], ['paid', 'shipping'])) {
$log_rules = ['transaction_id' => 'exists:transactions,id|' . ($is_new ? '' : 'in:' . $sale_data['id']), 'status' => 'required|max:255|in:cart,wait,payment_process,paid,packed,shipping,delivered,canceled,abandoned'];
$validator = Validator::make($sale, $log_rules);
//if there was log and validator false
if (!$validator->passes()) {
$errors->add('Log', $validator->errors());
} else {
$log_data = new \App\Models\TransactionLog();
$log_data = $log_data->fill(['status' => $sale['status'], 'transaction_id' => $sale_data['id'], 'notes' => isset($sale['notes']) ? $sale['notes'] : '']);
if (!$log_data->save()) {
$errors->add('Log', $log_data->getError());
}
}
}
if ($errors->count()) {
DB::rollback();
return new JSend('error', (array) Input::all(), $errors);
}
DB::commit();
$final_sale = \App\Models\Sale::id($sale_data['id'])->with(['voucher', 'transactionlogs', 'user', 'transactiondetails', 'transactiondetails.varian', 'transactiondetails.varian.product', 'paidpointlogs', 'payment', 'shipment', 'shipment.address', 'shipment.courier', 'transactionextensions', 'transactionextensions.productextension'])->first()->toArray();
return new JSend('success', (array) $final_sale);
}