Adding field to new event form

[thehcdreamer]

Hello, i have added a field in the new event form

<td align="right"><?php echo $AppUI->_('Company');?>:</td>
<td>
<?php
	echo arraySelect( $companies, 'company_id', 'size="1" class="text"', @$obj->company_name );
?>
</td>

I have create the array that display value in the top of this file, with:

require_once( $AppUI->getModuleClass ('companies' ) );

$row = new CCompany();
$companies = $row->getAllowedRecords( $AppUI->user_id, 'company_id,company_name', 'company_name' );
$companies = arrayMerge( array( '0'=>'' ), $companies );

But i need only companies where type in the database is set to 1. Where can i set this?

Thanks

[ajdonnison]

$companies = $row->getAllowedRecords ($AppUI->user_id, 'company_id,company_name', 'company_name', array('where' => 'company_type = 1'));

[thehcdreamer]

thanks! You are great!

[mayureshwatharkar]

Hello,

I want to add a new field named "countries" in the "new project". I tried to add this field just below the "companies" field. I have a made a seperate table for "countries", but I am not able to display the records from that table into the dropdown list. I have done everything same as that if companies for "countries"...

[krad]

do you mean you have a table with the list of countries which you want in a drop down list??

if so you would do the following:-

Select the information from your table

$query_Magazine = "SELECT * FROM contries ";
$options =db_exec( $query_Contries );

You could use the DBQuery funtions but to make find simple I have done it this way.

Next you need to loop the table out into a select list.

PHP Code:

<?php 
      <select name="Contries_id">
          <?php while ($row = db_fetch_assoc( $options )) { ?>
          <option value="<?php echo $row["contries_id"]?>"> <?php echo $row["Contries_name"]
?></option>
          <?php }?>
        </select>

So what you are doing is looping through the table and printing each option with a value of the field ID and the content of a field..

THe next step would be to select and option and send back the Contries_id back in an insert.. But you need to provied information about the relationship between the tables.

Hope this helps?

[mayureshwatharkar]

thanks Krad fro your information.

my next question is, I want to save this country_id as a column name in the table "projects". I am trying to figure out where exactly they are saving all other data in the table. How shall I do this?

[ajdonnison]

For each module there is a module.class.php file (where module is the name of the module), so if you wanted to manage what is being saved in projects, you would need to edit modules/projects/projects.class.php

[mayureshwatharkar]

Thank you very much. In case of more queries, I will come back to you..

[mayureshwatharkar]

Thanks ajdonnison,
Now, what if, I want to display this newly saved field in the list of all projects (table)? Do I have to change modules/projects/in dex.php? Or which file do I have to change?

[mayureshwatharkar]

I tried to change page "admin_tab.viewuser.projects.php" for adding a column named "country" to projects list; but the changes were not reflected in the page. I do not understand which file is displaying the page of projects list.