Пример #1
0
 function createInventoryDetails($related_focus, $module)
 {
     require_once 'modules/InventoryDetails/InventoryDetails.php';
     global $adb, $log, $current_user, $currentModule;
     $save_currentModule = $currentModule;
     $currentModule = 'InventoryDetails';
     $related_to = $related_focus->id;
     //var_dump($related_focus->column_fields);exit;
     $taxtype = getInventoryTaxType($module, $related_to);
     if ($taxtype == 'group') {
         $query = "SELECT id as related_to , productid , sequence_no ,lineitem_id,quantity , listprice , comment as description , \n\t\t\tquantity * listprice AS extgross, \n\t\t\tCOALESCE( discount_percent, COALESCE( discount_amount *100 / ( quantity * listprice ) , 0 ) ) AS discount_percent, \n\t\t\tCOALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ) ) AS discount_amount, \n\t\t\t(quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 )) AS extnet, \n\t\t\t((quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ))) AS linetotal \n\t\t\tFROM vtiger_inventoryproductrel \n\t\t\tWHERE id = ?";
     } elseif ($taxtype == 'individual') {
         $query = "SELECT id as related_to , productid , sequence_no ,lineitem_id,quantity , listprice , comment as description , \n\t\t\tcoalesce( tax1 , 0 ) AS tax1, coalesce( tax2 , 0 ) AS tax2, coalesce( tax3 , 0 ) AS tax3, \n\t\t\t( COALESCE( tax1, 0 ) + COALESCE( tax2, 0 ) + COALESCE( tax3, 0 ) ) as tax_percent, \n\t\t\tquantity * listprice AS extgross, \n\t\t\tCOALESCE( discount_percent, COALESCE( discount_amount *100 / ( quantity * listprice ) , 0 ) ) AS discount_percent, \n\t\t\tCOALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ) ) AS discount_amount, \n\t\t\t(quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 )) AS extnet, \n\t\t\t((quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ))) * ( COALESCE( tax1, 0 ) + COALESCE( tax2, 0 ) + COALESCE( tax3, 0 ) ) /100 AS linetax, \n\t\t\t((quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ))) * ( 1 + ( COALESCE( tax1, 0 ) + COALESCE( tax2, 0 ) + COALESCE( tax3, 0 )) /100) AS linetotal \n\t\t\tFROM vtiger_inventoryproductrel \n\t\t\tWHERE id = ?";
     }
     $res_inv_lines = $adb->pquery($query, array($related_to));
     $accountid = '0';
     $contactid = '0';
     switch ($module) {
         case 'Quotes':
             $accountid = $related_focus->column_fields['account_id'];
             $contactid = $related_focus->column_fields['contact_id'];
             break;
         case 'SalesOrder':
             $accountid = $related_focus->column_fields['account_id'];
             $contactid = $related_focus->column_fields['contact_id'];
             break;
         case 'Invoice':
             $accountid = $related_focus->column_fields['account_id'];
             $contactid = $related_focus->column_fields['contact_id'];
             break;
         case 'PurchaseOrder':
             $contactid = $related_focus->column_fields['contact_id'];
             break;
         default:
             break;
     }
     // Delete all InventoryDetails where related with $related_to
     $res_to_del = $adb->pquery("SELECT inventorydetailsid FROM vtiger_inventorydetails \n\t\t\t\t\t\t\t\t\tINNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_inventorydetails.inventorydetailsid \n\t\t\t\t\t\t\t\t\tWHERE deleted = 0 AND related_to = ?", array($related_to));
     while ($invdrow = $adb->getNextRow($res_to_del, false)) {
         $invdet_focus = new InventoryDetails();
         $invdet_focus->id = $invdrow['inventorydetailsid'];
         $invdet_focus->trash('InventoryDetails', $invdet_focus->id);
     }
     // read $res_inv_lines result to create a new InventoryDetail for each register.
     // Remember to take the Vendor if the Product is related with this.
     while ($row = $adb->getNextRow($res_inv_lines, false)) {
         $invdet_focus = array();
         $invdet_focus = new InventoryDetails();
         $invdet_focus->id = '';
         $invdet_focus->mode = '';
         foreach ($invdet_focus->column_fields as $fieldname => $val) {
             $invdet_focus->column_fields[$fieldname] = $row[$fieldname];
         }
         $_REQUEST['assigntype'] == 'U';
         $invdet_focus->column_fields['assigned_user_id'] = $current_user->id;
         $invdet_focus->column_fields['account_id'] = $accountid;
         $invdet_focus->column_fields['contact_id'] = $contactid;
         //Search if the product is related with a Vendor.
         $vendorid = '0';
         $result = $adb->pquery("SELECT vendor_id FROM vtiger_products WHERE productid = ?", array($row['productid']));
         if ($adb->num_rows($result) > 0) {
             $vendorid = $adb->query_result($result, 0, 0);
         }
         $invdet_focus->column_fields['vendor_id'] = $vendorid;
         if ($taxtype == 'group') {
             $invdet_focus->column_fields['tax_percent'] = 0;
             $invdet_focus->column_fields['linetax'] = 0;
         }
         $invdet_focus->save("InventoryDetails");
     }
     $currentModule = $save_currentModule;
 }
