vtenext/modules/SalesOrder/ListTopSalesOrder.php

<?php
/*************************************
 * SPDX-FileCopyrightText: 2009-2020 Vtenext S.r.l. <info@vtenext.com>
 * SPDX-License-Identifier: AGPL-3.0-only
 ************************************/


/**    function used to get the top 5 sales orders from Listview query
 * @return array $values - array with the title, header and entries like  Array('Title'=>$title,'Header'=>$listview_header,'Entries'=>$listview_entries) where as listview_header and listview_entries are arrays of header and entity values which are returned from function getListViewHeader and getListViewEntries
 */
function getTopSalesOrder($maxval, $calCnt)
{
    require_once("data/Tracker.php");
    require_once('modules/SalesOrder/SalesOrder.php');
    require_once('include/logging.php');
    require_once('include/ListView/ListView.php');
    require_once('include/utils/utils.php');
    require_once('modules/CustomView/CustomView.php');

    global $current_language, $current_user, $list_max_entries_per_page, $adb;
    $currentModuleStrings = return_module_language($current_language, 'SalesOrder');


    $LVU = ListViewUtils::getInstance();

    $url_string = '';
    $Order = '';
    $CustomView = CRMEntity::getInstance('CustomView', "SalesOrder"); // crmv@115329
    if (isset($_REQUEST['viewname']) == false || $_REQUEST['viewname'] == '') {
        if ($CustomView->setdefaultviewid != "") {

        } else {

        }
    }


    //Retreive the list from Database
    //<<<<<<<<<customview>>>>>>>>>
    $dateVar = date('Y-m-d');
    $currentModule = 'SalesOrder';
    $viewId = getCvIdOfAll($currentModule);
    $queryGenerator = QueryGenerator::getInstance($currentModule, $current_user);
    $queryGenerator->initForCustomViewById($viewId);
    $meta = $queryGenerator->getMeta($currentModule);
    $accessibleFieldNameList = array_keys($meta->getModuleFields());
    $customViewFields = $queryGenerator->getCustomViewFields();
    $fields = $queryGenerator->getFields();
    $newFields = array_diff($fields, $customViewFields);
    $widgetFieldsList = array('subject', 'account_id', 'quote_id', 'contact_id', 'total');
    $widgetFieldsList = array_intersect($accessibleFieldNameList, $widgetFieldsList);
    $widgetSelectedFields = array_chunk(array_intersect($customViewFields, $widgetFieldsList), 2);
    //select the first chunk of two fields
    $widgetSelectedFields = $widgetSelectedFields[0];
    if (count($widgetSelectedFields) < 2) {
        $widgetSelectedFields = array_chunk(array_merge($widgetSelectedFields, $accessibleFieldNameList), 2);
        //select the first chunk of two fields
        $widgetSelectedFields = $widgetSelectedFields[0];
    }
    $newFields = array_merge($newFields, $widgetSelectedFields);
    $queryGenerator->setFields($newFields);
    $_REQUEST = getTopSalesOrderSearch($_REQUEST, array(
        'assigned_user_id' => $current_user->column_fields['user_name'],
        'duedate' => $dateVar));
    $queryGenerator->addUserSearchConditions($_REQUEST);
    $searchQry = '&query=true' . getSearchURL($_REQUEST);
    $query = $queryGenerator->getQuery();

    //<<<<<<<<customview>>>>>>>>>

    if ($calCnt == 'calculateCnt') {
        $listResultRows = $adb->query(mkCountQuery($query));
        return $adb->query_result($listResultRows, 0, 'count');
    }

    $listResult = $adb->limitQuery($query, 0, $maxval);

    //Retreiving the no of rows
    $numberOfRows = $adb->num_rows($listResult);

    //Retreiving the start value from request
    if (isset($_REQUEST['start']) && $_REQUEST['start'] != '') {
        $start = vtlib_purify($_REQUEST['start']);
    } else {
        $start = 1;
    }

    //Retreive the Navigation array
    $navigationArray = $LVU->getNavigationValues($start, $numberOfRows, $list_max_entries_per_page);

    if ($navigationArray['start'] == 1) {
        if ($numberOfRows != 0) {
        } else {

        }
        if ($numberOfRows > $list_max_entries_per_page) {

        } else {

        }

    } else {
        if ($navigationArray['next'] > $list_max_entries_per_page) {

        } else {

        }
    }

    $focus = CRMEntity::getInstance('SalesOrder');

    //Retreive the List View Table Header
    $title = array('myTopSalesOrders.gif', $currentModuleStrings['LBL_MY_TOP_SO'], 'home_mytopso');
    $controller = ListViewController::getInstance($adb, $current_user, $queryGenerator);
    $controller->setHeaderSorting(false);
    $header = $controller->getListViewHeader($focus, $currentModule, $url_string, $Order,
        true);

    $entries = $controller->getListViewEntries($focus, $currentModule, $listResult,
        $navigationArray, true);

    $values = array('ModuleName' => 'SalesOrder', 'Title' => $title, 'Header' => $header, 'Entries' => $entries, 'search_qry' => $searchQry);
    if (($numberOfRows == 0) || ($numberOfRows > 0))
        return $values;
}

function getTopSalesOrderSearch($output, $input)
{
    $output['query'] = 'true';
    $output['Fields0'] = 'duedate';
    $output['Condition0'] = 'h';
    $output['Srch_value0'] = $input['duedate'];
    $output['Fields1'] = 'assigned_user_id';
    $output['Condition1'] = 'e';
    $output['Srch_value1'] = $input['assigned_user_id'];
    $output['searchtype'] = 'advance';
    $output['search_cnt'] = '2';
    $output['matchtype'] = 'all';
    return $output;
}