/**
* return Piece from Pieces Return
*
* $.ajax({ method:'return', table:'Pieces', barcode:9...9, ...};
*
* @return string ''
*/
function JKY_return_piece($the_data)
{
$db = Zend_Registry::get('db');
$my_barcode = get_data($the_data, 'barcode');
$my_inspected_by = get_data($the_data, 'inspected_by');
$my_weighed_by = get_data($the_data, 'weighed_by');
$my_remarks = get_data($the_data, 'remarks');
$my_checkin_weight = get_data($the_data, 'checkin_weight');
$my_checkin_location = get_data($the_data, 'checkin_location');
$sql = 'UPDATE Pieces' . ' SET ' . get_updated() . ', status="Check In"' . ', inspected_by= ' . $my_inspected_by . ', weighed_by= ' . $my_weighed_by . ', remarks=\'' . $my_remarks . '\'' . ', checkin_weight= ' . $my_checkin_weight . ', checkin_location=\'' . $my_checkin_location . '\'' . ', checkin_at=\'' . get_time() . '\'' . ' WHERE id =' . $my_barcode;
log_sql('Pieces', 'update', $sql);
$db->query($sql);
insert_changes($db, 'Pieces', $my_barcode);
$my_order_id = get_table_value('Pieces', 'order_id', $my_barcode);
$my_set = ', produced_at=\'' . get_time() . '\'' . ', produced_pieces = produced_pieces + 1';
if ($my_remarks != 'boa') {
$my_set = ', rejected_pieces = rejected_pieces + 1';
}
$my_field_name = $my_remarks == 'boa' ? 'produced_pieces' : 'rejected_pieces';
$sql = 'UPDATE Orders' . ' SET ' . get_updated() . $my_set . ' WHERE id = ' . $my_order_id;
log_sql('Orders', 'update', $sql);
$db->query($sql);
insert_changes($db, 'Orders', $my_order_id);
return '';
}
/**
* checkin Piece from Pieces Check In
*
* $.ajax({ method:'checkin', table:'Pieces', barcode:9...9, ...};
*
* @return string ''
*/
function JKY_checkin_piece($the_data)
{
$db = Zend_Registry::get('db');
$my_barcode = get_data($the_data, 'barcode');
$my_checkin_weight = get_data($the_data, 'checkin_weight');
/*
$my_inspected_by = get_data($the_data, 'inspected_by' );
$my_weighed_by = get_data($the_data, 'weighed_by' );
$my_qualities = get_data($the_data, 'qualities' );
$my_remarks = get_data($the_data, 'remarks' );
$my_checkin_weight = get_data($the_data, 'checkin_weight' );
$my_checkin_location= get_data($the_data, 'checkin_location');
*/
$my_set = '';
// $my_set .= isset($the_data['revised_by' ]) ? ', revised_by = ' . trim($the_data['revised_by' ]) : '';
$my_set .= ', revised_by = ' . get_session('user_id');
// $my_set .= isset($the_data['weighed_by' ]) ? ', weighed_by = ' . trim($the_data['weighed_by' ]) : '';
$my_set .= ', weighed_by = ' . get_session('user_id');
$my_set .= isset($the_data['qualities']) ? ', qualities =\'' . trim($the_data['qualities']) . '\'' : '';
$my_set .= isset($the_data['remarks']) ? ', remarks =\'' . trim($the_data['remarks']) . '\'' : '';
$my_set .= isset($the_data['checkin_weight']) ? ', checkin_weight = ' . trim($the_data['checkin_weight']) : '';
$my_set .= isset($the_data['checkin_location']) ? ', checkin_location =\'' . trim($the_data['checkin_location']) . '\'' : '';
$sql = 'UPDATE Pieces' . ' SET ' . get_updated() . ', checkin_at=\'' . get_time() . '\'' . $my_set . ' WHERE id =' . $my_barcode;
log_sql('Pieces', 'update', $sql);
$db->query($sql);
insert_changes($db, 'Pieces', $my_barcode);
$my_piece = db_get_row('Pieces', 'barcode =\'' . $my_barcode . '\'');
if (!is_empty($my_piece['revised_by']) && !is_empty($my_piece['weighed_by'])) {
$sql = 'UPDATE Pieces' . ' SET status="Check In"' . ' WHERE id = ' . $my_barcode;
log_sql('Pieces', 'update', $sql);
$db->query($sql);
}
// $my_order_id = get_table_value('Pieces', 'order_id', $my_barcode);
$my_order_id = $my_piece['order_id'];
if (strtolower($my_piece['qualities']) == 'boa') {
$my_set = ', produced_at=\'' . get_time() . '\'' . ', produced_pieces = produced_pieces + 1' . ', produced_weight = produced_weight + ' . $my_checkin_weight;
} else {
$my_set = ', rejected_pieces = rejected_pieces + 1';
}
$sql = 'UPDATE Orders' . ' SET ' . get_updated() . $my_set . ' WHERE id = ' . $my_order_id;
log_sql('Orders', 'update', $sql);
$db->query($sql);
insert_changes($db, 'Orders', $my_order_id);
return '';
}
/**
* checkout Piece from Pieces Check Out
*
* $.ajax({ method:'checkout', table:'Pieces', barcode:9...9, ...};
*
* @return string ''
*/
function JKY_checkout_piece($the_data)
{
$db = Zend_Registry::get('db');
$my_barcode = get_data($the_data, 'barcode');
$my_location = get_data($the_data, 'location');
$my_loadset_id = get_data($the_data, 'loadset_id');
$my_piece = db_get_row('Pieces', 'id=' . $my_barcode);
$sql = 'UPDATE LoadSets' . ' SET reserved_pieces = reserved_pieces - 1' . ' , reserved_weight = reserved_weight - ' . $my_piece['checkin_weight'] . ' , checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_loadset_id;
log_sql('LoadSets', 'update', $sql);
$db->query($sql);
insert_changes($db, 'LoadSets', $my_loadset_id);
$my_loadset = db_get_row('LoadSets', 'id=' . $my_loadset_id);
$sql = 'UPDATE LoadQuotations' . ' SET reserved_pieces = reserved_pieces - 1' . ' , reserved_weight = reserved_weight - ' . $my_piece['checkin_weight'] . ' , checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_loadset['load_quot_id'];
log_sql('LoadQuotations', 'update', $sql);
$db->query($sql);
insert_changes($db, 'LoadQuotations', $my_loadset['load_quot_id']);
$my_loadquot = db_get_row('LoadQuotations', 'id=' . $my_loadset['load_quot_id']);
$sql = 'UPDATE LoadOuts' . ' SET checkout_at="' . get_time() . '"' . ' , checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_loadquot['loadout_id'];
log_sql('LoadOuts', 'update', $sql);
$db->query($sql);
insert_changes($db, 'LoadOuts', $my_loadquot['loadout_id']);
$sql = 'UPDATE Pieces' . ' SET ' . get_updated() . ', status="Check Out"' . ', checkout_by=' . get_session('user_id') . ', checkout_at="' . get_time() . '"' . ', checkout_location="' . $my_location . '"' . ', load_quot_id= ' . $my_loadquot['id'] . ' WHERE id =' . $my_piece['id'];
log_sql('Pieces', 'update', $sql);
$db->query($sql);
insert_changes($db, 'Pieces', $my_barcode);
$sql = 'UPDATE Orders' . ' SET checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_piece['order_id'];
log_sql('Orders', 'update', $sql);
$db->query($sql);
insert_changes($db, 'Orders', $my_piece['order_id']);
return '';
}
