order_consumption_system_new/app/Models/OrderColumnR...

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class OrderColumnRecords extends Model
{
    protected $table = 'order_column_records';
    public $timestamps = false;

    public static function addData($edit)
    {
        $up_params = json_decode($edit['after_data'], true);
        $before_data = json_decode($edit['before_data'], true);

        $insert = array();
        foreach($up_params as $column=>$val){
            $data = array();
            $data['order_id'] = $edit['order_id'];
            $data['edit_id'] = $edit['id'];
            $data['column'] = $column;
            $data['after'] = $val;
            $data['before'] = $before_data[$column];
            $data['created_at'] = $edit['created_at'];

            $insert[] = $data;
        }

        return self::insert($insert);
   
    }

    public static function addBatchData($editLog, $edit)
    {
        $insert = array();
        foreach($editLog as $val){
            $data = array();
            $data['order_id'] = $val['order_id'];
            $data['edit_id'] = $edit['id'];
            $data['column'] = 'final_amount';
            $data['after'] = $val['original_final_amount'];
            $data['before'] = $val['final_amount'];
            $data['created_at'] = $edit['created_at'];

            $insert[] = $data;
        }

        return self::insert($insert);
    }
}