PHPackages                             aungmyat/report - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [File & Storage](/categories/file-storage)
4. /
5. aungmyat/report

ActiveLibrary[File & Storage](/categories/file-storage)

aungmyat/report
===============

This will create excel file in background with laravel queue and send it via email

v2.0.2(11mo ago)0162↓83.3%MITPHP

Since Jun 11Pushed 11mo ago1 watchersCompare

[ Source](https://github.com/aungmindev/aungmyat-report)[ Packagist](https://packagist.org/packages/aungmyat/report)[ RSS](/packages/aungmyat-report/feed)WikiDiscussions main Synced 3d ago

READMEChangelogDependencies (1)Versions (4)Used By (0)

\#This is report system

\#There are 4 simple steps to complete this package after installing.

\#Installation = (composer require aungmyat/report:v2.0.1)

1. add following Serviceprovider in config/app.php.

    \\Aungmyat\\Report\\ReportServiceProvider::class,
2. Set up Mail in .env
3. If You are not set up Queue.

    - Set up driver for QueueConnection in .env {Change => database}
    - Run (php artisan queue:table)
    - Run (php artisan migrate)

4 . Usage

```
  * use Aungmyat\Report\Process_provider\reportingProcess;

public function method()

 {

    //method 1
    // if(!$request->download_date){
    //     $start_date = Carbon::now()->format('Y-m-d').' 00:00:00';
    //     $end_date = Carbon::now()->format('Y-m-d').' 23:59:59';
    // }else{
    //     $start_date = Carbon::parse($request->download_date)->format('Y-m-d').' 00:00:00';
    //     $end_date = Carbon::parse($request->download_date)->format('Y-m-d').' 23:59:59';
    // }

    //  $query = "select car_cycle_infos.vehicle_license_number as license_number,liter,amount,vehicle_types.name AS category_type_name,shop_name,smart_card_number from `petro_shop_sale_records` left join `petro_shops` on `petro_shop_sale_records`.`petro_shop_id` = `petro_shops`.`id` left join `vehicles` on `petro_shop_sale_records`.`vehicle_id` = `vehicles`.`id` left join `car_cycle_infos` on `vehicles`.`vehicleable_id` = `car_cycle_infos`.`id` left join `vehicle_types` on `petro_shop_sale_records`.`category_type` = `vehicle_types`.`id` where `petro_shop_sale_records`.`created_at` >= '$start_date' and `petro_shop_sale_records`.`created_at`