'Resource Transaction',
'number' => '4113',
'description' => 'Resource Transaction',
'version' => '0.1.1',
'db_version' => '1001',
'mod_version' => '1.1.1',
'primary_entity_cb' => '',
'module_name' => 'am',
'weight' => 5
];
public static $gl_journal_category = "AM_RESOURCE";
// data base variables as stored database column name
public static $transaction_type_a = [
'APPLY_RESOURCE' => 'Apply Resource',
'REMOVE_RESOURCE' => 'Remove Resource',
];
public $field_a = [
'am_resource_transaction_id',
'am_wo_routing_line_id',
'am_wo_routing_detail_id',
'am_wo_header_id',
'org_id',
'transaction_type',
'transaction_date',
'transaction_quantity',
'reason',
'reference',
'scrap_account_id',
'sales_order_header_id',
'sales_order_line_id',
'gl_journal_header_id',
'created_by',
'creation_date',
'last_update_by',
'last_update_date'
];
//variables used for showing data
public $initial_search = [
'am_resource_transaction_id',
'am_wo_header_id',
'org_id',
'wo_number',
'item_number',
'item_id_m'
];
public $account = [
'scrap_account_id'
];
public $fields_inForm_notInDataBase = [
'remaining_quantity',
'item_id_m',
'item_number',
"item_description",
"uom",
'available_quantity',
'total_quantity',
'department_id'
];
public $fields_inHeader_needsToBeInserted_inPOST = [
'org_id',
'transaction_type',
'transaction_date'
];
public $requiredField = [
'am_wo_routing_line_id',
'am_wo_routing_detail_id',
'am_wo_header_id',
'org_id',
'transaction_type',
'transaction_date',
'transaction_quantity'
];
public $profile_default = [
'org_id' => 'org_inv_name_default',
];
public $search = [
'_show_update_path' => 1,
'_show_view_path' => 1,
];
public $pageTitle = " Resource Trnx - WIP Work Order Resource Transaction "; //page Title
public $option_lists = [
// 'am_wo_type' => 'am_WO_TYPE',
// 'am_wo_status' => 'am_WO_STATUS',
];
public $am_resource_transaction_id;
public $am_wo_header_id;
public $am_wo_routing_line_id;
public $am_wo_routing_detail_id;
public $org_id;
public $transaction_type;
public $transaction_date;
public $transaction_quantity;
public $reason;
public $reference;
public $scrap_account_id;
public $sales_order_header_id;
public $sales_order_line_id;
public $created_by;
public $creation_date;
public $last_update_by;
public $last_update_date;
public $time;
public $msg;
public $remaining_quantity;
public $item_description;
public $uom;
public $total_quantity;
public $available_quantity;
public $department_id;
public $wo_number;
public $item_number;
public $item_id_m;
public $routing_sequence;
public $gl_journal_header_id;
Public static function am_transactions() {
$option_header = option_header::find_by_name('am_TRANSACTIONS');
$am_transactions = option_line::find_by_option_id($option_header->option_header_id);
return $am_transactions;
}
private function _save_journal_header() {
$inv = new inventory();
$inv_i = $inv->findRelatedDetail_ByOrgId($this->org_id);
$gled = new gl_ledger();
$gled->findBy_id($inv_i->ledger_id);
$gp = new gl_period();
$current_open_period = $gp->current_open_period($inv_i->ledger_id);
$gjh = new gl_journal_header;
$gjh->ledger_id = $inv_i->ledger_id;
$gjh->status = 'ENTERED';
$gjh->currency = $gled->currency_code;
$gjh->period_id = $current_open_period->gl_period_id;
$gjh->journal_source = self::$module;
$gjh->journal_category = self::$gl_journal_category;
$gjh->reference_type = 'table';
$gjh->reference_key_name = self::$table_name;
$gjh->reference_key_value = $this->am_resource_transaction_id;
$gjh->journal_name = $gjh->journal_category . '-' . $gjh->reference_key_value;
$gjh->description = $gjh->journal_name . '-' . current_time();
$gjh->balance_type = 'A';
$gjh->audit_trial();
$gjh->save();
$this->gl_journal_header_id = $gjh->gl_journal_header_id;
echo "
The New Journal Header Id is " . $this->gl_journal_header_id;
return $gjh->gl_journal_header_id;
}
private function _save_journal_lines($data) {
global $dbc;
foreach ($data as $data_a) {
$new_gjl = new gl_journal_line();
$new_gjl->gl_journal_header_id = $this->gl_journal_header_id;
$new_gjl->line_num = $data_a['line_number'];
$new_gjl->status = 'U';
$new_gjl->code_combination_id = $data_a['account_id'];
if (($data_a['dr_cr']) == 'dr') {
$new_gjl->total_dr = $data_a['amount'];
$new_gjl->total_ac_dr = $data_a['amount'];
} else {
$new_gjl->total_cr = $data_a['amount'];
$new_gjl->total_ac_cr = $data_a['amount'];
}
$new_gjl->description = 'WIP Resource Transaction Id ' . $this->am_resource_transaction_id;
$new_gjl->reference_type = 'table';
$new_gjl->reference_key_name = 'am_resource_transaction_id';
$new_gjl->reference_key_value = $this->am_resource_transaction_id;
$new_gjl->audit_trial();
$new_gjl->save();
}
}
public function _after_save() {
global $db;
//Insert in WIP WO BOM - item issues for operational pull
if ((!empty($this->am_resource_transaction_id)) && (!(empty($this->am_wo_routing_detail_id))) && (!(empty($this->transaction_quantity)))) {
$am_wo_routing_detail = new am_wo_routing_detail();
$am_wo_routing_detail_i = $am_wo_routing_detail->findBy_id($this->am_wo_routing_detail_id);
if ($am_wo_routing_detail->charge_type != 'am_MOVE') {
return 10;
}
$am_wo_routing_detail->am_wo_routing_detail_id = $am_wo_routing_detail_i->am_wo_routing_detail_id;
$am_wo_routing_detail->applied_quantity = $am_wo_routing_detail_i->applied_quantity + $this->transaction_quantity;
try {
$am_wo_routing_detail->audit_trial();
$am_wo_routing_detail->save();
$resource = new bom_resource();
$resource->findBy_id($am_wo_routing_detail->resource_id);
$bom_resource_cost = bom_resource_cost::find_by_resourceId_bomCostType($am_wo_routing_detail->resource_id);
$resource_unit_cost = !empty($bom_resource_cost->resource_rate) ? $bom_resource_cost->resource_rate : 0;
$total_amount = $resource_unit_cost * $this->transaction_quantity;
if (!empty($total_amount)) {
$journal_line_a = [];
$journal_line = [];
$this->_save_journal_header();
$line_number = 1;
$woh = new am_wo_header();
$woh->findBy_id($this->am_wo_header_id);
$am_accounting_group = new am_accounting_group();
$am_accounting_group->findBy_id($woh->am_accounting_group_id);
$journal_line['line_number'] = $line_number;
$journal_line['amount'] = $total_amount;
$journal_line['account_id'] = $am_accounting_group->resource_ac_id;
$journal_line['dr_cr'] = 'dr';
array_push($journal_line_a, $journal_line);
$line_number++;
$journal_line['line_number'] = $line_number;
$journal_line['amount'] = $total_amount;
$journal_line['account_id'] = $resource->absorption_ac_id;
$journal_line['dr_cr'] = 'cr';
array_push($journal_line_a, $journal_line);
$this->_save_journal_lines($journal_line_a);
}
echo "
The resource quantity is Successfully applied ";
} catch (Exception $e) {
echo "
Resource quantity application " . $e->getMessage();
}
}
}
public function save() {
$primary_column = static::$primary_column;
if (empty($this->$primary_column)) {
$this->create();
} else {
echo ' You are not allowed to update a completed move transaction!
';
}
return $this->msg;
}
}
//end of resource class
?>