Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041310Openbravo ERP08. Project and service managementpublic2019-07-06 01:312019-08-22 14:44
collazoandy4 
collazoandy4 
normalmajorhave not tried
closedfixed 
5
 
3.0PR19Q4 
dmiguelez
Core
No
0041310: Apply HQL style guide to ReportProjectProfitabilityJR
Apply HQL style guide to ReportProjectProfitabilityJR
-
No tags attached.
related to design defect 0041287 acknowledged platform Tracking issue: Convert HQL to apply new style 
has duplicate defect 0041342 closed Triage Finance Apply new HQL Style to HQL in ReportProjectProfitabilityJR 
Issue History
2019-07-06 01:31collazoandy4New Issue
2019-07-06 01:31collazoandy4Assigned To => Triage Finance
2019-07-06 01:31collazoandy4Modules => Core
2019-07-06 01:31collazoandy4Triggers an Emergency Pack => No
2019-07-06 01:31collazoandy4Assigned ToTriage Finance => collazoandy4
2019-07-06 01:31collazoandy4Statusnew => scheduled
2019-07-06 01:32collazoandy4Relationship addedrelated to 0041287
2019-07-15 15:20AtulOpenbravoRelationship addedhas duplicate 0041342
2019-07-16 21:01AtulOpenbravoNote Added: 0113459
2019-07-16 21:03AtulOpenbravoNote Added: 0113460
2019-07-17 11:26hgbotCheckin
2019-07-17 11:26hgbotNote Added: 0113469
2019-07-17 11:26hgbotStatusscheduled => resolved
2019-07-17 11:26hgbotResolutionopen => fixed
2019-07-17 11:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4370454f15c270ad6773d076c68cce3712ba517c [^]
2019-07-17 11:26dmiguelezReview Assigned To => dmiguelez
2019-07-17 11:26dmiguelezNote Added: 0113473
2019-07-17 11:26dmiguelezStatusresolved => closed
2019-07-17 11:26dmiguelezFixed in Version => 3.0PR19Q4
2019-08-22 14:44hudsonbotCheckin
2019-08-22 14:44hudsonbotNote Added: 0114155

Notes
(0113459)
AtulOpenbravo   
2019-07-16 21:01   
Test Plan

- Create a new Project Type
  Name: Test Project Type
  Project Category: Multi Phase Project
- Create a Project Phase under the type
  Name: Project Phase I
  Product: Choose any product
  Standard Quantity: 1000
- Create a Standard Task under the Phase
  Name: Project Phase I Task I
  Product: choose any product
  Quantity: 1000
- Navigate to Multiphase Project window and create one record
  Search Key: Test Project 1
  Name: Project I
  Starting Date:01-01-2018
  Planned End Date:31-12-2019
  Sales Representative: Javier Martín
  Person Incharge:Javier Martín
- In Amounts section fill the details as below
  Legally Binging Contract = Yes
  Contract Amount: 1000,000
  Contract Qty: 1
  Service Revenue:500,000
  Planned Expenses:500,000
  Services Provided Cost: 500,000
  Outsourced Cost: 200,000
  Total Service Cost: 250,000
  Reinvoiced Expenses: 625,000
  Planned Service Margin: 50%
  Planned Expenses MArgin: 20%
- In More Information section
  Business Partner: Hoteles Buenas Noches, S.A.
  Other fields revelant to selected business partner, i.e Address, Payment Term, Price List etc
- Set Project Type to Test Project Type
- Realize that Project Phase and Project Task are created from Type selected
- Change Project Status to Order.
- Navigate tp Project Profitability report and apply all the filters
  From Project Starting Date: 01-01-2018
  To Project Starting Date: 31-12-2019
  From Project Contract Date: 01-01-2018
  To Project Contract Date : 31-12-2019
  From Date: 01-01-2018
  To Date: 31-12-2019
  Business Partner: Hoteles Buenas Noches, S.A.
  Person Incharge: Javier Martin
  Project Type: Test Project Type
  Currency: USD

- Click on HTML Format
- Realize that project information is shown and query is executed properly after the change.
  To Date:
(0113460)
AtulOpenbravo   
2019-07-16 21:03   
Log information of the query and its binding parameters:

SELECT uom0_.C_UOM_ID AS C_UOM_ID1_294_,
       uom0_.AD_Client_ID AS AD_Clien2_294_,
       uom0_.AD_Org_ID AS AD_Org_I3_294_,
       uom0_.IsActive AS IsActive4_294_,
       uom0_.Created AS Created5_294_,
       uom0_.Updated AS Updated6_294_,
       uom0_.CreatedBy AS CreatedB7_294_,
       uom0_.UpdatedBy AS UpdatedB8_294_,
       uom0_.X12DE355 AS X9_294_,
       uom0_.UOMSymbol AS UOMSymb10_294_,
       uom0_.Name AS Name11_294_,
       uom0_.Description AS Descrip12_294_,
       uom0_.StdPrecision AS StdPrec13_294_,
       uom0_.CostingPrecision AS Costing14_294_,
       uom0_.IsDefault AS IsDefau15_294_,
       uom0_.Breakdown AS Breakdo16_294_,
       uom0_.UOM_Type AS UOM_Typ17_294_,
       uom0_.Useinproduction AS Useinpr18_294_
