<?php

namespace App\Models;

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

class Parameter extends Model
{
    use HasFactory;

    /**
     * @var string
     */
    protected $table = 'parameter';

    /**
     * @var string[]
     */
    protected $fillable = [
        'group',
        'name',
        'value',
    ];

    /**
     * @var string[]
     */
    protected $dates = [
        'created_at',
        'updated_at',
    ];

	public function dataUpdate(array $group)
	{
		$message = 'parameter error';
		DB::beginTransaction();
		if(array_key_exists('name',$group) and array_key_exists('value',$group)) {
\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__);
			$group_name = $group['name'];
			$group_value = $group['value'];
			foreach($group_value as $group_value_key => $group_value_value) {
\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__);
				if(array_key_exists('name',$group_value_value) and array_key_exists('value',$group_value_value)) {
\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__);
					$name = $group_value_value['name'];
					$value = $group_value_value['value'];
					$parameter_table = DB::table($this->table);
					$parameter_table->where('group',$group_name);
					$parameter_table->where('name',$name);
					$parameter_recs = $parameter_table->get();
					if(count($parameter_recs) == 0) {
\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__);
						$parameter_rec = array();
						$parameter_rec['group'] = $group_name;
						$parameter_rec['name'] = $name;
						$parameter_rec['value'] = $value;
	//					$parameter_rec['updated_at'] = 
						try {
							$parameter_table->insert($parameter_rec);
				        } catch (Throwable $e) {
							$message = $e->getMessage();
				            \Log::info($message);
							DB::rollback();
							return $message;
						}
					}else{
\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__);
						$parameter_rec = array();
						$parameter_rec['value'] = $value;
	//					$parameter_rec['updated_at'] = 
						$parameter_value = $parameter_recs[0];
						$parameter_table = DB::table($this->table);
						$parameter_table->where('id',$parameter_value->id);
						try {
							$parameter_table->update($parameter_rec);
				        } catch (Throwable $e) {
							$message = $e->getMessage();
				            \Log::info($message);
							DB::rollback();
							return $message;
						}
					}
				}
			}
\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__);
			DB::commit();
			return '';
		}
\Log::error('■'.__CLASS__.'|'.__FUNCTION__.'|'.__LINE__);
		DB::rollback();
		return $message;
	}
}
