calculate and display total lead scores

👨‍💻 Development Help
4

i’ve resolve it, but must reload 2 times
This is my code

<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

require_once('include/MVC/View/views/view.detail.php');

class CustomLeadsViewDetail extends ViewDetail {
    
    public function display() {
        $this->_updateLeadScore();
        parent::display();
    }
    private function _updateLeadScore() {
            include_once 'data/SugarBean.php';

            $leadRecordId = $this->bean->id;
            $bean = new SugarBean();
            $query = "select sum(b.fs_score)as leadscore
            from leads_ldsco_fs_lead_score_1_c a
            inner join ldsco_fs_lead_score b
            on b.id = a.leads_ldsco_fs_lead_score_1ldsco_fs_lead_score_idb
            where a.leads_ldsco_fs_lead_score_1leads_ida = "."'".$leadRecordId."'"." and a.deleted =0";
	    $result = $bean->db->query($query,true," Error filling in additional detail fields: ");
	    $row = $bean->db->fetchByAssoc($result);
            
            $insert = "update leads_cstm
                        set fs_lead_score_c =".$row[leadscore]."
                        where id_c = "."'".$leadRecordId."'"."";

            if($row[leadscore] != null){
                $result = $bean->db->query($insert,true," Error filling in additional detail fields: ");
            } 

        }
}
2 Likes