src/ApplicationBundle/Resources/views/modals/input_forms/add_expense.html.twig line 1

Open in your IDE?
  1. <!-- Modal -->
  2. {% if not userRestrictions is defined %}
  3.     {% set  userRestrictions=''|getUserRestrictions %}
  4. {% endif %}
  5. <div class="modal fade" id="newExpenseModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  6.     <div class="modal-dialog modal-lg" role="document">
  7.         <form class="form-horizontal addCreatedByDataForm expenseForm" method="post" action="{{ url('add_expense') }}"
  8.               enctype="multipart/form-data">
  10.             <div class="modal-content">
  11.                 <div class="modal-header">
  12.                     <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  13.                         <span aria-hidden="true">&times;</span>
  14.                     </button>
  15.                     <h4 class="modal-title" id="myModalLabel">Add New Expense</h4>
  16.                 </div>
  17.                 <div class="modal-body">
  18.                     <div class="row clearfix">
  19.                         <div class="col-md-6 col-sm-12">
  20.                             <div class="form-group">
  21.                                 <label for="inputEmail3" class="col-sm-4 control-label">Documents</label>
  23.                                 <div class="col-sm-8">
  24.                                     <label class="btn  btn-file ">
  25.                                     <label class="btn  btn-file ">
  26.                                         <i class="fa fa-file"></i>
  27.                                         Upload Images/Documents
  28.                                         <input type="file" class="form-control exp_att_file" name="file[]"
  29.                                                placeholder="File"
  30.                                                id="sig_file"
  31.                                                multiple/>
  32.                                     </label>
  33.                                 </div>
  34.                             </div>
  35.                             <div class="form-group">
  36.                                 <label for="inputEmail3" class="col-sm-4 control-label">Expense Date</label>
  38.                                 <div class="col-sm-8">
  39.                                     <input name="expense_date" type="text" class="form-control add_basic_day_picker"
  40.                                            placeholder="Date" value="{{ ''|date('F d, Y') }}" style=""/>
  41.                                 </div>
  42.                             </div>
  44.                             <div class="form-group">
  45.                                 <label for="inputEmail3" class="col-sm-4 control-label">Expense Type</label>
  47.                                 <div class="col-sm-8">
  48.                                     <select
  49.                                             class="form-control selectize_me  filter_by_this" name="expense_type"
  50.                                             id="expenseModalExpenseType">
  51.                                         {# {% for category in itemgroup %} #}
  53.                                         <option value="0">General</option>
  54.                                         <option value="1">Against Purchase
  55.                                         </option>
  56.                                         <option value="2">Against Sales/Project</option>
  57.                                         <option value="3">Against Sales Lead/Tender</option>
  59.                                         {# {% endfor %} #}
  60.                                     </select>
  61.                                 </div>
  62.                             </div>
  63.                             <div class="form-group" style="display: none;">
  64.                                 <label for="inputEmail3" class="col-sm-4 control-label">Record As</label>
  65.                                 {% set expSubTypes=''|getExpSubTypes %}
  67.                                 <div class="col-sm-8">
  68.                                     <select
  69.                                             class="form-control selectize_me" name="expense_sub_type">
  70.                                         {# {% for category in itemgroup %} #}
  71.                                         {% for g,d in expSubTypes %}
  72.                                             <option value="{{ g }}">{{ d.alias }}</option>
  73.                                         {% endfor %}
  74.                                         {# <option value="2">As Advance</option
  75.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 > #}
  76.                                         {# <option value="3">As Loan</option
  77.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 > #}
  78.                                         {# {% endfor %} #}
  79.                                     </select>
  80.                                 </div>
  81.                             </div>
  82.                             {#                    <div class="form-group"> #}
  83.                             {#                        <label for="inputEmail3" class="col-sm-4 control-label">Expense Sub Type</label> #}
  85.                             {#                        <div class="col-sm-8"> #}
  86.                             {#                            <select class="form-control selectize_me" name="expense_sub_type"> #}
  87.                             {#                                <option value="1">Food</option> #}
  88.                             {#                            </select> #}
  89.                             {#                        </div> #}
  90.                             {#                    </div> #}
  91.                             <div class="form-group">
  92.                                 <label for="inputEmail3" class="col-sm-4 control-label">Amount</label>
  94.                                 <div class="col-sm-8">
  95.                                     <input type="number" name="expense_amount" step="0.01" class="form-control"
  96.                                            id="expense_amount" placeholder="Amount"/>
  97.                                 </div>
  98.                             </div>
  99.                             <div class="form-group filter filter-1">
  100.                                 <label for="inputEmail3" class="col-sm-4 control-label">Advance Amount</label>
  102.                                 <div class="col-sm-8">
  103.                                     <input type="number" name="prev_advance_amount" step="0.01" class="form-control"
  104.                                            id="prev_advance_amount" placeholder="Amount" value="0"/>
  105.                                 </div>
  106.                             </div>
  107.                             <div class="form-group  ">
  108.                                 <label for="inputEmail3" class="col-sm-4 control-label">Expense name and Cost
  109.                                     Centre</label>
  111.                                 <div
  112.                                         class="col-sm-8">
  113.                                     {# {% set head_list=''|GetParentLedgerHeads %} #}
  114.                                     {% set
  115.                                         exp_head_list=''|GetParentLedgerHeads('exp') %}
  116.                                     <select class="form-control selectize_me change_check_narration" name="expense_id"
  117.                                             id="expenseModalExpenseId">
  118.                                         {% for head in exp_head_list %}
  119.                                             <option value="{{ head['id'] }}">{{ head["text"] }}</option>
  121.                                         {% endfor %}
  122.                                     </select>
  123.                                     {% set cc_list=''|GetCostCenterHeads %}
  124.                                     <select class="form-control selectize_me " name="ccId">
  125.                                         <option value="">Select Cost Centre</option>
  126.                                         <option value="0">None</option>
  127.                                         {% for entry in cc_list %}
  128.                                             <option value="{{ entry.id }}">{{ entry.text }}
  129.                                             </option>
  131.                                         {% endfor %}
  132.                                     </select>
  133.                                     <input type="text" name="expense_to_note_0" class="form-control"
  134.                                            placeholder="Notes about this"/>
  135.                                 </div>
  136.                             </div>
  137.                             <div class="form-group filter filter-2">
  138.                                 <label for="inputEmail3" class="col-sm-4 control-label">Sales Order/Project</label>
  140.                                 <div class="col-sm-8">
  141.                                     {#                            {% set so_list=''|SoList %} #}
  142.                                     <select class="form-control change_check_narration soIdExp" name="soId"
  143.                                             id="expenseModalSoId">
  144.                                         {#                                {% for entry in so_list %} #}
  145.                                         {#                                    <option value="{{ entry.salesorderId }}">{{ entry.documentHash }}</option> #}
  147.                                         {#                                {% endfor %} #}
  148.                                     </select>
  149.                                     <input type="text" name="expense_to_note_2" class="form-control"
  150.                                            placeholder="Notes about this"/>
  151.                                 </div>
  152.                             </div>
  153.                             <div class="form-group filter filter-3">
  154.                                 <label for="inputEmail3" class="col-sm-4 control-label">Lead/Bid</label>
  156.                                 <div class="col-sm-8">
  157.                                     {#                            {% set so_list=''|SoList %} #}
  158.                                     <select class="form-control change_check_narration leadIdExp" name="leadId"
  159.                                             id="expenseModalLeadId">
  160.                                         {#                                {% for entry in so_list %} #}
  161.                                         {#                                    <option value="{{ entry.salesorderId }}">{{ entry.documentHash }}</option> #}
  163.                                         {#                                {% endfor %} #}
  164.                                     </select>
  165.                                     <input type="text" name="expense_to_note_3" class="form-control"
  166.                                            placeholder="Notes about this"/>
  167.                                 </div>
  168.                             </div>
  169.                             <div class="form-group filter filter-1">
  170.                                 <label for="inputEmail3" class="col-sm-4 control-label">Purchase Order</label>
  172.                                 <div class="col-sm-8">
  173.                                     {#                            {% set po_list=''|PoList %} #}
  174.                                     <select class="form-control  change_check_narration poIdExp" name="poId"
  175.                                             id="expenseModalPoId">
  177.                                     </select>
  179.                                     <input type="text" name="expense_to_note_1" class="form-control"
  180.                                            placeholder="Notes about this"/>
  181.                                 </div>
  182.                             </div>
  183.                             <div class="form-group filter filter-1">
  184.                                 <label for="inputEmail3" class="col-sm-4 control-label">Invocation Strategy</label>
  186.                                 <div class="col-sm-8">
  188.                                     <select class="form-control selectize_me " name="expenseInvocationStrategyOnGrn">
  190.                                         <option value="1">Previous Received Product(s) if available (same Order)
  191.                                         </option>
  192.                                         <option value="2">Hold for next GRN</option>
  194.                                     </select>
  196.                                 </div>
  197.                             </div>
  198.                             <div class="form-group filter filter-1">
  199.                                 <label for="inputEmail3" class="col-sm-4 control-label">Invocation Type on Received
  200.                                     Items</label>
  202.                                 <div class="col-sm-8">
  204.                                     <select class="form-control selectize_me " name="expenseInvocationTypeOnItems">
  206.                                         <option value="1">Full on Received Products</option>
  207.                                         <option value="2">Weighted on PO amount</option>
  209.                                     </select>
  211.                                 </div>
  212.                             </div>
  213.                             <div class="form-group ">
  214.                                 <label for="inputEmail3" class="col-sm-4 control-label">Balance against head</label>
  216.                                 <div
  217.                                         class="col-sm-8">
  218.                                     {# {% set head_list='pv'|GetParentLedgerHeads('',0) %} #}
  219.                                     {% set
  220.                                         head_list='pv'|GetParentLedgerHeads('') %}
  221.                                     {# {{
  222.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             dump(head_list.found_id)
  223.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           }} #}
  224.                                     {# {{ dump(head_list.DEBIT_HEADS_BY_ID) }} #}
  226.                                     <select class="form-control  expense_change_check_number expenseToBePaidTo childOnly"
  227.                                             name="expense_to_be_paid_to" id="expenseModalToBePaidTo">
  228.                                         {#                                        <option value="">Select</option> #}
  230.                                     </select>
  231.                                     <input type="text" name="expense_from_note" class="form-control"
  232.                                            placeholder="Notes about this"/>
  233.                                 </div>
  234.                             </div>
  235.                             <div class="form-group" style="">
  236.                                 <label for="inputEmail3" class="col-sm-4 control-label">Pay From (optional)</label>
  238.                                 <div class="col-sm-8">
  239.                                     {% set head_list='pv'|GetParentLedgerHeads %}
  241.                                     <select class="form-control selectize_me expense_change_check_number"
  242.                                             name="expense_from"
  243.                                             id="expenseModalPayFrom">
  244.                                         <option value="">Select</option>
  245.                                         {% if head_list.CREDIT_HEADS is defined %}
  246.                                             {% for head in
  247.                                                 head_list.CREDIT_HEADS %}
  248.                                                 <option value="{{ head['id'] }}">{{ head["text"] }}</option>
  250.                                             {% endfor %}
  251.                                         {% endif %}
  252.                                     </select>
  253.                                     {# <input type="text" name="expense_from_note" class="form-control" placeholder="Notes about this"/> #}
  254.                                 </div>
  255.                             </div>
  256.                             <div class="form-group ">
  257.                                 <label for="inputEmail3" class="col-sm-4 control-label">Cheque No.</label>
  259.                                 <div class="col-sm-8">
  261.                                     <select name="check_id" class="form-control" id="expense_check_id"
  262.                                     ></select>
  263.                                 </div>
  264.                             </div>
  265.                             <div class="form-group filter expense_check_number_div">
  266.                                 <label for="inputEmail3" class="col-sm-4 control-label">Check Date</label>
  268.                                 <div class="col-sm-8">
  269.                                     <input type="hidden" name="check_number" class="form-control"
  270.                                            id="expense_check_number_here"
  271.                                            placeholder=""/>
  272.                                     <input name="check_date" type="text" class="form-control add_basic_day_picker"
  273.                                            placeholder="Date" value="{{ ''|date('F d, Y') }}" style=""/>
  276.                                 </div>
  277.                             </div>
  278.                             <div class="form-group filter expense_check_number_div">
  279.                                 <label for="inputEmail3" class="col-sm-4 control-label">Check Narration</label>
  281.                                 <div class="col-sm-8">
  284.                                     <input type="text" name="check_narration" class="form-control"
  285.                                            id="expense_check_narration"
  286.                                            placeholder="Check Narration (default)" value=""/>
  288.                                 </div>
  289.                             </div>
  292.                             <div class="form-group filter filter-default filter-1">
  295.                                 <label for="inputEmail3" class="col-sm-4 control-label"></label>
  297.                                 <div class="col-sm-8">
  298.                                     <div class="checkbox checkbox-styled" bis_skin_checked="1">
  299.                                         <label>
  300.                                             <input type="checkbox" name="auto_balance_1" value="1"
  301.                                                    id="exp_check_auto_balance"
  302.                                                    checked>
  303.                                             <span>Automatically Balance Invoice and Order</span>
  304.                                         </label>
  305.                                     </div>
  306.                                 </div>
  307.                             </div>
  308.                         </div>
  309.                         <div class="col-md-6 col-sm-12">
  310.                             <div class="form-group filter filter-1">
  313.                                 <label for="inputEmail3" class="col-sm-4 control-label">Cost Distribution</label>
  315.                                 <div class="col-sm-8">
  316.                                     <div class="checkbox checkbox-styled" bis_skin_checked="1">
  317.                                         <label>
  318.                                             <input type="checkbox" name="exp_check_expense_distribution_on_product"
  319.                                                    value="1" id="exp_check_expense_distribution_on_product">
  320.                                             <span>Distribute Expense Individually</span>
  321.                                         </label>
  322.                                     </div>
  323.                                 </div>
  324.                             </div>
  325.                             <div class="form-group exp_distribution_on_product_pre_div filter filter-1">
  327.                                 <label for="inputEmail3" class="col-sm-4 control-label">Product</label>
  328.                                 <div class="col-sm-4 ">%</div>
  329.                                 <div class="col-sm-4 ">Amount</div>
  331.                             </div>
  332.                             <div class="form-group exp_distribution_on_product_post_div filter  filter-1">
  334.                                 <label for="inputEmail3" class="col-sm-4 control-label">Total</label>
  335.                                 <div class="col-sm-4 exp_total_distribution_percentage"></div>
  336.                                 <div class="col-sm-4 exp_total_distribution_amount"></div>
  338.                             </div>
  339.                             <div class="form-group ">
  340.                                 <label for="inputEmail3" class="col-sm-4 control-label">Description/Narration</label>
  342.                                 <div
  343.                                         class="col-sm-8 desc_cont">
  346.                                     <textarea name="description" class="form-control attach_ckeditor"
  347.                                               rows="2"></textarea>
  350.                                 </div>
  351.                             </div>
  354.                         </div>
  355.                     </div>
  356.                 </div>
  357.                 <div class="modal-footer">
  358.                     <button type="button" class="btn btn-default" data-dismiss="modal">
  359.                         Close
  360.                     </button>
  361.                     <button type="submit" class="btn btn-primary expenseModalSubmit">Save</button>
  362.                 </div>
  363.             </div>
  364.         </form>
  365.     </div>
  366. </div>
  368. <style>
  370.     #newExpenseModal .form-control.selectize-control {
  371.         border-bottom: 1px solid rgba(12, 12, 12, 0.12);
  372.         height: auto;
  373.         max-height: 31px;
  374.     }
  376.     #newExpenseModal input.form-control {
  378.         font-size: 14px;
  379.         font-weight: bold;
  380.         padding-left: 12px;
  381.     }
  383.     #newExpenseModal .selectize-dropdown,
  384.     #newExpenseModal .selectize-input,
  385.     #newExpenseModal .selectize-input input {
  386.         color: #0c0c0c;
  387.         font-weight: bold;
  388.         font-size: 14px;
  389.     }
  391.     #newExpenseModal .selectize-input.not-full input {
  392.         /*color: #0c0c0c;*/
  393.         /*font-weight: normal;*/
  394.         /*font-size: 14px;*/
  395.     }
  397.     #newExpenseModal .selectize-input.has-items .item {
  398.         line-height: 1;
  399.         height: 14px;
  400.         overflow: hidden;
  401.     }
  403.     #newExpenseModal .selectize-input.has-items .item:hover {
  405.         overflow: visible;
  406.     }
  408.     /*#newExpenseModal .form-control.selectize-control:hover {*/
  409.     /*    border-bottom: 1px solid rgba(12, 12, 12, 0.12);*/
  410.     /*    height: auto;*/
  411.     /*    max-height: unset !important;*/
  412.     /*    min-height: 0px !important;*/
  413.     /*}*/
  415.     @media (min-width: 769px) {
  416.         #newExpenseModal .desc_cont {
  418.             padding-top: 5.5px;
  419.         }
  420.     }
  422. </style>
  423. <script>
  424.     var canSelectAnyHeadForExpenseBalancing ={{ userRestrictions.canSelectAnyHeadForExpenseBalancing is defined?userRestrictions.canSelectAnyHeadForExpenseBalancing:1 }}
  425.     var newExpenseModalSystem =
  426.         {
  427.             modalMode: 'standalone', //or edit
  428.             soSelector: {},
  429.             leadSelector: {},
  430.             checkSelector: {},
  431.             poSelector: {},
  432.             soData: {},
  433.             leadData: {},
  434.             checkData: {},
  435.             poData: {},
  436.             toBeBalancedFromSelector: {},
  437.             headSelector: {},
  438.             toBeBalancedFromSelectorFilterGenerator: function () {
  440.                 if ($('#expenseModalExpenseType').val() == 1) //purchase
  441.                 {
  442.                     var markers = [
  443.                         '_ALL_',
  444.                         // '_CASP_',
  445.                         // '_NCASP_',
  446.                         // '_CLP_',
  447.                         // '_NCLP_',
  448.                         // '_SPAH_',
  449.                         // '_SPAH_',
  450.                     ]
  451.                     return markers.join(',')
  453.                 } else if ($('#expenseModalExpenseType').val() == 2) //sales
  454.                 {
  455.                     var markers = [
  456.                         '_ALL_',
  457.                         // '_CASP_',
  458.                         // '_CLP_',
  459.                         // '_NCLP_',
  460.                         // // '_NCASP_',
  461.                         // '_SPAH_',
  462.                         // '_IPAH_',
  463.                     ]
  464.                     return markers.join(',')
  466.                 } else {
  467.                     var markers = [
  468.                         '_ALL_',
  469.                         // '_CASP_',
  470.                         // // '_NCASP_',
  471.                         // '_CLP_',
  472.                         // '_NCLP_',
  473.                         // '_SPAH_',
  474.                         // '_IPAH_',
  475.                     ]
  476.                     return markers.join(',')
  477.                 }
  479.             },
  480.             refreshDistributedProductListForExpenseBalancing: function () {
  481.                 $('.exp_distribution_row').remove();
  482.                 // alert('here')
  484.                 if (newExpenseModalSystem.poSelector.getValue() == '')
  485.                     newExpenseModalSystem.distributedProductAmountTotalRecalculate();
  487.                 else if ($('#exp_check_expense_distribution_on_product').prop('checked') == true) {
  488.                     var pika_ind_id = '_NONE_'
  489.                     $.ajax({
  490.                         url: BaseURL + "select_data_ajax",
  491.                         type: 'POST',
  492.                         dataType: 'json',
  493.                         // render: {
  494.                         //     option: function (item, escape) {
  495.                         //         return '<div class="p-l-10 p-r-10">'
  496.                         //             + '<h6> #'+escape(item[value])+' ' + escape(item[document_hash]) + ' -- '+ escape(item[lc_number])+'</h6> '
  497.                         //             + '<span>Supplier:' + escape(item[supplier_name]) + '</span> '
  498.                         //             //+ '<span>Name:'+item.name+'</span> '
  499.                         //             //+ '<span>DEBUG:'+item.score+'</span>'
  500.                         //             + '</div>';
  501.                         //     }
  502.                         // },
  503.                         data: {
  504.                             //returnJson: 1,
  505.                             //sessionData: sessionData
  506.                             query: '_EMPTY_',
  507.                             tableName: "purchase_order_item",
  508.                             valueField: "id",
  509.                             textField: "rendered_text",
  510.                             entity_group: 0,
  511.                             selectorId: '_NONE_',
  512.                             isMultiple: 0,
  513.                             dataId: pika_ind_id,
  516. //
  517.                             renderTextFormat: "#__product_name__ ",
  518.                             andConditions: [],
  519.                             andOrConditions: [
  520.                                 // // {type: "=", field: "supplier_id", value: isNaN(query) ? '' : query},
  521.                                 // {type: "=", field: "purchase_order_id", value: isNaN(query) ? '' : query},
  522.                                 // {type: "like", field: "document_hash", value: query},
  523.                                 // {type: "like", field: "acc_suppliers_0.supplier_name", value: query},
  524.                                 // {type: "like", field: "lc_number", value: query},
  525.                             ],
  526.                             mustConditions: [
  528.                                 {
  529.                                     type: "=",
  530.                                     field: "purchase_order_id",
  531.                                     value: newExpenseModalSystem.poSelector.getValue()
  532.                                 },
  535.                             ],
  536.                             joinTableData: [
  539.                                 {
  540.                                     tableName: "inv_products",
  541.                                     joinFieldPrimary: "product_id",
  542.                                     joinOn: 'id',
  543.                                     tableJoinType: 'left join',
  544.                                     // fieldJoinType: '=',
  545.                                     selectPrefix: 'product_',
  546.                                     selectFieldList: [
  547.                                         'name'
  549.                                     ]
  550.                                 },
  551.                                 {
  552.                                     tableName: "acc_service",
  553.                                     joinFieldPrimary: "service_id",
  554.                                     joinOn: 'service_id',
  555.                                     tableJoinType: 'left join',
  556.                                     // fieldJoinType: '=',
  557.                                     // selectPrefix: 'supplier_',
  558.                                     selectFieldList: [
  559.                                         'service_name'
  561.                                     ]
  562.                                 },
  565.                             ],
  566.                             convertToObject: [
  567. //                            'accessories', 'issues'
  568.                             ],
  569.                             skipDefaultCompanyId: 1
  570.                             // setDataForSingle: 1,
  572.                         },
  573.                         error: function () {
  574.                             // callback();
  575.                         },
  576.                         success: function (res) {
  579.                             for (var exp_j = 0; exp_j < res.data.length; exp_j++) {
  581.                                 var productName = res.data[exp_j].product_name;
  582.                                 var poItemId = res.data[exp_j].id;
  584.                                 var toAddStr = '<div class="form-group filter exp_distribution_row">' +
  585.                                     '<label for="inputEmail3" class="col-sm-4 control-label">' + productName + '</label>' +
  586.                                     '<div class="col-sm-4">' +
  589.                                     '<input type="number" ' +
  590.                                     'name="exp_distribution_percentage[]" ' +
  591.                                     'class="form-control exp_distribution_percentage exp_distribution_percentage' + poItemId + '" ' +
  592.                                     'data-id="' + poItemId + '"' +
  593.                                     'id="exp_distribution_percentage' + poItemId + '" ' +
  594.                                     'value=""/>' +
  596.                                     '</div>' +
  598.                                     '<div class="col-sm-4">' +
  600.                                     '<input type="hidden" ' +
  601.                                     'name="exp_distribution_poitemId[]" ' +
  602.                                     'class="form-control exp_distribution_poitemId exp_distribution_poitemId' + poItemId + '" ' +
  603.                                     'data-id="' + poItemId + '"' +
  604.                                     'id="exp_distribution_poitemId' + poItemId + '" ' +
  605.                                     'value="' + poItemId + '"/>' +
  607.                                     '<input type="number" ' +
  608.                                     'name="exp_distribution_amount[]" ' +
  609.                                     'class="form-control exp_distribution_amount exp_distribution_amount' + poItemId + '" ' +
  610.                                     'data-id="' + poItemId + '"' +
  611.                                     'id="exp_distribution_amount' + poItemId + '" ' +
  612.                                     'value=""/>' +
  614.                                     '</div>' +
  615.                                     '</div>';
  617.                                 $('.exp_distribution_on_product_pre_div').after(toAddStr);
  620.                             }
  621.                             newExpenseModalSystem.distributedProductAmountTotalRecalculate();
  623.                         }
  624.                     });
  627.                 } else
  628.                     newExpenseModalSystem.distributedProductAmountTotalRecalculate();
  631.             },
  632.             distributedProductAmountTotalRecalculate: function (changeExpAmount) {
  633.                 changeExpAmount = changeExpAmount || 0
  635.                 var total_distribution_percentage = 0;
  636.                 var total_distribution_amount = 0;
  638.                 $('.exp_distribution_percentage').each(function (ind_exp, elem) {
  639.                     if (elem.val() != '')
  640.                         total_distribution_percentage += (1 * elem.val());
  642.                 })
  643.                 $('.exp_distribution_amount').each(function (ind_exp, elem) {
  644.                     if (elem.val() != '')
  645.                         total_distribution_amount += (1 * elem.val());
  647.                 })
  648.                 $('.exp_total_distribution_amount').text(total_distribution_amount.toFixed(2));
  649.                 if (changeExpAmount == 1)
  650.                     $('#expense_amount').val(total_distribution_amount.toFixed(2));
  651.                 $('.exp_total_distribution_percentage').text(total_distribution_percentage.toFixed(2));
  654.             },
  655.             checkAndAddExpenseDataToList: function () {
  658.                 var validated = true;
  661.                 if (validated == true)
  662.                     addExpenseRow();
  665.             },
  666.             triggerExpenseModal: function (config) {
  668.                 config = config || {
  669.                     soItemFound: 0,
  670.                     soItemDelivered: 0,
  671.                     id: 0,
  672.                     alias: '',
  673.                     note: '',
  674.                     unit: 0,
  675.                     warranty: 0,
  676.                     unitTypeId: 0,
  677.                     unit_price: 0,
  678.                     fdm: '',
  679.                     product_name: '',
  680.                     soItemId: 0,
  681.                     total_price: 0,
  682.                     isForeignItem: isForeignItem,
  683.                     isSegment: isSegment,
  684.                 };
  686.                 var dataRow =
  687.                     {
  688.                         currencyId: 0,
  689.                         currencyMultiplyRate: 1,
  690.                         currencyText: '',
  691.                         scope: '',   //scope type 0/null/1 is own 2: V3endor 3:entity 4 :others
  692.                         scopeHolderId: '',   //Supplier Id or APp Id
  694.                         scopeHolderName: '',   //
  695.                         scopeDescription: '',   //
  697.                     }
  700.                 $.each(config, function (key, valueObj) {
  701.                     dataRow[key] = valueObj;
  702.                 });
  704.                 // if (typeof dataRow.isSegment !== 'undefined')
  705.                 //     isSegment = dataRow.isSegment;
  707.                 ///populate data here
  710.                 //then trigger modal
  713.                 $('#newExpenseModal').modal('show');
  716.             },
  717.         }
  719.     const toBase64 = file => new Promise((resolve, reject) => {
  720.         const reader = new FileReader();
  721.         reader.readAsDataURL(file);
  722.         reader.onload = () => resolve(reader.result);
  723.         reader.onerror = reject;
  724.     });
  727.     // function toDataURL(url, callback) {
  728.     //     var xhr = new XMLHttpRequest();
  729.     //     xhr.onload = function() {
  730.     //         var reader = new FileReader();
  731.     //         reader.onloadend = function() {
  732.     //             callback(reader.result);
  733.     //         }
  734.     //         reader.readAsDataURL(xhr.response);
  735.     //     };
  736.     //     xhr.open('GET', url);
  737.     //     xhr.responseType = 'blob';
  738.     //     xhr.send();
  739.     // }
  740.     //
  741.     // toDataURL('https://www.gravatar.com/avatar/d50c83cc0c6523b4d3f6085295c953e0', function(dataUrl) {
  742.     //     console.log('RESULT:', dataUrl)
  743.     // })
  744.     const edenAiUrl = "https://api.edenai.run/v2/workflow/4261f761-07b5-4ee3-b81e-a55733a81e8c/execution/";
  745.     const edenAiUrlDirect = "https://api.edenai.run/v2/ocr/financial_parser";
  746.     const edenApiKey = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjoiNDIwZTEwNDktOTFjNC00YzZhLWJhNjEtZDk3MDhjZWI4MjFjIiwidHlwZSI6ImFwaV90b2tlbiJ9.IXXp0DsFHyCrtkY0Ck1M9CQkXH8ZxCOfVs4lpHhOy2s"; // Replace with your actual API key
  747.     var executionDetailsUrl = '';
  748.     var edenAiExecutionId = 0;
  749.     var edenAiRowIdByExecutionId = {};
  751.     var parseDataPending = [
  752.         //{rowId :1,filepath:''}
  754.     ];
  755.     var exp_head_list ={{ exp_head_list|json_encode|raw }};
  757.     function nextParseOcr() {
  758.         if (parseDataPending.length > 0) {
  759.             initiateOcr()
  760.         }
  762.     }
  765.     function initiateOcr(selectorId, fileIndex, refRowId, fileUrl) {
  767.         refRowId = refRowId || '_NONE_';
  768.         fileIndex = fileIndex || 0;
  769.         fileUrl = fileUrl || '';
  771.         fileUrl = '{{ absolute_url(path('dashboard')) }}' + parseDataPending[0]['filePath']
  773.         const options = {
  774.             method: 'POST',
  775.             headers: {
  776.                 accept: 'application/json',
  777.                 'content-type': 'application/json',
  778.                 authorization: `Bearer ${edenApiKey}`
  779.             },
  780.             body: JSON.stringify({
  781.                 response_as_dict: false,
  782.                 attributes_as_list: false,
  783.                 show_base_64: false,
  784.                 show_original_response: false,
  785.                 document_type: 'invoice',
  786.                 convert_to_pdf: false,
  787.                 file_url: fileUrl,
  788.                 // providers: ['google'],
  789.                 providers: ['amazon'],
  790.                 language: 'en'
  791.             })
  792.         };
  793.         // const payload = { file: fileData }; // Replace with actual file data
  794.         fetch('https://api.edenai.run/v2/ocr/financial_parser', options)
  795.             .then(res => res.json())
  796.             .then(res => {
  797.                 console.log(res)
  798.                 if (newExpenseModalSystem.modalMode == 'standalone') {
  799.                     $('#newExpenseModal .trigger_ckeditor').html(
  800.                         '<p><b>Merchant Name:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.name + '</p>' +
  801.                         '<p><b>Merchant Address:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.address + '</p>' +
  802.                         '<p><b>Merchant Phone:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.phone + '</p>'
  803.                     );
  805.                     $('#newExpenseModal textarea').val(
  806.                         '<p><b>Merchant Name:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.name + '</p>' +
  807.                         '<p><b>Merchant Address:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.address + '</p>' +
  808.                         '<p><b>Merchant Phone:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.phone + '</p>'
  809.                     );
  811.                     $('#newExpenseModal #expense_amount').val(
  812.                         1 * (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].payment_information.amount_due) +
  813.                         1 * (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].payment_information.total_tax)
  814.                     )
  815.                     if (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].document_metadata.document_type == 'restaurant_statement') {
  816.                         for (var hopo = 0; hopo < exp_head_list.length; hopo++) {
  817.                             if ((exp_head_list[hopo]['text']).search(/food/i) != -1) {
  819.                                 newExpenseModalSystem.headSelector.setValue(exp_head_list[hopo]['id'])
  821.                             }
  822.                         }
  823.                     }
  824.                 } else {
  827.                     if (parseDataPending.length > 0) {
  828.                         populateExpRowBasedOnOcr(res[0].extracted_data[0], parseDataPending[0]['rowId'])
  829.                         parseDataPending.shift(); // removes the first element, which is 1
  831.                     }
  832.                     if (parseDataPending.length > 0) {
  834.                         nextParseOcr()
  835.                         // console.log(parseDataPending);
  836.                     }
  837.                 }
  839.             })
  840.             .catch(err => console.error(err));
  843.     }
  845.     function parseOcr(ffEdenAiExecutionId) {
  847.         // const payload = { file: fileData }; // Replace with actual file data
  850.         (async () => {
  851.             try {
  852.                 const ggExecutionDetailsUrl = `https://api.edenai.run/v2/workflow/4261f761-07b5-4ee3-b81e-a55733a81e8c/execution/${ffEdenAiExecutionId}/`
  853.                 const detailsResponse = await fetch(ggExecutionDetailsUrl, {
  854.                     headers: {
  855.                         "Content-Type": "application/json",
  856.                         // 'Authorization': `Bearer ${edenApiKey}`
  857.                         'Authorization': `Bearer ${edenApiKey}`
  858.                     },
  859.                 });
  860.                 const executionData = await detailsResponse.json();
  862.                 // Process the execution details (detailsData) here
  863.                 console.log(executionData);
  864.                 var ggEdenAiExecutionId = executionData.id;
  866.                 if (typeof executionData.content !== 'undefined') {
  867.                     if (executionData.content.status == 'running') {
  868.                         setTimeout(function () {
  869.                             parseOcr(ggEdenAiExecutionId);
  870.                         }, 2000);
  872.                     } else if (executionData.content.status == 'success') {
  873.                         if (newExpenseModalSystem.modalMode == 'standalone') {
  874.                             $('#newExpenseModal .trigger_ckeditor').html(
  875.                                 '<p><b>Merchant Name:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.name + '</p>' +
  876.                                 '<p><b>Merchant Address:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.address + '</p>' +
  877.                                 '<p><b>Merchant Phone:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.phone + '</p>'
  878.                             );
  880.                             $('#newExpenseModal textarea').val(
  881.                                 '<p><b>Merchant Name:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.name + '</p>' +
  882.                                 '<p><b>Merchant Address:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.address + '</p>' +
  883.                                 '<p><b>Merchant Phone:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.phone + '</p>'
  884.                             );
  886.                             $('#newExpenseModal #expense_amount').val(
  887.                                 1 * (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].payment_information.amount_due) +
  888.                                 1 * (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].payment_information.total_tax)
  889.                             )
  890.                             if (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].document_metadata.document_type == 'restaurant_statement') {
  891.                                 for (var hopo = 0; hopo < exp_head_list.length; hopo++) {
  892.                                     if ((exp_head_list[hopo]['text']).search(/food/i) != -1) {
  894.                                         newExpenseModalSystem.headSelector.setValue(exp_head_list[hopo]['id'])
  896.                                     }
  897.                                 }
  898.                             }
  899.                         } else {
  900.                             populateExpRowBasedOnOcr(executionData.content.results.ocr__financial_parser.results[0].extracted_data[0], ggEdenAiExecutionId)
  901.                         }
  904.                     } else {
  907.                     }
  908.                 }
  911.             } catch (error) {
  912.                 console.error("Error:", error);
  913.             }
  914.         })();
  915.     }
  917.     function initiateOcrBackup(selectorId, fileIndex, refRowId, fileUrl) {
  918.         refRowId = refRowId || '_NONE_';
  919.         fileIndex = fileIndex || 0;
  920.         fileUrl = fileUrl || '';
  922.         // const payload = { file: fileData }; // Replace with actual file data
  925.         (async () => {
  926.             try {
  927.                 const options = {
  928.                     method: 'POST',
  929.                     headers: {
  930.                         accept: 'application/json',
  931.                         'content-type': 'application/json',
  932.                         authorization: `Bearer ${edenApiKey}`
  933.                     },
  934.                     body: JSON.stringify({
  935.                         response_as_dict: false,
  936.                         document_type: 'auto-detect',
  937.                         file_url: fileUrl,
  938.                         language: 'en'
  939.                     })
  940.                 };
  941.                 // const options = {
  942.                 //     method: 'POST',
  943.                 //     headers: {
  944.                 //         accept: 'application/json',
  945.                 //         'content-type': 'application/json',
  946.                 //         authorization: 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjoiNDIwZTEwNDktOTFjNC00YzZhLWJhNjEtZDk3MDhjZWI4MjFjIiwidHlwZSI6ImFwaV90b2tlbiJ9.IXXp0DsFHyCrtkY0Ck1M9CQkXH8ZxCOfVs4lpHhOy2s'
  947.                 //     },
  948.                 //     body: JSON.stringify({
  949.                 //         response_as_dict: true,
  950.                 //         attributes_as_list: false,
  951.                 //         show_base_64: true,
  952.                 //         show_original_response: false,
  953.                 //         document_type: 'invoice',
  954.                 //         convert_to_pdf: false,
  955.                 //         file_url: 'https://www.ourhoneybee.xyz/uploads/ExpenseInvoice/dc561ca5db4b674f67dacf5eb523832d.png',
  956.                 //         providers: ['google'],
  957.                 //         language: 'en'
  958.                 //     })
  959.                 // };
  960.                 //
  961.                 // fetch('https://api.edenai.run/v2/ocr/financial_parser', options)
  962.                 //     .then(res => res.json())
  963.                 //     .then(res => console.log(res))
  964.                 //     .catch(err => console.error(err));
  965.                 console.log(fileUrl)
  967.                 const responseInit = await fetch(edenAiUrl, options);
  970.                 // //formdata_start
  971.                 //
  972.                 // const formData = new FormData();
  973.                 // // formData.append('file', document.getElementById(selectorId).files[fileIndex]);
  974.                 // formData.append('refRowId', refRowId);
  975.                 // formData.append('file_url', fileUrl);
  976.                 // formData.append('language', 'en');
  977.                 //
  978.                 // console.log(fileUrl)
  979.                 //
  980.                 // const headers = {
  981.                 //     'Authorization': `Bearer ${edenApiKey}`
  982.                 // };
  983.                 //
  984.                 // const responseInit = await fetch(edenAiUrl, {
  985.                 //     method: 'POST',
  986.                 //     headers: headers,
  987.                 //     body: formData
  988.                 // });
  989.                 //
  990.                 // //form_data_end
  993.                 const executionData = await responseInit.json();
  994.                 console.log(executionData)
  996.                 // Retrieve the execution ID from the response data
  998.                 edenAiExecutionId = executionData.id;
  999.                 var ggEdenAiExecutionId = executionData.id;
  1000.                 edenAiRowIdByExecutionId[edenAiExecutionId] = refRowId;
  1001.                 executionDetailsUrl = `https://api.edenai.run/v2/workflow/4261f761-07b5-4ee3-b81e-a55733a81e8c/execution/${edenAiExecutionId}/`
  1003.                 if (typeof executionData.content !== 'undefined') {
  1004.                     if (executionData.content.status == 'running') {
  1005.                         setTimeout(function () {
  1006.                             parseOcr(ggEdenAiExecutionId);
  1007.                         }, 2000);
  1009.                     } else if (executionData.content.status == 'success') {
  1010.                         if (newExpenseModalSystem.modalMode == 'standalone') {
  1011.                             $('#newExpenseModal .trigger_ckeditor').html(
  1012.                                 '<p><b>Merchant Name:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.name + '</p>' +
  1013.                                 '<p><b>Merchant Address:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.address + '</p>' +
  1014.                                 '<p><b>Merchant Phone:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.phone + '</p>'
  1015.                             );
  1017.                             $('#newExpenseModal textarea').val(
  1018.                                 '<p><b>Merchant Name:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.name + '</p>' +
  1019.                                 '<p><b>Merchant Address:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.address + '</p>' +
  1020.                                 '<p><b>Merchant Phone:</b> ' + executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].merchant_information.phone + '</p>'
  1021.                             );
  1023.                             $('#newExpenseModal #expense_amount').val(
  1024.                                 1 * (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].payment_information.amount_due) +
  1025.                                 1 * (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].payment_information.total_tax)
  1026.                             )
  1027.                             if (executionData.content.results.ocr__financial_parser.results[0].extracted_data[0].document_metadata.document_type == 'restaurant_statement') {
  1028.                                 for (var hopo = 0; hopo < exp_head_list.length; hopo++) {
  1029.                                     if ((exp_head_list[hopo]['text']).search(/food/i) != -1) {
  1031.                                         newExpenseModalSystem.headSelector.setValue(exp_head_list[hopo]['id'])
  1033.                                     }
  1034.                                 }
  1035.                             }
  1036.                         } else {
  1037.                             populateExpRowBasedOnOcr(executionData.content.results.ocr__financial_parser.results[0].extracted_data[0], ggEdenAiExecutionId)
  1038.                         }
  1041.                     } else {
  1044.                     }
  1045.                 }
  1048.             } catch (error) {
  1049.                 console.error("Error:", error);
  1050.             }
  1051.         })();
  1052.     }
  1054.     async function triggerOcr(selectorIdWithHash) {
  1055.         const file = document.querySelector(selectorIdWithHash).files[0];
  1058.         const base64String = await toBase64(file);
  1060.         // Now you can use the base64String
  1061.         console.log(base64String);
  1062.         initiateOcr(base64String)
  1065.     }
  1068.     $(document).ready(function () {
  1070.         newExpenseModalSystem.soSelector = $('#newExpenseModal .soIdExp').selectize({
  1071.             placeholder: 'Choose a project or Order',
  1072.             multiple: false,
  1073. //            options: APTL.productListArray,
  1074.             options: [],
  1075.             valueField: 'value',
  1076.             labelField: 'text',
  1078.             preload: 'focus',
  1080.             searchField: ['text', 'value'],
  1081.             load: function (query, callback) {
  1082. //                        if (!query.length) return // callback();
  1083.                 if (!query.length) query = '_EMPTY_';
  1085.                 var pika_ind_id = $($(this)[0].$input["0"]).attr('data-id')
  1086.                 $.ajax({
  1087.                     url: BaseURL + "select_data_ajax",
  1088.                     type: 'POST',
  1089.                     dataType: 'json',
  1090.                     data: {
  1091.                         //returnJson: 1,
  1092.                         //sessionData: sessionData
  1093.                         query: query,
  1094.                         tableName: "sales_order",
  1095.                         valueField: "sales_order_id",
  1096.                         textField: "rendered_text",
  1097.                         entity_group: 0,
  1098.                         selectorId: $($(this)[0].$input["0"]).attr('id'),
  1099.                         isMultiple: 0,
  1100.                         dataId: pika_ind_id,
  1103. //                        isMultiple: 0,
  1105.                         //textField: "rendered_text",
  1106. //
  1107.                         renderTextFormat: "#__value__ __document_hash__ ( __client_name__ ) -  __project_name__",
  1108.                         andConditions: [],
  1109.                         andOrConditions: [
  1110.                             {type: "=", field: "approved", value: 1},
  1112.                         ],
  1113.                         mustConditions: [
  1115.                             {type: "=", field: "approved", value: 1},
  1118.                         ],
  1119.                         joinTableData: [
  1122.                             {
  1123.                                 tableName: "project",
  1124.                                 joinFieldPrimary: "project_id",
  1125.                                 joinOn: 'project_id',
  1126.                                 tableJoinType: 'left join',
  1127.                                 // fieldJoinType: '=',
  1128.                                 // selectPrefix: '',
  1129.                                 selectFieldList: [
  1130.                                     'project_name', 'sales_project_asset_head_id', 'internal_project_asset_head_id'
  1132.                                 ]
  1133.                             },
  1135.                             {
  1136.                                 tableName: "acc_clients",
  1137.                                 joinFieldPrimary: "client_id",
  1138.                                 joinOn: 'client_id',
  1139.                                 tableJoinType: 'join',
  1140.                                 // fieldJoinType: '=',
  1141.                                 // selectPrefix: 'client_',
  1142.                                 selectFieldList: [
  1143.                                     'client_name'
  1145.                                 ]
  1146.                             },
  1147.                         ],
  1148.                         convertToObject: [
  1149. //                            'accessories', 'issues'
  1150.                         ],
  1151.                         skipDefaultCompanyId: 1,
  1152.                         itemLimit: '_ALL_'
  1153.                         // setDataForSingle: 1,
  1155.                     },
  1156.                     error: function () {
  1157.                         // callback();
  1158.                     },
  1159.                     success: function (res) {
  1161.                         newExpenseModalSystem.soData = res.dataById
  1163.                         callback(res.data);
  1166.                         if (res.setValueArray.length != 0 && res.selectorId != '') {
  1167.                             if (res.isMultiple == 1)
  1168.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValueArray)
  1169.                             else
  1170.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValue)
  1171.                         }
  1173. //                        alert('pika master')
  1175.                     }
  1176.                 });
  1177.             },
  1179.             onChange: function (value) {
  1180. //                alert(value )
  1181. //                newExpenseModalSystem.toBeBalancedFromSelector.setValue('')
  1182. //                if(!value.length)return;
  1183. ////                alert(newExpenseModalSystem.soData[value].sales_project_asset_head_id )
  1184. //                if(newExpenseModalSystem.soData[value].sales_project_asset_head_id !=null && newExpenseModalSystem.soData[value].sales_project_asset_head_id !='') {
  1185. ////                    alert('here')
  1186. //                    populateAndSetSelectByAjaxSelector(newExpenseModalSystem.toBeBalancedFromSelector, [newExpenseModalSystem.soData[value].sales_project_asset_head_id])
  1187. //                }
  1188. //                else if(newExpenseModalSystem.soData[value].internal_project_asset_head_id !=null && newExpenseModalSystem.soData[value].internal_project_asset_head_id !='')
  1189. //                    populateAndSetSelectByAjaxSelector(newExpenseModalSystem.toBeBalancedFromSelector, [newExpenseModalSystem.soData[value].internal_project_asset_head_id]);
  1191.             }
  1193.         })[0].selectize;
  1194.         newExpenseModalSystem.leadSelector = $('#newExpenseModal .leadIdExp').selectize({
  1195.             placeholder: 'Choose a Lead/Bid/tender',
  1196.             multiple: false,
  1197. //            options: APTL.productListArray,
  1198.             options: [],
  1199.             valueField: 'value',
  1200.             labelField: 'text',
  1202.             preload: 'focus',
  1204.             searchField: ['text', 'value'],
  1205.             load: function (query, callback) {
  1206. //                        if (!query.length) return // callback();
  1207.                 if (!query.length) query = '_EMPTY_';
  1209.                 var pika_ind_id = $($(this)[0].$input["0"]).attr('data-id')
  1210.                 $.ajax({
  1211.                     url: BaseURL + "select_data_ajax",
  1212.                     type: 'POST',
  1213.                     dataType: 'json',
  1214.                     data: {
  1215.                         //returnJson: 1,
  1216.                         //sessionData: sessionData
  1217.                         query: query,
  1218.                         tableName: "sales_lead",
  1219.                         valueField: "lead_id",
  1220.                         textField: "rendered_text",
  1221.                         entity_group: 0,
  1222.                         selectorId: $($(this)[0].$input["0"]).attr('id'),
  1223.                         isMultiple: 0,
  1224.                         dataId: pika_ind_id,
  1227. //                        isMultiple: 0,
  1229.                         //textField: "rendered_text",
  1230. //
  1231.                         renderTextFormat: "#__value__ __document_hash__ - Bid: __bid_number__",
  1232.                         andConditions: [],
  1233.                         andOrConditions: [
  1234.                             {type: "=", field: "approved", value: 1},
  1236.                         ],
  1237.                         mustConditions: [
  1239.                             {type: "=", field: "approved", value: 1},
  1242.                         ],
  1243.                         joinTableData: [
  1245.                             //
  1246.                             // {
  1247.                             //     tableName: "project",
  1248.                             //     joinFieldPrimary: "project_id",
  1249.                             //     joinOn: 'project_id',
  1250.                             //     tableJoinType: 'left join',
  1251.                             //     // fieldJoinType: '=',
  1252.                             //     // selectPrefix: '',
  1253.                             //     selectFieldList: [
  1254.                             //         'project_name', 'sales_project_asset_head_id', 'internal_project_asset_head_id'
  1255.                             //
  1256.                             //     ]
  1257.                             // },
  1258.                             //
  1259.                             // {
  1260.                             //     tableName: "acc_clients",
  1261.                             //     joinFieldPrimary: "client_id",
  1262.                             //     joinOn: 'client_id',
  1263.                             //     tableJoinType: 'join',
  1264.                             //     // fieldJoinType: '=',
  1265.                             //     // selectPrefix: 'client_',
  1266.                             //     selectFieldList: [
  1267.                             //         'client_name'
  1268.                             //
  1269.                             //     ]
  1270.                             // },
  1271.                         ],
  1272.                         convertToObject: [
  1273. //                            'accessories', 'issues'
  1274.                         ],
  1275.                         skipDefaultCompanyId: 1,
  1276.                         itemLimit: '_ALL_'
  1277.                         // setDataForSingle: 1,
  1279.                     },
  1280.                     error: function () {
  1281.                         // callback();
  1282.                     },
  1283.                     success: function (res) {
  1285.                         newExpenseModalSystem.leadData = res.dataById
  1287.                         callback(res.data);
  1290.                         if (res.setValueArray.length != 0 && res.selectorId != '') {
  1291.                             if (res.isMultiple == 1)
  1292.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValueArray)
  1293.                             else
  1294.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValue)
  1295.                         }
  1297. //                        alert('pika master')
  1299.                     }
  1300.                 });
  1301.             },
  1303.             onChange: function (value) {
  1304. //                alert(value )
  1305. //                newExpenseModalSystem.toBeBalancedFromSelector.setValue('')
  1306. //                if(!value.length)return;
  1307. ////                alert(newExpenseModalSystem.soData[value].sales_project_asset_head_id )
  1308. //                if(newExpenseModalSystem.soData[value].sales_project_asset_head_id !=null && newExpenseModalSystem.soData[value].sales_project_asset_head_id !='') {
  1309. ////                    alert('here')
  1310. //                    populateAndSetSelectByAjaxSelector(newExpenseModalSystem.toBeBalancedFromSelector, [newExpenseModalSystem.soData[value].sales_project_asset_head_id])
  1311. //                }
  1312. //                else if(newExpenseModalSystem.soData[value].internal_project_asset_head_id !=null && newExpenseModalSystem.soData[value].internal_project_asset_head_id !='')
  1313. //                    populateAndSetSelectByAjaxSelector(newExpenseModalSystem.toBeBalancedFromSelector, [newExpenseModalSystem.soData[value].internal_project_asset_head_id]);
  1315.             }
  1317.         })[0].selectize;
  1318.         newExpenseModalSystem.modalMode = typeof expenseModalMode !== 'undefined' ? expenseModalMode : 'standalone';
  1319.         newExpenseModalSystem.poSelector = $('#newExpenseModal .poIdExp').selectize({
  1320.             placeholder: 'Choose an Order',
  1321.             multiple: false,
  1322. //            options: APTL.productListArray,
  1323.             options: [],
  1324.             valueField: 'value',
  1325.             labelField: 'text',
  1326.             preload: 'focus',
  1328.             searchField: ['text', 'value', 'lc_number', 'supplier_name'],
  1329.             load: function (query, callback) {
  1330. //                        if (!query.length) return // callback();
  1331.                 if (!query.length) query = '_EMPTY_';
  1333.                 var pika_ind_id = $($(this)[0].$input["0"]).attr('data-id')
  1334.                 $.ajax({
  1335.                     url: BaseURL + "select_data_ajax",
  1336.                     type: 'POST',
  1337.                     dataType: 'json',
  1338.                     // render: {
  1339.                     //     option: function (item, escape) {
  1340.                     //         return '<div class="p-l-10 p-r-10">'
  1341.                     //             + '<h6> #'+escape(item[value])+' ' + escape(item[document_hash]) + ' -- '+ escape(item[lc_number])+'</h6> '
  1342.                     //             + '<span>Supplier:' + escape(item[supplier_name]) + '</span> '
  1343.                     //             //+ '<span>Name:'+item.name+'</span> '
  1344.                     //             //+ '<span>DEBUG:'+item.score+'</span>'
  1345.                     //             + '</div>';
  1346.                     //     }
  1347.                     // },
  1348.                     data: {
  1349.                         //returnJson: 1,
  1350.                         //sessionData: sessionData
  1351.                         query: query,
  1352.                         tableName: "purchase_order",
  1353.                         valueField: "purchase_order_id",
  1354.                         textField: "rendered_text",
  1355.                         entity_group: 0,
  1356.                         selectorId: $($(this)[0].$input["0"]).attr('id'),
  1357.                         isMultiple: 0,
  1358.                         dataId: pika_ind_id,
  1361. //
  1362.                         renderTextFormat: "#__value__ __document_hash__ ( __supplier_name__ ) -- __lc_number__",
  1363.                         andConditions: [],
  1364.                         andOrConditions: [
  1365.                             // {type: "=", field: "supplier_id", value: isNaN(query) ? '' : query},
  1366.                             {type: "=", field: "purchase_order_id", value: isNaN(query) ? '' : query},
  1367.                             {type: "like", field: "document_hash", value: query},
  1368.                             {type: "like", field: "acc_suppliers_0.supplier_name", value: query},
  1369.                             {type: "like", field: "lc_number", value: query},
  1370.                         ],
  1371.                         mustConditions: [
  1373.                             {type: "=", field: "approved", value: 1},
  1376.                         ],
  1377.                         joinTableData: [
  1380.                             {
  1381.                                 tableName: "acc_suppliers",
  1382.                                 joinFieldPrimary: "supplier_id",
  1383.                                 joinOn: 'supplier_id',
  1384.                                 tableJoinType: 'left join',
  1385.                                 // fieldJoinType: '=',
  1386.                                 // selectPrefix: 'supplier_',
  1387.                                 selectFieldList: [
  1388.                                     'supplier_name'
  1390.                                 ]
  1391.                             },
  1394.                         ],
  1395.                         convertToObject: [
  1396. //                            'accessories', 'issues'
  1397.                         ],
  1398.                         skipDefaultCompanyId: 1
  1399.                         // setDataForSingle: 1,
  1401.                     },
  1402.                     error: function () {
  1403.                         // callback();
  1404.                     },
  1405.                     success: function (res) {
  1408.                         callback(res.data);
  1411.                         if (res.setValueArray.length != 0 && res.selectorId != '') {
  1412.                             if (res.isMultiple == 1)
  1413.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValueArray)
  1414.                             else
  1415.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValue)
  1416.                         }
  1417. //                        alert('pika master')
  1419.                     }
  1420.                 });
  1421.             },
  1423.             onChange: function (value) {
  1424.                 newExpenseModalSystem.refreshDistributedProductListForExpenseBalancing()
  1426.             }
  1428.         })[0].selectize;
  1429.         newExpenseModalSystem.headSelector = $('#newExpenseModal #expenseModalExpenseId').selectize({})[0].selectize;
  1431.         $(document).on('change', '#exp_check_expense_distribution_on_product', function () {
  1433.             newExpenseModalSystem.refreshDistributedProductListForExpenseBalancing();
  1435.         });
  1436.         $(document).on('change', '.exp_distribution_percentage', function () {
  1437.             var this_data_id = $(this).data('id');
  1438.             if ($(this).val() == '') $(this).val(0)
  1439.             if ($('#expense_amount').val() == '') $('#expense_amount').val(0)
  1440.             $('.exp_distribution_amount' + this_data_id).val(($('#expense_amount').val() * $(this).val() / 100).toFixed(2));
  1441.             newExpenseModalSystem.distributedProductAmountTotalRecalculate();
  1443.         })
  1444.         $(document).on('change', '.exp_distribution_amount', function () {
  1445.             var this_data_id = $(this).data('id');
  1446.             if ($(this).val() == '') $(this).val(0)
  1447.             if ($('#expense_amount').val() == '') $('#expense_amount').val(0)
  1448.             if ($('#expense_amount').val() != 0)
  1449.                 $('.exp_distribution_percentage' + this_data_id).val((($(this).val() * 100) / ($('#expense_amount').val())).toFixed(2));
  1450.             else
  1451.                 $('.exp_distribution_percentage' + this_data_id).val((0).toFixed(2));
  1452.             newExpenseModalSystem.distributedProductAmountTotalRecalculate(1);
  1454.         })
  1456.         if (canSelectAnyHeadForExpenseBalancing == 1) {
  1458.             newExpenseModalSystem.toBeBalancedFromSelector = update_head_selectors('#newExpenseModal .expenseToBePaidTo', {
  1460.                 markerHash: newExpenseModalSystem.toBeBalancedFromSelectorFilterGenerator(),
  1461.                 // markerHash: '_AEMP_',
  1462.                 // renderText: '#__value__ - __name__ ',
  1463.                 // markerHashStrictMatch: 1
  1464.             }, 1);
  1466.         } else {
  1467.             newExpenseModalSystem.toBeBalancedFromSelector = $('#newExpenseModal .expenseToBePaidTo').selectize({
  1468.                 placeholder: 'Choose a Head',
  1469.                 multiple: false,
  1470. //            options: APTL.productListArray,
  1471.                 options: [
  1472.                     {
  1473.                         value: -1,
  1474.                         text: 'My General Head',
  1475.                     },
  1476.                     {
  1477.                         value: -2,
  1478.                         text: 'My Advance',
  1479.                     }
  1480.                 ],
  1481.                 valueField: 'value',
  1482.                 labelField: 'text',
  1483.                 preload: 'focus',
  1485.                 searchField: ['text', 'value'],
  1488.                 onChange: function (value) {
  1490.                 }
  1492.             })[0].selectize;
  1494.             newExpenseModalSystem.toBeBalancedFromSelector.setValue(-2)
  1495.         }
  1497.         newExpenseModalSystem.checkSelector = $('#newExpenseModal #expense_check_id').selectize({
  1498.             placeholder: 'Choose a Cheque',
  1499.             multiple: false,
  1500. //            options: APTL.productListArray,
  1501.             options: [],
  1502.             valueField: 'value',
  1503.             labelField: 'text',
  1504.             preload: 'focus',
  1506.             searchField: ['text', 'value'],
  1507.             load: function (query, callback) {
  1508. //                        if (!query.length) return // callback();
  1509.                 if (!query.length) query = '_EMPTY_';
  1511.                 var pika_ind_id = $($(this)[0].$input["0"]).attr('data-id')
  1512.                 $.ajax({
  1513.                     url: BaseURL + "select_data_ajax",
  1514.                     type: 'POST',
  1515.                     dataType: 'json',
  1516.                     data: {
  1517.                         //returnJson: 1,
  1518.                         //sessionData: sessionData
  1519.                         query: query,
  1520.                         tableName: "acc_check",
  1521.                         valueField: "check_id",
  1522.                         // textField: "check_number",
  1523.                         entity_group: 0,
  1524.                         selectorId: $($(this)[0].$input["0"]).attr('id'),
  1525.                         isMultiple: 0,
  1526.                         dataId: pika_ind_id,
  1529. //                        isMultiple: 0,
  1531.                         textField: "rendered_text",
  1532. //
  1533.                         renderTextFormat: "__acc_number__ -- __check_number__ ",
  1534.                         andConditions: [],
  1535.                         andOrConditions: [
  1536.                             // {type: "=", field: "accounts_head_id", value: },
  1537.                             {type: "like", field: "check_number", value: query},
  1538.                             {type: "like", field: "acc_number", value: query},
  1540.                         ],
  1541.                         mustConditions: [
  1543.                             {type: "!=", field: "assigned", value: 1},
  1544.                             {
  1545.                                 type: "in",
  1546.                                 field: "accounts_head_id",
  1547.                                 value: [($('#expenseModalPayFrom').val() == '' ? 0 : $('#expenseModalPayFrom').val()), ($('#expenseModalToBePaidTo').val() == '' ? 0 : $('#expenseModalToBePaidTo').val())]
  1548.                             },
  1550.                             // {type: "not_in", field: "accounts_head_id", value: [0,'null']},
  1553.                         ],
  1554.                         orderByConditions: [  //sequential
  1556.                             {
  1557.                                 field: 'check_id',
  1558.                                 // fieldValues: [5,6,9],
  1559.                                 sortType: 'ASC'
  1560.                             }
  1561.                         ],
  1562.                         joinTableData: [
  1565.                             {
  1566.                                 tableName: "acc_accounts_head",
  1567.                                 joinFieldPrimary: "accounts_head_id",
  1568.                                 joinOn: 'accounts_head_id',
  1569.                                 tableJoinType: 'left join',
  1570.                                 // fieldJoinType: '=',
  1571.                                 selectPrefix: 'check_head_',
  1572.                                 selectFieldList: [
  1573.                                     'name', 'accounts_head_id'
  1575.                                 ]
  1576.                             },
  1578.                         ],
  1579.                         convertToObject: [
  1580. //                            'accessories', 'issues'
  1581.                         ],
  1582.                         skipDefaultCompanyId: 1
  1583.                         // setDataForSingle: 1,
  1585.                     },
  1586.                     error: function () {
  1587.                         // callback();
  1588.                     },
  1589.                     success: function (res) {
  1591.                         newExpenseModalSystem.checkData = res.dataById
  1593.                         callback(res.data);
  1596.                         if (res.setValueArray.length != 0 && res.selectorId != '') {
  1597.                             if (res.isMultiple == 1)
  1598.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValueArray)
  1599.                             else
  1600.                                 $('#' + res.selectorId).selectize()[0].selectize.setValue(res.setValue)
  1601.                         } else if (res.data.length > 0) {
  1602.                             $('#' + res.selectorId).selectize()[0].selectize.setValue(res.data[0].value)
  1604.                         }
  1605. //                        alert('pika master')
  1607.                     }
  1608.                 });
  1609.             },
  1611.             onChange: function (value) {
  1613.                 if (!value.length) {
  1614.                     $('#expense_check_number_here').val('');
  1615.                     // $('#expense_check_id').val('');
  1616.                     $('.expense_check_number_div').hide();
  1618.                 }
  1620.                 $('#expense_check_number_here').val(newExpenseModalSystem.checkData[value].check_number);
  1621.                 $('.expense_check_number_div').show();
  1624.             }
  1626.         })[0].selectize;
  1629.         if (newExpenseModalSystem.modalMode == 'standalone') {
  1630.             $('.expense_change_check_number').change(function () {
  1633.                 populateAndSetSelectByAjaxSelector(newExpenseModalSystem.checkSelector, '_ALL_')
  1636.             })
  1638.             var expenseOptions = {
  1640.                 beforeSubmit: function (arr, $form, options) {
  1641.                     $('.expenseForm').prepend(' <div class="form_ongoing_submit"></div>');
  1643.                 },
  1644.                 success: showResponsExpense // post-submit callback
  1645.             };
  1647.             function showResponsExpense(responseText, statusText, xhr, $form) {
  1649.                 if (statusText == 'success') {
  1650.                     if (responseText.success == true) {
  1651.                         alertify.alert('Successfully Added The Expense. Document Name: ' + responseText.docHash);
  1652.                         alertify.success("Expense Added");
  1653.                     } else {
  1654.                         alertify.alert('Action Failed');
  1655.                         alertify.error("Could not Add the Expense");
  1656.                         addCreateConfirmed = 0;
  1657.                     }
  1658.                 } else {
  1659.                     alertify.alert('No response from server');
  1660.                     alertify.error("Could not Add the Expense");
  1661.                     addCreateConfirmed = 0;
  1662.                 }
  1664.                 $('.expenseForm .form_ongoing_submit').remove();
  1665. //                    alert('status: ' + statusText + '\n\nresponseText: \n' + responseText +
  1666. //                            '\n\nThe output div should have already been updated with the responseText.');
  1667. //                    //    console.log('status: ' + statusText + '\n\nresponseText: \n' + responseText +
  1668. //                            '\n\nThe output div should have already been updated with the responseText.');
  1669.             }
  1672.             $('.expenseForm').ajaxForm(expenseOptions);
  1673.             $('.expenseModalSubmit').click(function (e) {
  1674.                 e.preventDefault();
  1676.                 if (!$('.expenseForm .form_ongoing_submit').length) {
  1678.                     $('.expenseForm').submit()
  1679.                 }
  1681.             });
  1682.         } else {
  1683.             $('.expenseModalSubmit').click(function (e) {
  1684.                 e.preventDefault();
  1685.                 newExpenseModalSystem.checkAndAddExpenseDataToList();
  1688.             });
  1690.         }
  1692.         $(document).on('click', '.triggerEditExpenseModal', function (e) {
  1693.             e.preventDefault();
  1695.             var this_data_row_id = $(this).data('rowId')
  1696.             var dataRow = {}
  1697.             newExpenseModalSystem.triggerExpenseModal(dataRow);
  1699.         });
  1702.         $('.filter').hide();
  1703.         $('.filter-default').show();
  1704.         $('.filter_by_this').change(function () { //            alert('here')
  1705.             var filter_ind = $(this).val()
  1706.             $('.filter').hide();
  1707.             $('.filter-' + filter_ind).show();
  1708.         })
  1711.         $('.exp_att_file').change(function () {
  1713.             // triggerOcr('#'+$(this).attr('id'))
  1714.             if (BUDDYBEE_COIN_BALANCE >= 1)
  1715.                 initiateOcr($(this).attr('id'))
  1718.         });
  1721.     });
  1722. </script>