FROM C_UOM uom0_
WHERE (EXISTS
         (SELECT 1
          FROM S_TimeExpenseLine timeandexp1_
          INNER JOIN S_TimeExpense timeandexp2_ ON timeandexp1_.S_TimeExpense_ID=timeandexp2_.S_TimeExpense_ID
          LEFT OUTER JOIN C_Project project3_ ON timeandexp1_.C_Project_ID=project3_.C_Project_ID
          WHERE timeandexp1_.IsTimeReport='Y'
            AND timeandexp1_.C_UOM_ID=uom0_.C_UOM_ID
            AND timeandexp1_.C_UOM_ID<>'101'
            AND timeandexp2_.Processed='Y'
            AND project3_.C_Project_ID=?
            AND (project3_.AD_Org_ID IN (?,
                                         ?,
                                         ?))
            AND project3_.Responsible_ID=?
            AND project3_.C_BPartner_ID=?
            AND timeandexp2_.DateReport>=?
            AND timeandexp2_.DateReport<=?
            AND project3_.Startdate>=?
            AND project3_.Startdate<?
            AND project3_.DateContract>=?
            AND project3_.DateContract<?))
  AND NOT (EXISTS
             (SELECT 1
              FROM C_UOM_Conversion uomconvers4_
              WHERE uomconvers4_.C_UOM_ID=uom0_.C_UOM_ID
                AND uomconvers4_.C_UOM_To_ID='101'))
  AND (uom0_.AD_Org_ID IN (?,
                           ?,
                           ?,
                           ?,
                           ?,
                           ?,
                           ?,
                           ?))
  AND (uom0_.AD_Client_ID IN (?,
                              ?))
  AND uom0_.IsActive='Y'

binding parameter [1] as [VARCHAR] - [567A97FEAA404FA8A7BEA587D9829FA7]
binding parameter [2] as [VARCHAR] - [E443A31992CB4635AFCAEABE7183CE85]
binding parameter [3] as [VARCHAR] - [B843C30461EA4501935CB1D125C9C25A]
binding parameter [4] as [VARCHAR] - [DC206C91AA6A4897B44DA897936E0EC3]
binding parameter [5] as [VARCHAR] - [8BD636D3BF7047F3A1ADA430D69EC033]
binding parameter [6] as [VARCHAR] - [9E6850C866BD4921AD0EB7F7796CE2C7]
binding parameter [7] as [TIMESTAMP] - [Mon Jan 01 00:00:00 IST 2018]
binding parameter [8] as [TIMESTAMP] - [Tue Dec 31 00:00:00 IST 2019]
binding parameter [9] as [TIMESTAMP] - [Mon Jan 01 00:00:00 IST 2018]
binding parameter [10] as [TIMESTAMP] - [Tue Dec 31 00:00:00 IST 2019]
binding parameter [11] as [TIMESTAMP] - [Mon Jan 01 00:00:00 IST 2018]
binding parameter [12] as [TIMESTAMP] - [Tue Dec 31 00:00:00 IST 2019]
binding parameter [13] as [VARCHAR] - [0]
binding parameter [14] as [VARCHAR] - [E443A31992CB4635AFCAEABE7183CE85]
binding parameter [15] as [VARCHAR] - [B843C30461EA4501935CB1D125C9C25A]
binding parameter [16] as [VARCHAR] - [BAE22373FEBE4CCCA24517E23F0C8A48]
binding parameter [17] as [VARCHAR] - [DC206C91AA6A4897B44DA897936E0EC3]
binding parameter [18] as [VARCHAR] - [2E60544D37534C0B89E765FE29BC0B43]
binding parameter [19] as [VARCHAR] - [19404EAD144C49A0AF37D54377CF452D]
binding parameter [20] as [VARCHAR] - [7BABA5FF80494CAFA54DEBD22EC46F01]
binding parameter [21] as [VARCHAR] - [23C59575B9CF467C9620760EB255B389]
binding parameter [22] as [VARCHAR] - [0]
(0113469)
hgbot   
2019-07-17 11:26   
Repository: erp/devel/pi
Changeset: 4370454f15c270ad6773d076c68cce3712ba517c
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Jul 16 09:12:17 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4370454f15c270ad6773d076c68cce3712ba517c [^]

Fixes Issue 41310:Apply HQL style guide to ReportProjectProfitabilityJR

Applied new HQL Style as per guideline

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.java
---
(0113473)
dmiguelez   
2019-07-17 11:26   
Code Review + Testing Ok
(0114155)
hudsonbot   
2019-08-22 14:44   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ad3efd3bd07c [^]
Maturity status: Test