Пример #2
0
    public static function createInventoryDetails($related_focus, $module)
    {
        global $adb, $log, $current_user, $currentModule;
        $save_currentModule = $currentModule;
        $currentModule = 'InventoryDetails';
        $related_to = $related_focus->id;
        $taxtype = getInventoryTaxType($module, $related_to);
        if ($taxtype == 'group') {
            $query = "SELECT id as related_to, vtiger_inventoryproductrel.productid, sequence_no, lineitem_id, quantity, listprice, comment as description,\n\t\t\tquantity * listprice AS extgross,\n\t\t\tCOALESCE( discount_percent, COALESCE( discount_amount *100 / ( quantity * listprice ) , 0 ) ) AS discount_percent,\n\t\t\tCOALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ) ) AS discount_amount,\n\t\t\t(quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 )) AS extnet,\n\t\t\t((quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ))) AS linetotal,\n\t\t\tcase when vtiger_products.productid != '' then vtiger_products.cost_price else vtiger_service.cost_price end as cost_price,\n\t\t\tcase when vtiger_products.productid != '' then vtiger_products.vendor_id else 0 end as vendor_id\n\t\t\tFROM vtiger_inventoryproductrel\n\t\t\tLEFT JOIN vtiger_products ON vtiger_products.productid=vtiger_inventoryproductrel.productid\n\t\t\tLEFT JOIN vtiger_service ON vtiger_service.serviceid=vtiger_inventoryproductrel.productid\n\t\t\tWHERE id = ?";
        } elseif ($taxtype == 'individual') {
            $query = "SELECT id as related_to, vtiger_inventoryproductrel.productid, sequence_no, lineitem_id, quantity, listprice, comment as description,\n\t\t\tcoalesce( tax1 , 0 ) AS tax1, coalesce( tax2 , 0 ) AS tax2, coalesce( tax3 , 0 ) AS tax3,\n\t\t\t( COALESCE( tax1, 0 ) + COALESCE( tax2, 0 ) + COALESCE( tax3, 0 ) ) as tax_percent,\n\t\t\tquantity * listprice AS extgross,\n\t\t\tCOALESCE( discount_percent, COALESCE( discount_amount *100 / ( quantity * listprice ) , 0 ) ) AS discount_percent,\n\t\t\tCOALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ) ) AS discount_amount,\n\t\t\t(quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 )) AS extnet,\n\t\t\t((quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ))) * ( COALESCE( tax1, 0 ) + COALESCE( tax2, 0 ) + COALESCE( tax3, 0 ) ) /100 AS linetax,\n\t\t\t((quantity * listprice) - COALESCE( discount_amount, COALESCE( discount_percent * quantity * listprice /100, 0 ))) * ( 1 + ( COALESCE( tax1, 0 ) + COALESCE( tax2, 0 ) + COALESCE( tax3, 0 )) /100) AS linetotal,\n\t\t\tcase when vtiger_products.productid != '' then vtiger_products.cost_price else vtiger_service.cost_price end as cost_price,\n\t\t\tcase when vtiger_products.productid != '' then vtiger_products.vendor_id else 0 end as vendor_id\n\t\t\tFROM vtiger_inventoryproductrel\n\t\t\tLEFT JOIN vtiger_products ON vtiger_products.productid=vtiger_inventoryproductrel.productid\n\t\t\tLEFT JOIN vtiger_service ON vtiger_service.serviceid=vtiger_inventoryproductrel.productid\n\t\t\tWHERE id = ?";
        }
        $res_inv_lines = $adb->pquery($query, array($related_to));
        $accountid = '0';
        $contactid = '0';
        switch ($module) {
            case 'Quotes':
                $accountid = $related_focus->column_fields['account_id'];
                $contactid = $related_focus->column_fields['contact_id'];
                break;
            case 'SalesOrder':
                $accountid = $related_focus->column_fields['account_id'];
                $contactid = $related_focus->column_fields['contact_id'];
                break;
            case 'Invoice':
                $accountid = $related_focus->column_fields['account_id'];
                $contactid = $related_focus->column_fields['contact_id'];
                break;
            case 'PurchaseOrder':
                $contactid = $related_focus->column_fields['contact_id'];
                break;
            default:
                break;
        }
        // Delete all InventoryDetails where related with $related_to
        $res_to_del = $adb->pquery('SELECT inventorydetailsid FROM vtiger_inventorydetails
			INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_inventorydetails.inventorydetailsid
			WHERE deleted = 0 AND related_to = ? and lineitem_id not in (select lineitem_id from vtiger_inventoryproductrel where id=?)', array($related_to, $related_to));
        while ($invdrow = $adb->getNextRow($res_to_del, false)) {
            $invdet_focus = new InventoryDetails();
            $invdet_focus->id = $invdrow['inventorydetailsid'];
            $invdet_focus->trash('InventoryDetails', $invdet_focus->id);
        }
        $requestindex = 1;
        while (isset($_REQUEST['deleted' . $requestindex]) and $_REQUEST['deleted' . $requestindex] == 1) {
            $requestindex++;
        }
        // read $res_inv_lines result to create a new InventoryDetail for each register.
        // Remember to take the Vendor if the Product is related with this.
        while ($row = $adb->getNextRow($res_inv_lines, false)) {
            $invdet_focus = array();
            $invdet_focus = new InventoryDetails();
            $rec_exists = $adb->pquery('SELECT inventorydetailsid FROM vtiger_inventorydetails
				INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_inventorydetails.inventorydetailsid
				WHERE deleted = 0 AND lineitem_id = ?', array($row['lineitem_id']));
            if ($adb->num_rows($rec_exists) > 0) {
                $invdet_focus->id = $adb->query_result($rec_exists, 0, 0);
                $invdet_focus->retrieve_entity_info($invdet_focus->id, 'InventoryDetails');
                $invdet_focus->mode = 'edit';
            } else {
                $invdet_focus->id = '';
                $invdet_focus->mode = '';
            }
            foreach ($invdet_focus->column_fields as $fieldname => $val) {
                if (isset($_REQUEST[$fieldname . $requestindex])) {
                    $invdet_focus->column_fields[$fieldname] = vtlib_purify($_REQUEST[$fieldname . $requestindex]);
                } elseif (isset($row[$fieldname])) {
                    $invdet_focus->column_fields[$fieldname] = $row[$fieldname];
                }
            }
            $invdet_focus->column_fields['lineitem_id'] = $row['lineitem_id'];
            $_REQUEST['assigntype'] = 'U';
            $invdet_focus->column_fields['assigned_user_id'] = $current_user->id;
            $invdet_focus->column_fields['account_id'] = $accountid;
            $invdet_focus->column_fields['contact_id'] = $contactid;
            if ($taxtype == 'group') {
                $invdet_focus->column_fields['tax_percent'] = 0;
                $invdet_focus->column_fields['linetax'] = 0;
            }
            $handler = vtws_getModuleHandlerFromName('InventoryDetails', $current_user);
            $meta = $handler->getMeta();
            $invdet_focus->column_fields = DataTransform::sanitizeRetrieveEntityInfo($invdet_focus->column_fields, $meta);
            $invdet_focus->save("InventoryDetails");
            $requestindex++;
            while (isset($_REQUEST['deleted' . $requestindex]) and $_REQUEST['deleted' . $requestindex] == 1) {
                $requestindex++;
            }
        }
        $currentModule = $save_currentModule;
    }