addon saving problem

scotchk

Hi
I was wondering if someone can help me. I am no php writer but after over 10 days of trying (using the HelloWorld documentation and scouring the forum) I feel like I am banging my head against a brick wall as I just can't get my addon to work properly. I can see it in Company and Contact views and I can add a record BUT it only saves to the contact view and not to the company view. I attach my files, maybe someone would be kind enough to check them. I'm sure it must be a line of code I am missing somewhere or one that is false.
install:

<?php

defined("_VALID_ACCESS") || die('Direct access forbidden');



class Custom_TestInstall extends ModuleInstall {

    public function install() { // Here you can place installation process for the module

        Base_ThemeCommon::install_default_theme($this->get_type());

        $training_fields = new Custom_Test_Recordset();

        $success = $training_fields->install();

        $training_fields->add_default_access();

        $training_fields->set_caption(_M('Test'));



        Utils_RecordBrowserCommon::add_access('Test', 'add', array('ACCESS:employee','ACCESS:manager'));

        Utils_CommonDataCommon::new_array('Source',$values);

        Utils_RecordBrowserCommon::enable_watchdog('Test', array('Custom_TestCommon','watchdog_label'));

        Utils_RecordBrowserCommon::new_addon('company', $this->get_type(), 'company_addon',

            array($this->get_type() . 'Common', 'company_addon_label'));

        return true; // Return true on success and false on failure

    }

    public function uninstall() { // Here you can place uninstallation process for the module

        Utils_CommonDataCommon::remove('Custom/Test/Employees');

        Utils_RecordBrowserCommon::delete_addon('company', $this->get_type(), 'company_addon');

        return true; // Return true on success and false on failure

    }

    public function info() { // Returns basic information about the module which will be available in the epesi Main Setup

        return array( 'Author'=>'yank');

    }

    public function simple_setup() { // Indicates if this module should be visible on the module list in Main Setup's simple view

        return array('package' => __('Test'), 'version'=>'0.1');

        // return true;

    }

    public function requires($v) { // Returns list of modules and their versions, that are required to run this module

        return array();

    }

    public function version() { // Return version name of the module

        return array('0.1');

    }

}

?>

Common

<?php

defined("_VALID_ACCESS") || die('Direct access forbidden');

class Custom_TestCommon extends ModuleCommon {

    public static function menu() {

        return array(__('Module') => array('__submenu__' => 1, __('Test') => array())); // - this will output as Module->Test in the main menu

    }

    public static function company_addon_label() {



            return array('label' => __('Test'), 'show' => true);



    }

    public static function applet_info() {

        return __('Display Test Records');

    }

    public static function applet_caption() {

        return __('Test');

    }

    public static function applet_settings() {

        $status = array('__ALL__' => '[' . __('All') . ']');

        $status += Utils_CommonDataCommon::get_translated_array('Source');



        $options = array();

       // $options[] = array('name'=>'status','label'=>__('Status'),'type'=>'select','values'=> $status, 'default' => '1');

        $options[] = array('name'=>'title','label'=>__('Title'),'type'=>'text','default'=>__('Test'),'rule'=>array(array('message'=>__('Field required'), 'type'=>'required')));

        return Utils_RecordBrowserCommon::applet_settings($options);

    }

    public static function applet_info_format($r) {

        static $rs;

        $rs || $rs = new Custom_Test_Recordset();

        $fields = array('Text');

        $args = array();

        foreach ($fields as $f) {

            $args[_V($f)] = $rs->get_val($f, $r, true);

        }



        $ret = array('notes' => Utils_TooltipCommon::format_info_tooltip($args));

        return $ret;

    }

    public static function QFfield_integer(&$form, $field, $label, $mode, $default, $desc){

        if ($mode=='add' || $mode=='edit') {

            $form->addElement('checkbox', $field, $label, null, array('id'=>$field));

        }else{

            $form->addElement('static', $field, $label);

        }

    }

    public static function watchdog_label($rid = null, $events = array(), $details = true) {

        return Utils_RecordBrowserCommon::watchdog_label(

            'Test',

            __('Test'),

            $rid,

            $events,

            'text',

            $details

        );

    }

}

?>

<?php

defined("_VALID_ACCESS") || die('Direct access forbidden');



class Custom_Test extends Module {

public $rs;

public $rb;

    public function body() {

        $this->init_default_rb();

       $me = CRM_ContactsCommon::get_my_record();

        $this->rb->set_defaults(array("select"=>$me['id']));

        $this->rb->set_defaults(array('date'=>date('Y-m-d')));

        $this->rb->set_header_properties(array('text'=>array('name'=>__('T'),'width'=>'35px')));

        $this->display_module($this->rb);



    }

