Steve Sonius

I needed something that would convert WSDL to useable php classes so I sould consume web services.

I had found this pear package called wsdl2php and modified the class to work as a symfony plugin.

You can download the plugin here

How to use.

1. Unzip the folder, wsdl2phpPlugin, into your projects plugin dir
2. Depending on your version of symfony you may ned to activate the plugin by adding

   $this->enablePlugins('wsdl2phpPlugin');

   to your ProjectConfiguration.class.php file

3. In your action or static class simpily call the convert function, for example:

    wsdl2php::convert('http://www.webservicex.net/CurrencyConvertor.asmx?WSDL');

4. The new class will be written to the projects main lib dir:
   eg: CurrencyConvertor.class.php
5. Add any custom functionality in mySoapClient.class.php
6. clear cache and your ready to go.

this is how this particular example is used:

$ConversionRate = new ConversionRate();
$ConversionRate->FromCurrency = Currency::USD;
$ConversionRate->ToCurrency = Currency::AUD;

$CurrencyConvertor = new CurrencyConvertor();

$ConversionRateResponse = $CurrencyConvertor->ConversionRate($ConversionRate);

var_dump($ConversionRateResponse);
exit;

I had created I18n table set and all seemed to be working well until I tried to propel:build-schema.
I had lost my attribues:

isI18N: true, i18nTable: page_i18n & isCulture: true

This is how I want my schema to looked in the beginning:

  cms:
    _attributes: { phpName: Cms, isI18N: true, i18nTable: cms_i18n }
    id:
    handle: {type: varchar, size: 50}
    created_at:
    updated_at:
  cms_i18n:
    id:      { type: integer, size:  11, foreignTable: cms, foreignReference: id,  required: true, primaryKey: true }
    culture:     { type: varchar, size:   7, required: true, primaryKey: true, isCulture: true }
    content: { phpName: Content, type: LONGVARCHAR, required: true }

Basically how the build-schema work flow works like this

1. Execute symfony propel: build-schema
2. The sfPropelBuildSchemaTask script will create an schema.xml file from the database
3. Then sfPropelBuildSchemaTask will create a schema.yml from the newly created schema.xml before deleting it

The way to fix this problem is to modify the schema.xml before it transformed into the schema.yml

This is how I fixed the problem.

1. You need to find and modify the sfPropelBuildSchemaTask.class.php file
2. Find:  protected function reverseDatabase()
3. You will see where they define the yml and the xml path

           $xmlSchemaPath = sfConfig::get('sf_config_dir') . '/' . $name . '.xml';
           $ymlSchemaPath = sfConfig::get('sf_config_dir') . '/' . $name . '.yml';

4. below this you should find an if block. There is no use modifying the xml if it doest exists

   if (file_exists($xmlSchemaPath)) {

5. Immediately at the start of the ‘if’ block added this code, you may need to modify to fit your situation…

               $I18ntables = array();
               $schema = file_get_contents($xmlSchemaPath);
   
               $xml = simplexml_load_file($xmlSchemaPath);
   
               //iterate once to get all i18n tables
               foreach ($xml->table as $table) {
                   foreach ($table->attributes() as $attributeskey0 => $attributesvalue1) {
                       if ($attributeskey0 == 'name') {
                           if (preg_match("/_i18n/", $attributesvalue1)) {
                               $I18ntables[] = str_replace('_i18n', '', $attributesvalue1);
                           }
                       }
                   }
               }
                //iterate again because we dont know the order of the tables
                //grab the sister tables and add the new attributes
               foreach ($xml->table as $table) {
                   foreach ($table->attributes() as $attributeskey0 => $attributesvalue1) {
                       if ($attributeskey0 == 'name') {
                           if (in_array($attributesvalue1, $I18ntables)) {
                               $table->addAttribute('isI18N', "true");
                               $table->addAttribute('i18nTable', strtolower($attributesvalue1 . '_i18n'));
                           }
                           //as we are scrolling through the tables again, grab the i18n table
                           //find the column called 'culture' and add a new attribut to that
                           if (preg_match("/_i18n/", $attributesvalue1)) {
   
                               foreach ($table->children() as $columnkey0 => $columnvalue1) {
                                   if ($columnkey0 == 'column') {
                                       foreach ($columnvalue1->attributes() as $collAttrKey0 => $collAttrValue1) {
                                           if ($collAttrKey0 == 'name') {
                                               if ($collAttrValue1 == 'culture') {
   
                                                   $columnvalue1->addAttribute('isCulture', 'true');
                                               }
                                           }
                                       }
                                   }
                               }
                           }
                       }
                   }
               }
               //the schema has changed now so assign it here
               $schema = $xml->asXML();

There are a couple of rules you need to know to use my code

• the 2 I18N tables must be named the same , except for the ‘_i18n’ appendment of course
• The column where you set the culture must be named ‘culture’