user); $this->currentRowNumber = $this->getRowNumber(); $this->counter++; echo "
";
print_r($this->currentRowNumber);
echo "--";
print_r($this->counter);
echo "---";
return new Enquire([
'Name'=>$row[0],
'FatherName' => $row[1]
]);
print_r($this->user);
}
public function startRow(): int
{
echo "startRoww";
return 2;
}
public function batchSize(): int
{
echo "batchSize";
return 1000;
}
public function chunkSize(): int
{
echo 'chunk';
return 1000;
}
public static function afterImport(AfterImport $event)
{
$upload = UploadedFile::create([
'fileName' => self::$fileName,
'type'=>'enquire',
'addBy'=>self::$user,
'addDate'=>date('Y-m-d h:i:s')
]);
// $upload->fileName = self::fileName;
// $upload->rowCount = self::$currentRowNumber;
// $upload->type = "Enquire";
// $upload->addBy = self::$user;
// $upload->addDate = date();
// $upload->save();
// print_r(self::$currentRowNumber);
}
public function rowCount():int
{
return $this->currentRowNumber;
}
}
Route::prefix('api')->group(function(){
Route::get('createToken','Api\ApiController@createToken')->name('createToken');
});
select `leadId`, `addDate`,SUBSTRING(addDate,1,10) as newDt from `followup` where `followupPurpose` <> 'Welcome' or `followupPurpose` is null and `leadId` in (1, 3, 4, 5, 6, 7, 8, 14, 15, 16, 17) group by `leadId`,`newDt`