public static function setData(CellCollection $v)
{
$product = Product::whereCode($v->product_code)->first();
return ['group' => $v->group, 'number' => $v->number, 'product_id' => $product->id, 'product_code' => $product->code, 'mix_no' => $product->mix_no, 'product_description' => $product->description, 'qty' => $v->qty, 'unit' => $v->unit, 'remark' => $v->remark];
}
public static function setData(CellCollection $v)
{
$product = Product::whereCode($v->product_code)->first();
$location = Location::whereName($v->location)->first();
return ['product_id' => $product->id, 'product_code' => $product->code, 'mix_no' => $product->mix_no, 'product_description' => $product->description, 'location_id' => $location->id, 'location_name' => $location->name, 'qty' => $v->qty, 'remark' => $v->remark];
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
// parse url
$url = $this->parseURLPDF();
// Parse pdf file and build necessary objects.
$parser = new \Smalot\PdfParser\Parser();
$pdf = $parser->parseFile($url);
$pages = $pdf->getPages();
foreach ($pages as $page) {
$p = new ParsePage($page->getArray());
$products = $p->parseProducts();
foreach ($products as $product) {
$p = Product::whereCode($product['code'])->first();
if (is_null($p)) {
$p = new Product();
}
$p->fill($product);
$p->save();
}
}
}
