addons/crm/scripts/php/countrylist.php

   1 <?php
   2     include("xmlrpc.inc");
   3
   4     //Change to fit your configuration
   5     $user = "admin";
   6     $password = "a";
   7     $db = "db_1";
   8     $serverUri = "http://localhost:8069/xmlrpc/";
   9
  10
  11     $client = new xmlrpc_client($serverUri.'common');
  12
  13     $msg = new xmlrpcmsg('login');
  14     $msg->addParam(new xmlrpcval($db, "string"));
  15     $msg->addParam(new xmlrpcval($user, "string"));
  16     $msg->addParam(new xmlrpcval($password, "string"));
  17
  18
  19     $res =  &$client->send($msg);
  20
  21     if(!$res->faultCode()){
  22
  23         $id = $res->value()->scalarval();
  24
  25         $client = new xmlrpc_client($serverUri.'object');
  26
  27         $key = array(new xmlrpcval(array(new xmlrpcval("id", "string"),
  28                     new xmlrpcval(">", "string"),
  29                     new xmlrpcval(0, "int")),"array"),);
  30
  31
  32
  33         $msg = new xmlrpcmsg('execute');
  34         $msg->addParam(new xmlrpcval($db, "string"));
  35         $msg->addParam(new xmlrpcval($id, "int"));
  36         $msg->addParam(new xmlrpcval($password, "string"));
  37         $msg->addParam(new xmlrpcval("res.country","string"));
  38         $msg->addParam(new xmlrpcval("search", "string"));
  39         $msg->addParam(new xmlrpcval($key, "array"));
  40         $msg->addParam(new xmlrpcval(0, "int"));
  41         $msg->addParam(new xmlrpcval(0, "int"));
  42         $msg->addParam(new xmlrpcval("id ASC", "string"));
  43
  44         $res = &$client->send($msg);
  45
  46         if(!$res->faultCode())
  47         {
  48             $val = $res->value()->scalarval();
  49
  50             $ides = array();
  51
  52             for ($i=0 ; $i<count($val); $i++)
  53             {
  54                 array_push($ides, new xmlrpcval($val[$i]->scalarval(), "int"));
  55             }
  56
  57             $client = new xmlrpc_client($serverUri.'object');
  58
  59             $fields = array(new xmlrpcval("code", "string"), new xmlrpcval("name", "string"));
  60
  61             $msg = new xmlrpcmsg('execute');
  62             $msg->addParam(new xmlrpcval($db, "string"));
  63             $msg->addParam(new xmlrpcval($id, "int"));
  64             $msg->addParam(new xmlrpcval($password, "string"));
  65             $msg->addParam(new xmlrpcval("res.country","string"));
  66             $msg->addParam(new xmlrpcval("read", "string"));
  67             $msg->addParam(new xmlrpcval($ides, "array"));
  68             $msg->addParam(new xmlrpcval($fields, "array"));
  69
  70             $res = &$client->send($msg);
  71
  72             if (!$res->faultCode())
  73             {
  74                 $val = $res->value()->scalarval();
  75
  76                 $select ='<select class="inputbox required"  name="country" id="country" >
  77                             <option value="" selected="selected"> -- Select an Option -- </option>';
  78
  79                 for ($i=0; $i<count($val);$i++)
  80                 {
  81                     $field = $val[$i]->scalarval();
  82                     $select .= '<option value="'.$field['code']->scalarval().'">'.$field['name']->scalarval().'</option>';
  83                 }
  84
  85                 $select .= '</select>';
  86
  87                 echo $select;
  88             }
  89             else
  90             {
  91                 echo "Country not getting";
  92             }
  93         }
  94         else
  95         {
  96             echo "Country list id empty";
  97         }
  98     }
  99     else
 100     {
 101         echo "connection not establish";
 102     }
 103
 104
 105 ?>