rajan-parmar

<?php

use App\Models\Currency;
use App\Models\PricingLevel;
use App\Models\Product;
use App\Models\ProductPrice;
use Illuminate\Support\Facades\Route;

Route::get('product-price-threshold', function() {
    $upc = [

rajan-parmar

<?php

use App\Models\RegisterUpdate;
use App\Models\RegisterUpdatePayment;
use App\Services\CloseRegisterService;
use Illuminate\Support\Facades\Route;

Route::get('register-update-columns-records-fix', function () {
    $registerUpdates = RegisterUpdate::with('register:id,name')->whereNotNull('closed_at')->get();

rajan-parmar

<?php

use App\Models\CreditNote;
use App\Models\CreditNoteUse;
use App\Models\RegisterUpdate;
use App\Models\Sale;
use App\Models\SaleReturn;
use Illuminate\Support\Facades\Route;

Route::get('register-update-id-set', function () {

rajan-parmar

 <?php

use App\Models\RegisterUpdate;
use App\Models\RegisterUpdatePayment;
use App\Models\Sale;
use Illuminate\Support\Facades\Route;

Route::get('void-sale-closing-balance', function () {
    $registerUpdate = RegisterUpdate::find(724);
    $saleOne = Sale::query()

rajan-parmar

<?php

use App\Models\Customer;
use App\Models\Frontliner;
use App\Models\Product;
use App\Models\ProductInventory;
use App\Models\ProductInventoryUpdate;
use App\Models\ProductUnit;
use App\Models\RegisterUpdate;
use App\Models\RegisterUpdatePayment;

rajan-parmar

SET FOREIGN_KEY_CHECKS=0;
UPDATE `payment_types` SET id = 101 WHERE id = 3;
UPDATE `payment_types` SET id = 102 WHERE id = 4;
UPDATE `payment_types` SET id = 103 WHERE id = 6;
UPDATE `payment_types` SET id = 104 WHERE id = 7;
UPDATE `payment_types` SET id = 105 WHERE id = 8;
UPDATE `payment_types` SET id = 106 WHERE id = 9;
UPDATE `payment_types` SET id = 107 WHERE id = 10;
UPDATE `payment_types` SET id = 108 WHERE id = 11;
UPDATE `payment_types` SET id = 109 WHERE id = 12;

rajan-parmar

<?php

use App\Models\CreditNote;
use Illuminate\Support\Facades\Route;

route::get('credit_note_sale_type', function () {
    $creditNotes = CreditNote::all();

    foreach ($creditNotes as $creditNote) {
        $creditNote->generated_by_type = 'App\\Models\\SaleReturn';

rajan-parmar

<?php

use App\Http\Controllers\LoginTempController;
use App\Models\RegisterUpdate;
use App\Models\SalePayment;
use Illuminate\Support\Facades\Route;

Route::get('register-update-payment', function () {
    $registerUpdates = RegisterUpdate::whereNotNull('closed_at')->get();

rajan-parmar

UPDATE
    inventory_transfers
SET
    document_type = 'STS'
WHERE   `source_location_type` = 'App\\Models\\Store' AND 
        `destination_location_type` = 'App\\Models\\Store' AND
        `discrepancy_type` IS NULL


UPDATE

rajan-parmar

<?php

namespace App\Imports;

use App\Models\Brand;
use App\Models\Category;
use App\Models\Color;
use App\Models\Department;
use App\Models\Product;
use App\Models\ProductInventory;