    public function applet($conf, & $opts) {

        $title = $conf['title'];

        $opts['go'] = true;

        $rs = new Custom_Test_Recordset();

        $this->rb = $rs->create_rb_module($this);

        $crits = array();

        $columns = array(

            array('field'=>'text', 'width'=>20));

           

        $opts['title'] = $title;

        $opts['actions'][] = Utils_RecordBrowserCommon::applet_new_record_button('Test',array());

        $conds = array();

        // fields selection

        $conds[] = $columns;

        // Filters = $crits

        $conds[] = $crits;

        // Sorting order

        $conds[] = array();

        // Applet info callback

        $conds[] = array('Custom_TestCommon', 'applet_info_format');

        // Display limit = number of records

        $conds[] = 15;

        // User applet config settings

        $conds[] = $conf;

        // Applet options

        $conds[] = & $opts;

        $this->display_module($this->rb, $conds, 'mini_view');

    }

    public function company_addon($record) {

        $this->init_default_rb();

        $this->rb->set_defaults(array('text' => $record['company_name']));

        $crits = array('text' => $record['company_name']);

        $cols = array('text' => true);

        $show_data_params = array($crits, $cols);

        $this->display_module($this->rb, $show_data_params, 'show_data');

    }

    private function init_default_rb() {

        $rs = new Custom_Test_Recordset();

        // default values and column properties moved to recordset class

        $this->rb = $rs->create_rb_module($this);

    }

}

?>

Many thanks in advance

ajb

Hi there. You have to clarify your intention.

What do you mean by I can see it in Company and Contact views - because in the code I see that there is an addon to companies (not contacts).
What is your recordset - how would you like to link your records to Company?
Could you please paste some screenshots?

Regards,
Adam

scotchk

Wow, thanks for the quick response!

Here is my recordset

<?php





defined("_VALID_ACCESS") || die('Direct access forbidden');





class Custom_Test_Recordset extends RBO_Recordset {





    function table_name() {





        return 'Test';





    }





    function fields() { // - here you choose the fields to add to the record browser


 


        $fields = array();      





	$ID = new RBO_Field_Autonumber('Ordersid');


        //$ID->set_visible();


        $fields[] = $ID;


	


	$o_date = new RBO_Field_Date('Order Date');


        $o_date->set_visible();


        $fields[] = $o_date;


	


	$process_date = new RBO_Field_Date('Processed');


        $process_date->set_visible();


        $fields[] = $process_date;





	$account_number = new RBO_Field_Text('Account Number');


        $account_number->set_length(8)->set_required()->set_visible();


        $fields[] = $account_number;





	$Co_Name = new RBO_Field_Select('Company Name');


	$Co_Name->set_required()->set_visible();


	$Co_Name->from('company')->fields('Company Name');


	$fields[] = $Co_Name;








        $po = new RBO_Field_Text('PO Number');


        $po->set_length(24)->set_required()->set_visible();


        $fields[] = $po;





        $o_amount = new RBO_Field_Currency('Order Amount');


        $o_amount->set_required()->set_visible();


        $fields[] = $o_amount;     





	$process_net = new RBO_Field_Currency('Order Amount Available');


        $process_net->set_required()->set_visible();


        $fields[] = $process_net;





	$discount_due = new RBO_Field_Text('Discount Due');


        $discount_due->set_length(8)->set_visible();


        $fields[] = $discount_due; 





        $source = new RBO_Field_CommonData('Source', 'source');


        $source->set_visible();


        $fields[] = $source; 





	$pro_forma = new RBO_Field_Checkbox('Pro Forma');


        $pro_forma->set_visible();


        $fields[] = $pro_forma;





        $order_comments = new RBO_Field_Text('Comments');


        $order_comments->set_length(50)->set_visible();


        $fields[] = $order_comments;   





        $buyer = new RBO_Field_Select('Buyer');


        $buyer->from('contact')->fields('first_name','last_name')->set_visible();


        $fields[] = $buyer;








        











        return array($ID, $o_date, $process_date, $account_number, $Co_Name, $po, $o_amount, $process_net, $discount_due, $source, $pro_forma, $order_comments, $buyer);


 


    }

















}


?>

