// Email Reporting - added default email reports.
$sql = "INSERT INTO vtiger_reportfolder (FOLDERNAME,DESCRIPTION,STATE) VALUES(?,?,?)";
$params = array('Email Reports', 'Email Reports', 'SAVED');
Migration_Index_View::ExecuteQuery($sql, $params);
$reportmodules = array(array('primarymodule' => 'Contacts', 'secondarymodule' => 'Emails'), array('primarymodule' => 'Accounts', 'secondarymodule' => 'Emails'), array('primarymodule' => 'Leads', 'secondarymodule' => 'Emails'), array('primarymodule' => 'Vendors', 'secondarymodule' => 'Emails'));
$reports = array(array('reportname' => 'Contacts Email Report', 'reportfolder' => 'Email Reports', 'description' => 'Emails sent to Contacts', 'reporttype' => 'tabular', 'sortid' => '', 'stdfilterid' => '', 'advfilterid' => '0'), array('reportname' => 'Accounts Email Report', 'reportfolder' => 'Email Reports', 'description' => 'Emails sent to Organizations', 'reporttype' => 'tabular', 'sortid' => '', 'stdfilterid' => '', 'advfilterid' => '0'), array('reportname' => 'Leads Email Report', 'reportfolder' => 'Email Reports', 'description' => 'Emails sent to Leads', 'reporttype' => 'tabular', 'sortid' => '', 'stdfilterid' => '', 'advfilterid' => '0'), array('reportname' => 'Vendors Email Report', 'reportfolder' => 'Email Reports', 'description' => 'Emails sent to Vendors', 'reporttype' => 'tabular', 'sortid' => '', 'stdfilterid' => '', 'advfilterid' => '0'));
$selectcolumns = array(array('vtiger_contactdetails:lastname:Contacts_Last_Name:lastname:V', 'vtiger_contactdetails:email:Contacts_Email:email:E', 'vtiger_activity:subject:Emails_Subject:subject:V', 'vtiger_email_track:access_count:Emails_Access_Count:access_count:V'), array('vtiger_account:accountname:Accounts_Account_Name:accountname:V', 'vtiger_account:phone:Accounts_Phone:phone:V', 'vtiger_account:email1:Accounts_Email:email1:E', 'vtiger_activity:subject:Emails_Subject:subject:V', 'vtiger_email_track:access_count:Emails_Access_Count:access_count:V'), array('vtiger_leaddetails:lastname:Leads_Last_Name:lastname:V', 'vtiger_leaddetails:company:Leads_Company:company:V', 'vtiger_leaddetails:email:Leads_Email:email:E', 'vtiger_activity:subject:Emails_Subject:subject:V', 'vtiger_email_track:access_count:Emails_Access_Count:access_count:V'), array('vtiger_vendor:vendorname:Vendors_Vendor_Name:vendorname:V', 'vtiger_vendor:glacct:Vendors_GL_Account:glacct:V', 'vtiger_vendor:email:Vendors_Email:email:E', 'vtiger_activity:subject:Emails_Subject:subject:V', 'vtiger_email_track:access_count:Emails_Access_Count:access_count:V'));
$advfilters = array(array(array('columnname' => 'vtiger_email_track:access_count:Emails_Access_Count:access_count:V', 'comparator' => 'n', 'value' => '')));
foreach ($reports as $key => $report) {
$queryid = Migration_Index_View::insertSelectQuery();
$sql = 'SELECT MAX(folderid) AS count FROM vtiger_reportfolder';
$result = $adb->query($sql);
$folderid = $adb->query_result($result, 0, 'count');
Migration_Index_View::insertReports($queryid, $folderid, $report['reportname'], $report['description'], $report['reporttype']);
Migration_Index_View::insertSelectColumns($queryid, $selectcolumns[$key]);
Migration_Index_View::insertReportModules($queryid, $reportmodules[$key]['primarymodule'], $reportmodules[$key]['secondarymodule']);
if (isset($advfilters[$report['advfilterid']])) {
Migration_Index_View::insertAdvFilter($queryid, $advfilters[$report['advfilterid']]);
}
}
// TODO : need to review this after adding report sharing feature
Migration_Index_View::ExecuteQuery("UPDATE vtiger_report SET sharingtype='Public'", array());
//End.
//Currency Decimal places handling
Migration_Index_View::ExecuteQuery("ALTER TABLE vtiger_account MODIFY COLUMN annualrevenue decimal(25,5)", array());
Migration_Index_View::ExecuteQuery("ALTER TABLE vtiger_leaddetails MODIFY COLUMN annualrevenue decimal(25,5)", array());
Migration_Index_View::ExecuteQuery("UPDATE vtiger_field SET typeofdata='N~O' WHERE fieldlabel='Annual Revenue' and typeofdata='I~O'", array());
Migration_Index_View::ExecuteQuery("ALTER TABLE vtiger_currency_info MODIFY COLUMN conversion_rate decimal(12,5)", array());
Migration_Index_View::ExecuteQuery("ALTER TABLE vtiger_productcurrencyrel MODIFY COLUMN actual_price decimal(28,5)", array());
Migration_Index_View::ExecuteQuery("ALTER TABLE vtiger_productcurrencyrel MODIFY COLUMN converted_price decimal(28,5)", array());
Migration_Index_View::ExecuteQuery("ALTER TABLE vtiger_pricebookproductrel MODIFY COLUMN listprice decimal(27,5)", array());
