Skip to content
Snippets Groups Projects

#1707 DetailView action that creates invices from a sales order...

Open #1707 DetailView action that creates invices from a sales order...
ruben.estrada/vtigercrm:create_all_invoices_from_so into master
Open Ruben A. Estrada requested to merge ruben.estrada/vtigercrm:create_all_invoices_from_so into master

…with recurring invoice enabled. Also refactoring of the cron service that creates invoices from salesorders.

create_invoices_from_so

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
layouts/v7/modules/SalesOrder/resources/Detail.js
Unable to load the diff
  • Prasad @prasad started a thread on the diff
    • layouts/v7/modules/SalesOrder/resources/Detail.js
    Unable to load the diff
  • Prasad @prasad started a thread on the diff
    • modules/SalesOrder/RecurringInvoice.php 0 → 100644
    1 <?php
    2
    3 require_once 'include/Webservices/Retrieve.php';
    4 require_once('include/utils/utils.php');
    5 require_once('modules/SalesOrder/SalesOrder.php');
    6 require_once('modules/Invoice/Invoice.php');
    7 require_once('modules/Users/Users.php');
    8
    9 class RecurringInvoice
  • Prasad @prasad started a thread on the diff
    • modules/SalesOrder/RecurringInvoice.php 0 → 100644
    9 class RecurringInvoice
    10 {
    11 private $soId;
    12 private $so;
    13 private $recurringEndDate;
    14 private $nextInvoiceDate;
    15
    16 public static function getRecurringSalesOrderIds()
    17 {
    18 $db = PearDatabase::getInstance();
    19 $sql = "
    20 SELECT vtiger_salesorder.salesorderid
    21 FROM vtiger_salesorder
    22 INNER JOIN vtiger_crmentity ON vtiger_salesorder.salesorderid = vtiger_crmentity.crmid AND vtiger_crmentity.deleted = 0
    23 INNER JOIN vtiger_invoice_recurring_info ON vtiger_salesorder.salesorderid = vtiger_invoice_recurring_info.salesorderid
    24 WHERE start_period <= ? AND end_period >= ? AND (last_recurring_date < end_period OR last_recurring_date IS NULL OR last_recurring_date = '')
  • Ruben A. Estrada
    Ruben A. Estrada @ruben.estrada started a thread on the diff
    • modules/SalesOrder/RecurringInvoice.php 0 → 100644
    9 class RecurringInvoice
    10 {
    11 private $soId;
    12 private $so;
    13 private $recurringEndDate;
    14 private $nextInvoiceDate;
    15
    16 public static function getRecurringSalesOrderIds()
    17 {
    18 $db = PearDatabase::getInstance();
    19 $sql = "
    20 SELECT vtiger_salesorder.salesorderid
    21 FROM vtiger_salesorder
    22 INNER JOIN vtiger_crmentity ON vtiger_salesorder.salesorderid = vtiger_crmentity.crmid AND vtiger_crmentity.deleted = 0
    23 INNER JOIN vtiger_invoice_recurring_info ON vtiger_salesorder.salesorderid = vtiger_invoice_recurring_info.salesorderid
    24 WHERE start_period <= ? AND end_period >= ? AND (last_recurring_date < end_period OR last_recurring_date IS NULL OR last_recurring_date = '')
  • Prasad @prasad started a thread on the diff
    • modules/SalesOrder/RecurringInvoice.php 0 → 100644
    9 class RecurringInvoice
    10 {
    11 private $soId;
    12 private $so;
    13 private $recurringEndDate;
    14 private $nextInvoiceDate;
    15
    16 public static function getRecurringSalesOrderIds()
    17 {
    18 $db = PearDatabase::getInstance();
    19 $sql = "
    20 SELECT vtiger_salesorder.salesorderid
    21 FROM vtiger_salesorder
    22 INNER JOIN vtiger_crmentity ON vtiger_salesorder.salesorderid = vtiger_crmentity.crmid AND vtiger_crmentity.deleted = 0
    23 INNER JOIN vtiger_invoice_recurring_info ON vtiger_salesorder.salesorderid = vtiger_invoice_recurring_info.salesorderid
    24 WHERE start_period <= ? AND end_period >= ? AND (last_recurring_date < end_period OR last_recurring_date IS NULL OR last_recurring_date = '')
    Please register or sign in to reply

    Copyright 2023 Vtiger. All rights reserved.