and here a couple of screenshots to explain what I mean. I added the new order report through the "add" button under Test tab on the Company window. It saved the info but is not visible under the Company Test tab, only under the Contact Test tab (even though I didn't enter a contact name for the order report - only the company name.)

Company Test tab window

Contacts Test tab window

Hope this shows what I mean.

ajb

Ok, I see that your code doesn't reflect your system. You don't have a piece of code that will add "Test" addon to contacts, so how happened that there is an addon?
In your company_addon method you've got some strange crits

        $crits = array('text' => $record['company_name']);

        $cols = array('text' => true);

        $show_data_params = array($crits, $cols);

but you don't have text field. You should use company name here

        $crits = array('company_name' => $record['company_name']); // filter records

        $cols = array('company_name' => false); // do not show company name column

        $show_data_params = array($crits, $cols);

The same in body method. array('text' => 'test') ? Maybe your body method is used as addon to contacts?

Regards,
Adam

scotchk

Hi Adam
As I say I have pieced this together from the HelloWorld tutorial and what I found in the forum, so how the tab appears in the Contacts I don't know. Is there something else I should have instead of
array('text' => 'test') .

I have changed the crits in Test_0 and now have the following error:

Type: E_USER_ERROR (256)

Message: Unknown field "" for recordset "Test"

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

Line=44

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "Unknown field \"\" for recordset \"Test\"", "/var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php", 44, Array ("Test", null, Array (#17), false, null, Array (#0), "/"))

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 44

    function called: trigger_error("Unknown field \"\" for recordset \"Test\"", 256)

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 154

    function called: get_val("Test", null, Array (#17), false, null)

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 2813

    function called: get_val(null, Array (#17), false, null)

[PHP core called function]

    function called: mini_view(Array (Array (#2)), Array (), Array (), Array ("Custom_TestCommon", "applet_info_format"), 15, Array ("Test", true, false, true, false, false), Array ("Test", true, null, true, "body", Array (#0), Array (#0), Array (#1), "9"))

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 853

    function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "mini_view"), Array (Array (#1), Array (#0), Array (#0), Array (#2), 15, Array (#6), "Array (\"Test\", true, null, true, \"body\", Array (#0), Array (#0), Array (#1), \"9\")"))

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 773

    function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#1), Array (#0), Array (#0), Array (#2), 15, Array (#6), "\"Array (\\"Test\\", true, null, true, \\"body\\", Array (#0), Array (#0), Array (#1), \\"9\\")\""), "mini_view")

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Custom/Test/Test_0.php

    line 53

    function called: display_module("Object (Utils_RecordBrowser)", Array (Array (#1), Array (#0), Array (#0), Array (#2), 15, Array (#6), "\"\\"Array (\\\"Test\\\", true, null, true, \\\"body\\\", Array (#0), Array (#0), Array (#1), \\\"9\\\")\\"\""), "mini_view")

[PHP core called function]

    function called: applet(Array ("Test", true, false, true, false, false), "\"\\"\\\"Array (\\\\"Test\\\\", true, null, true, \\\\"body\\\\", Array (#0), Array (#0), Array (#1), \\\\"9\\\\")\\\"\\"\"", "9")

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 853

    function called: call_user_func_array(Array (Object (Custom_Test), "applet"), Array (Array (#6), "\"\\"\\\"\\\\"Array (\\\\\"Test\\\\\", true, null, true, \\\\\"body\\\\\", Array (#0), Array (#0), Array (#1), \\\\\"9\\\\\")\\\\"\\\"\\"\"", "9"))

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Base/Dashboard/Dashboard_0.php

    line 192

    function called: get_html_of_module(Object (Custom_Test), Array (Array (#6), "\"\\"\\\"\\\\"\\\\\"Array (\\\\\\"Test\\\\\\", true, null, true, \\\\\\"body\\\\\\", Array (#0), Array (#0), Array (#1), \\\\\\"9\\\\\\")\\\\\"\\\\"\\\"\\"\"", "9"), "applet")

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Base/Dashboard/Dashboard_0.php

    line 126

    function called: display_dashboard("1")

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Base/Dashboard/Dashboard_0.php

    line 29

    function called: dashboard()

[PHP core called function]

    function called: body()

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 853

    function called: call_user_func_array(Array (Object (Base_Dashboard), "body"), Array ())

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 773

    function called: get_html_of_module(Object (Base_Dashboard), null, "body")

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 946

    function called: display_module("Object (Base_Dashboard)", null, "body")

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Base/HomePage/HomePage_0.php

    line 24

    function called: pack_module("Base/Dashboard", null, "body", null)

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Base/HomePage/HomePage_0.php

    line 17

    function called: show_home_page(Array ("Base/Dashboard"))

[PHP core called function]

    function called: body()

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 853

    function called: call_user_func_array(Array (Object (Base_HomePage), "body"), Array ())

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/module.php

    line 773

    function called: get_html_of_module(Object (Base_HomePage), null, null)

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/modules/Base/Box/Box_0.php

    line 151

    function called: display_module("Object (Base_HomePage)")

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/epesi.php

    line 241

    function called: body()

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/include/epesi.php

    line 286

    function called: go(Object (Base_Box))

File: /var/www/vhosts/k-playinternational.co.uk/httpdocs/process.php

    line 35

    function called: process("Base_HomePage_load=1", false)

Any suggestions as to what is wrong? I appreciate your help.
By the way, if it helps, this module doesn't call on any other module, it's simply a record of an order placed. Up until now we have been using an online database but I want this to now form part of a complete crm.

ajb

Because you don't have 'text' field - probably that's the reason. Well I see that your issues are mainly caused by poor understanding what's happening. You should dig deeper to understand that code.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge