Set local timezone in wordpress programatically

Set local timezone in wordpress programatically:

add_action('wp_loaded', 'animed_time_zone_function');

function animed_time_zone_function() {

    $timezone_identifier = 'Asia/Dhaka';

    date_default_timezone_set($timezone_identifier);

}

Happy coding!

Get completed orders count for a specific user with a specific product in Woocommerce

Get completed orders count for a specific user with a specific product in Woocommerce:

Code:

function get_total_product_completed_order_for_a_specific_user() {

    $product_slug = 'product-slug';

    $product_obj = get_page_by_path($product_slug, OBJECT, 'product');

    $pid = 0;

    if (!empty($product_obj)) {

        $pid = $product_obj->ID;

    }

    // Get all customer orders

    $customer_orders = get_posts(

        array(

            'numberposts' => -1,

            'meta_key'    => '_customer_user',

            'orderby'     => 'date',

            'order'       => 'DESC',

            'meta_value'  => get_current_user_id(),

            'post_type'   => wc_get_order_types(),

            'post_status' => array_keys(wc_get_order_statuses()),

            'post_status' => array('wc-completed'),

        )

    );

    $Order_Array = [];

    $apid_counter = 0;

    foreach ($customer_orders as $customer_order) {

        $orderq        = wc_get_order($customer_order);

        $items = $orderq->get_items();

        foreach ( $items as $item ) {

            $product_id = $item->get_product_id();

            if ($pid == $product_id) {

                $apid_counter++;

            }

            break;

        }

        $Order_Array[] = [

            "ID"    => $orderq->get_id(),

            "Value" => $orderq->get_total(),

            "Date"  => $orderq->get_date_created()->date_i18n('Y-m-d'),

        ];

    }

    // return count($Order_Array);

    return $apid_counter;

}

Happy coding...

Laravel - raw query with pagination

Laravel - raw query with pagination:

class InventoryController extends Controller

{

    public function index(Request $request)

    {

        $sql = "SELECT *,products.name as product_name, product_categories.name as category_name, products.id as productid,

              ( SELECT SUM(buy_products.qty) as purcahse_qty

                FROM buy_products

                WHERE buy_products.product_id=products.id GROUP BY buy_products.product_id ) as bqty,

              ( SELECT SUM(sell_products.qty) as order_qty

                FROM sell_products

                WHERE sell_products.product_id=products.id GROUP BY sell_products.product_id ) as sqty 

                FROM products LEFT JOIN product_categories ON products.product_category_id=product_categories.id

                ";

        $results = DB::select($sql);

        $productInventoryData = $this->arrayPaginator($results, $request);

        return view('auth.inventory.inventory_list')->with('productInventoryData', $productInventoryData);

    }

    public function arrayPaginator($array, $request)

    {

        $page = is_null($request->get('page')) ? 1 : $request->get('page');

        $perPage = 2;

        $offset = ($page * $perPage) - $perPage;

        return new LengthAwarePaginator(array_slice($array, $offset, $perPage, true), count($array), $perPage, $page,

            ['path' => $request->url(), 'query' => $request->query()]);

    }

}

And in views you can use links as like DB query build we use.
Thanks and happy coding.

Detect current URL and match with home page in wordpres

Detect current URL and match with home page in wordpres:

Sometimes you may select "Your latest posts" in backend settings->reading.

In this case your home page will be your theme's index.php file.

In this case you might need to detect what is your front page / home page and match to your current page.

In this case you can use below code to differentiate home page to other pages/posts:

$home_url = get_option('home') . '/';

$actual_link = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on'

? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

if ($home_url === $actual_link) {

    // Code goes here

}

// Happy coding...

Fix Myql crash in XAMPP

Fix Mysql crash in XAMPP:

1. Go to xampp -> mysql folder

2. Copy data folder and paste and rename it to data_old

3. Go to data folder, and delete these 4 folders: mysql, performance_schema, phpmyadmin and test. Then delete all the files except ibdata1 

4. Copy all files from mysql/backup folder, except ibdata1 

5. Paste them to data folder

Start your Mysql server in Xampp.

YOU ARE DONE! 👏

Fix Mysql table crashed in wordpress

Since this morning I get this below error:
Warning: mysqli_query(): (HY000/1194): Table 'wp_postmeta' is marked as crashed and should be repaired in C:\xampp\htdocs\wp_project\wp-includes\wp-db.php on line 2056

After that I logged into mysql terminal:
mysql -uroot -p

Then select database:
use wp_project

Then run the below command to fix the target table:
REPAIR TABLE wp_project.wp_postmeta;

And it solves the issue 👍

Create Laravel project by composer with a specific version of Laravel

Create Laravel project with a specific Laravel version:

composer create-project laravel/laravel=8.* your-project-name --prefer-dist

Here put your version number laravel/laravel=HERE.