@extends('layouts.app')
@section('title', __('product.import_products'))

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">@lang('product.import_products')
    </h1>
</section>

<!-- Main content -->
<section class="content">
    
    @if (session('notification') || !empty($notification))
        <div class="row">
            <div class="col-sm-12">
                <div class="alert alert-danger alert-dismissible">
                    <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                    @if(!empty($notification['msg']))
                        {{$notification['msg']}}
                    @elseif(session('notification.msg'))
                        {{ session('notification.msg') }}
                    @endif
                </div>
            </div>  
        </div>     
    @endif
    
    <div class="row">
        <div class="col-sm-12">
            @component('components.widget', ['class' => 'box-primary'])
                {!! Form::open(['url' => action([\App\Http\Controllers\ImportProductsController::class, 'store']), 'method' => 'post', 'enctype' => 'multipart/form-data' ]) !!}
                    <div class="row">
                        <div class="col-sm-6">
                        <div class="col-sm-8">
                            <div class="form-group">
                                {!! Form::label('name', __( 'product.file_to_import' ) . ':') !!}
                                {!! Form::file('products_csv', ['accept'=> '.xls, .xlsx, .csv', 'required' => 'required']); !!}
                              </div>
                        </div>
                        <div class="col-sm-4">
                        <br>
                            <button type="submit" class="tw-dw-btn tw-dw-btn-primary tw-text-white">@lang('messages.submit')</button>
                        </div>
                        </div>
                    </div>

                    {{-- Two switches that matter for a large first load: validate the
                         whole file before committing anything, and decide whether
                         unknown manufacturers/divisions/compositions are created or
                         rejected. --}}
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="checkbox">
                                <label>
                                    {!! Form::checkbox('dry_run', 1, false) !!}
                                    <strong>@lang('lang_v1.import_dry_run')</strong>
                                    <span class="help-block" style="margin:0;">@lang('lang_v1.import_dry_run_help')</span>
                                </label>
                            </div>
                            <div class="checkbox">
                                <label>
                                    {!! Form::checkbox('create_missing_masters', 1, false) !!}
                                    <strong>@lang('lang_v1.create_missing_masters')</strong>
                                    <span class="help-block" style="margin:0;">@lang('lang_v1.create_missing_masters_help')</span>
                                </label>
                            </div>
                        </div>
                    </div>

                {!! Form::close() !!}
                <br><br>
                <div class="row">
                    <div class="col-sm-4">
                        {{-- Generated from ImportProductsController::templateColumns()
                             so the template can never drift from the parser. The old
                             link pointed at a file that did not exist in the repo. --}}
                        <a href="{{ action([\App\Http\Controllers\ImportProductsController::class, 'downloadImportTemplate']) }}" class="tw-dw-btn tw-dw-btn-success tw-text-white"><i class="fa fa-download"></i> @lang('lang_v1.download_template_file')</a>
                        <p class="help-block">The template includes two <strong>SAMPLE</strong> rows (a single and a
                            variable product) showing how to fill each column — delete both before adding your own
                            products and uploading.</p>
                    </div>
                </div>
            @endcomponent
        </div>
    </div>
    <div class="row">
        <div class="col-sm-12">
            @component('components.widget', ['class' => 'box-primary', 'title' => __('lang_v1.instructions')])
                <strong>@lang('lang_v1.instruction_line1')</strong><br>
                    @lang('lang_v1.instruction_line2')
                    <br><br>
                <table class="table table-striped">
                    <tr>
                        <th>@lang('lang_v1.col_no')</th>
                        <th>@lang('lang_v1.col_name')</th>
                        <th>@lang('lang_v1.instruction')</th>
                    </tr>
                    <tr>
                        <td>1</td>
                        <td>@lang('product.product_name') <small class="text-muted">(@lang('lang_v1.required'))</small></td>
                        <td>@lang('lang_v1.name_ins')</td>
                    </tr>
                    <tr>
                        <td>2</td>
                        <td>@lang('product.brand') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.brand_ins') <br><small class="text-muted">(@lang('lang_v1.brand_ins2'))</small></td>
                    </tr>
                    <tr>
                        <td>3</td>
                        <td>@lang('product.unit') <small class="text-muted">(@lang('lang_v1.required'))</small></td>
                        <td>@lang('lang_v1.unit_ins')</td>
                    </tr>
                    <tr>
                        <td>4</td>
                        <td>@lang('product.category') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.category_ins') <br><small class="text-muted">(@lang('lang_v1.category_ins2'))</small></td>
                    </tr>
                    <tr>
                        <td>5</td>
                        <td>@lang('product.sub_category') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.sub_category_ins') <br><small class="text-muted">({!! __('lang_v1.sub_category_ins2') !!})</small></td>
                    </tr>
                    <tr>
                        <td>6</td>
                        <td>@lang('product.sku') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.sku_ins')</td>
                    </tr>
                    <tr>
                        <td>7</td>
                        <td>@lang('product.barcode_type') <small class="text-muted">(@lang('lang_v1.optional'), @lang('lang_v1.default'): C128)</small></td>
                        <td>@lang('lang_v1.barcode_type_ins') <br>
                            <strong>@lang('lang_v1.barcode_type_ins2'): C128, C39, EAN-13, EAN-8, UPC-A, UPC-E, ITF-14</strong>
                        </td>
                    </tr>
                    <tr>
                        <td>8</td>
                        <td>@lang('product.manage_stock') <small class="text-muted">(@lang('lang_v1.required'))</small></td>
                        <td>@lang('lang_v1.manage_stock_ins')<br>
                            <strong>1 = @lang('messages.yes')<br>
                            0 = @lang('messages.no')</strong>
                        </td>
                    </tr>
                    <tr>
                        <td>9</td>
                        <td>@lang('product.alert_quantity') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('product.alert_quantity')</td>
                    </tr>
                    <tr>
                        <td>10</td>
                        <td>@lang('product.expires_in') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.expires_in_ins')</td>
                    </tr>
                    <tr>
                        <td>11</td>
                        <td>@lang('lang_v1.expire_period_unit') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.expire_period_unit_ins')<br>
                            <strong>@lang('lang_v1.available_options'): days, months</strong>
                        </td>
                    </tr>
                    <tr>
                        <td>12</td>
                        <td>@lang('product.applicable_tax') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.applicable_tax_ins') {!! __('lang_v1.applicable_tax_help') !!}</td>
                    </tr>
                    <tr>
                        <td>13</td>
                        <td>@lang('product.selling_price_tax_type') <small class="text-muted">(@lang('lang_v1.required'))</small></td>
                        <td>@lang('product.selling_price_tax_type') <br>
                            <strong>@lang('lang_v1.available_options'): inclusive, exclusive</strong>
                        </td>
                    </tr>
                    <tr>
                        <td>14</td>
                        <td>@lang('product.product_type') <small class="text-muted">(@lang('lang_v1.required'))</small></td>
                        <td>@lang('product.product_type') <br>
                            <strong>@lang('lang_v1.available_options'): single, variable</strong></td>
                    </tr>
                    <tr>
                        <td>15</td>
                        <td>@lang('product.variation_name') <small class="text-muted">(@lang('lang_v1.variation_name_ins'))</small></td>
                        <td>@lang('lang_v1.variation_name_ins2')</td>
                    </tr>
                    <tr>
                        <td>16</td>
                        <td>@lang('product.variation_values') <small class="text-muted">(@lang('lang_v1.variation_values_ins'))</small></td>
                        <td>{!! __('lang_v1.variation_values_ins2') !!}</td>
                    </tr>
                    <tr>
                        <td>17</td>
                        <td>@lang('lang_v1.variation_sku') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>{!! __('lang_v1.variation_sku_ins') !!}</td>
                    </tr>
                    <tr>
                        <td>18</td>
                        <td> @lang('lang_v1.purchase_price_inc_tax')<br><small class="text-muted">(@lang('lang_v1.purchase_price_inc_tax_ins1'))</small></td>
                        <td>{!! __('lang_v1.purchase_price_inc_tax_ins2') !!}</td>
                    </tr>
                    <tr>
                        <td>19</td>
                        <td>@lang('lang_v1.purchase_price_exc_tax')  <br><small class="text-muted">(@lang('lang_v1.purchase_price_exc_tax_ins1'))</small></td>
                        <td>{!! __('lang_v1.purchase_price_exc_tax_ins2') !!}</td>
                    </tr>
                    <tr>
                        <td>20</td>
                        <td>@lang('lang_v1.profit_margin') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.profit_margin_ins')<br>
                            <small class="text-muted">{!! __('lang_v1.profit_margin_ins1') !!}</small></td>
                    </tr>
                    <tr>
                        <td>21</td>
                        <td>@lang('lang_v1.selling_price') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.selling_price_ins')<br>
                         <small class="text-muted">{!! __('lang_v1.selling_price_ins1') !!}</small></td>
                    </tr>
                    <tr>
                        <td>22</td>
                        <td>@lang('lang_v1.opening_stock') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.opening_stock_ins') {!! __('lang_v1.opening_stock_help_text') !!}<br>
                        </td>
                    </tr>
                    <tr>
                        <td>23</td>
                        <td>@lang('lang_v1.opening_stock_location') <small class="text-muted">(@lang('lang_v1.optional')) <br>@lang('lang_v1.location_ins')</small></td>
                        <td>@lang('lang_v1.location_ins1')<br>
                        </td>
                    </tr>
                    <tr>
                        <td>24</td>
                        <td>@lang('lang_v1.expiry_date') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>{!! __('lang_v1.expiry_date_ins') !!}<br>
                        </td>
                    </tr>
                    <tr>
                        <td>25</td>
                        <td>@lang('lang_v1.enable_imei_or_sr_no') <small class="text-muted">(@lang('lang_v1.optional'), @lang('lang_v1.default'): 0)</small></td>
                        <td><strong>1 = @lang('messages.yes')<br>
                            0 = @lang('messages.no')</strong><br>
                        </td>
                    </tr>
                    <tr>
                        <td>26</td>
                        <td>@lang('lang_v1.weight') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.optional')<br>
                        </td>
                    </tr>
                    <tr>
                        <td>27</td>
                        <td>@lang('lang_v1.rack') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>{!! __('lang_v1.rack_help_text') !!}</td>
                    </tr>
                    <tr>
                        <td>28</td>
                        <td>@lang('lang_v1.row') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>{!! __('lang_v1.row_help_text') !!}</td>
                    </tr>
                    <tr>
                        <td>29</td>
                        <td>@lang('lang_v1.position') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>{!! __('lang_v1.position_help_text') !!}</td>
                    </tr>
                    <tr>
                        <td>30</td>
                        <td>@lang('lang_v1.image') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>{!! __('lang_v1.image_help_text', ['path' => 'public/uploads/'.config('constants.product_img_path')]) !!} <br><br>
                            {{__('lang_v1.img_url_help_text')}} 
                        </td>
                        <td></td>
                    </tr>
                    <tr>
                        <td>31</td>
                        <td>@lang('lang_v1.product_description') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td></td>
                        <td></td>
                    </tr>
                    <tr>
                        <td>32</td>
                        <td>@lang('lang_v1.product_custom_field1') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td></td>
                    </tr>
                    <tr>
                        <td>33</td>
                        <td>@lang('lang_v1.product_custom_field2') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                    </tr>
                    <tr>
                        <td>34</td>
                        <td>@lang('lang_v1.product_custom_field3') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td></td>
                    </tr>
                    <tr>
                        <td>35</td>
                        <td>@lang('lang_v1.product_custom_field4') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                    </tr>
                    <tr>
                        <td>36</td>
                        <td>@lang('lang_v1.not_for_selling') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td><strong>1 = @lang('messages.yes')<br>
                            0 = @lang('messages.no')</strong><br>
                        </td>
                    </tr>
                    <tr>
                        <td>37</td>
                        <td>@lang('lang_v1.product_locations') <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>@lang('lang_v1.product_locations_ins')
                        </td>
                    </tr>
                    <tr>
                        <td>38</td>
                        <td>Drug Schedule <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td><strong>@lang('lang_v1.available_options'): H, H1, X, G, J, OTC</strong><br>
                            <small class="text-muted">Schedules H, H1 and X automatically mark the product as prescription-required.</small>
                        </td>
                    </tr>
                    <tr>
                        <td>39</td>
                        <td>HSN Code <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>HSN / SAC tax code of the product.</td>
                    </tr>
                    <tr>
                        <td>40</td>
                        <td>Dosage Form <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>e.g. tablet, capsule, syrup, injection, ointment.</td>
                    </tr>
                    <tr>
                        <td>41</td>
                        <td>Storage Condition <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>e.g. cool_dry_place, refrigerate, room_temperature.</td>
                    </tr>
                    <tr>
                        <td>42</td>
                        <td>Manufacturer <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Name of an existing manufacturer. Must match a manufacturer already created in the system.</td>
                    </tr>
                    <tr>
                        <td>43</td>
                        <td>Division <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Name of an existing division. Must match a division already created in the system.</td>
                    </tr>
                    <tr>
                        <td>44</td>
                        <td>Composition <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Name of an existing composition / salt, or any name when
                            <em>@lang('lang_v1.create_missing_masters')</em> is ticked.</td>
                    </tr>
                    {{-- 45-57, added 2026-08 to close the gap against the product
                         form. All optional: a file built from the older 44-column
                         template still imports unchanged. --}}
                    <tr>
                        <td>45</td>
                        <td>Opening Stock Sub-unit <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Unit the <strong>Opening Stock</strong> figure (column 22) is expressed in, e.g. <code>Baby Box</code>.
                            The quantity is converted to base units using that unit's multiplier.</td>
                    </tr>
                    <tr>
                        <td>46</td>
                        <td>MRP (inc. tax) <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Maximum Retail Price printed on the pack. Leave blank only if the product has no MRP —
                            it is required on pharmacy invoices and labels.</td>
                    </tr>
                    <tr>
                        <td>47</td>
                        <td>Mfg Lead Time (days) <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Whole days from PO date for the product to reach the warehouse from the manufacturer.
                            Drives the PO Follow-up ETA. Blank = unknown (the observed average is used instead); <strong>not</strong> the same as 0.</td>
                    </tr>
                    <tr>
                        <td>48</td>
                        <td>Sub-units <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Comma separated unit names that this product can be transacted in, e.g.
                            <code>Strip(1/15),Baby Box(1/15)</code>. Required for pack-based selling and for auto-PO
                            rounding to whole packs.
                            <br><strong>Each must be a sub-unit of the unit in column 3</strong> — that is, its Base Unit
                            under Products &gt; Units must be that same unit. A pack belonging to a different base unit
                            is rejected, because it would be stored and then ignored everywhere it matters.
                            <br>Consequently column 3 must hold the <em>base</em> unit (e.g. <code>Tablets</code>), never a
                            pack, whenever this column is used.</td>
                    </tr>
                    <tr>
                        <td>49</td>
                        <td>Sellable Units <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Subset of column 48 (plus the base unit) that may be <strong>sold</strong>. Blank = all of them.
                            A name that is neither the base unit nor one of the sub-units listed in column 48 is rejected.</td>
                    </tr>
                    <tr>
                        <td>50</td>
                        <td>Purchasable Units <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Subset of column 48 (plus the base unit) that may be <strong>purchased</strong>. Blank = all of them.
                            A name that is neither the base unit nor one of the sub-units listed in column 48 is rejected.</td>
                    </tr>
                    <tr>
                        <td>51</td>
                        <td>Default Sell Unit <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Pre-selected unit at POS. Must be the base unit or one from column 48, and inside column 49 when that is set.</td>
                    </tr>
                    <tr>
                        <td>52</td>
                        <td>Default Purchase Unit <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Pre-selected unit at purchase entry. Same rules against columns 48 and 50.</td>
                    </tr>
                    <tr>
                        <td>53</td>
                        <td>Secondary Unit <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Name of an existing unit, used as the product's secondary unit.</td>
                    </tr>
                    <tr>
                        <td>54</td>
                        <td>Manufacturers <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Comma separated list of <strong>every</strong> manufacturer that makes this product — the first is the primary.
                            A warehouse purchase order can then be placed on any of them. Overrides column 42 when both are filled.</td>
                    </tr>
                    <tr>
                        <td>55</td>
                        <td>Can be purchased? <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>1 = @lang('messages.yes'), 0 = @lang('messages.no'). Blank keeps the default (yes).</td>
                    </tr>
                    <tr>
                        <td>56</td>
                        <td>Can be stored? <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>1 = @lang('messages.yes'), 0 = @lang('messages.no'). Blank keeps the default (yes).</td>
                    </tr>
                    <tr>
                        <td>57</td>
                        <td>Product Tags <small class="text-muted">(@lang('lang_v1.optional'))</small></td>
                        <td>Comma separated tags.</td>
                    </tr>

                </table>
            @endcomponent
        </div>
    </div>
</section>
<!-- /.content -->

@endsection