public static function getRecords($parameters)
{
$query = Category::builder();
if (isset($parameters['active_110'])) {
$query->where('active_110', $parameters['active_110']);
}
if (isset($parameters['slug_110'])) {
$query->where('slug_110', $parameters['slug_110']);
}
if (isset($parameters['lang_id_110'])) {
$query->where('lang_id_110', $parameters['lang_id_110']);
}
return $query->get();
}
public function editCustomRecord($parameters)
{
$parameters['categories'] = Category::where('lang_id_110', $parameters['lang']->id_001)->get();
$parameters['productTypes'] = array_map(function ($object) {
$object->name = trans($object->name);
return $object;
}, config('market.productTypes'));
$parameters['priceTypes'] = array_map(function ($object) {
$object->name = trans($object->name);
return $object;
}, config('market.priceTypes'));
$parameters['productClassTaxes'] = ProductClassTax::builder()->get();
$parameters['parentsProducts'] = Product::builder()->where('lang_id_112', base_lang()->id_001)->where('id_111', '<>', $parameters['id'])->whereNull('parent_product_id_111')->get();
$taxRules = TaxRule::builder()->where('country_id_103', config('market.taxCountry'))->where('customer_class_tax_id_106', config('market.taxCustomerClass'))->where('product_class_tax_id_107', $parameters['object']->product_class_tax_id_111)->orderBy('priority_104', 'asc')->get();
$taxes = TaxRuleLibrary::taxCalculateOverSubtotal($parameters['object']->subtotal_111, $taxRules);
// ATTENTION! we create custom properties tax_amount_111 and total_111
$parameters['object']->tax_amount_111 = $taxes->sum('taxAmount');
$parameters['object']->total_111 = $parameters['object']->subtotal_111 + $parameters['object']->tax_amount_111;
$attachments = AttachmentLibrary::getRecords($this->package, 'market-product', $parameters['object']->id_111, $parameters['lang']->id_001);
$parameters['customFieldGroups'] = CustomFieldGroup::builder()->where('resource_id_025', 'market-product')->get();
$parameters['attachmentFamilies'] = AttachmentFamily::getAttachmentFamilies(['resource_id_015' => 'market-product']);
$parameters = array_merge($parameters, $attachments);
return $parameters;
}
public function apiCheckSlug()
{
return response()->json(['status' => 'success', 'slug' => Category::checkSlug('slug_110', $this->request->input('slug'), $this->request->input('id'))]);
}