/**
 * @NApiVersion 2.1
 * @NScriptType ScheduledScript
 */
define(['N/search', 'N/record', 'N/log'], (search, record, log) => {

    const FAILED_LOCATION = 13; // Internal ID of "Failed Inventory"
    const REVIEW_BIN = 250;      // Internal ID of "Review" bin

    function execute() {
        // 1. Load saved search of items with Inventory Failed status
        const invSearch = search.load({ id: 'customsearch3117' });

        invSearch.run().each(result => {
            try {
                const itemId = result.getValue({ name: 'item' });
                const fromLocation = result.getValue({ name: 'Bin Number' });
                const qty = result.getValue({ name: 'Quantity' });
                const lot = result.getValue({ name: 'Lot Number' }); // if applicable

                if (!qty || qty <= 0) return true; // skip empty

                // 2. Create Inventory Transfer
                const transfer = record.create({ type: record.Type.INVENTORY_TRANSFER, isDynamic: true });

                transfer.setValue({ fieldId: 'location', value: fromLocation }); // From
                transfer.setValue({ fieldId: 'transferlocation', value: FAILED_LOCATION }); // To

                // Add line
                transfer.selectNewLine({ sublistId: 'inventory' });
                transfer.setCurrentSublistValue({ sublistId: 'inventory', fieldId: 'item', value: itemId });
                transfer.setCurrentSublistValue({ sublistId: 'inventory', fieldId: 'adjustqtyby', value: qty });

                // Inventory detail for bin/lot
                const invDetail = transfer.getCurrentSublistSubrecord({
                    sublistId: 'inventory',
                    fieldId: 'inventorydetail'
                });

                invDetail.selectNewLine({ sublistId: 'inventoryassignment' });
                invDetail.setCurrentSublistValue({ sublistId: 'inventoryassignment', fieldId: 'binnumber', value: REVIEW_BIN });
                invDetail.setCurrentSublistValue({ sublistId: 'inventoryassignment', fieldId: 'quantity', value: qty });
                if (lot) {
                    invDetail.setCurrentSublistValue({ sublistId: 'inventoryassignment', fieldId: 'issueinventorynumber', value: lot });
                }
                invDetail.commitLine({ sublistId: 'inventoryassignment' });

                transfer.commitLine({ sublistId: 'inventory' });

                const transferId = transfer.save();
                log.audit('Transfer Created', `ID: ${transferId}, Item: ${itemId}, Qty: ${qty}`);

            } catch (e) {
                log.error('Error moving failed inventory', e.message);
            }
            return true; // continue loop
        });
    }

    return { execute };
});