ttWorkHelper.class.php

<?php
// +----------------------------------------------------------------------+
// | Anuko Time Tracker
// +----------------------------------------------------------------------+
// | Copyright (c) Anuko International Ltd. (https://www.anuko.com)
// +----------------------------------------------------------------------+
// | LIBERAL FREEWARE LICENSE: This source code document may be used
// | by anyone for any purpose, and freely redistributed alone or in
// | combination with other software, provided that the license is obeyed.
// |
// | There are only two ways to violate the license:
// |
// | 1. To redistribute this code in source form, with the copyright
// |    notice or license removed or altered. (Distributing in compiled
// |    forms without embedded copyright notices is permitted).
// |
// | 2. To redistribute modified versions of this code in *any* form
// |    that bears insufficient indications that the modifications are
// |    not the work of the original author(s).
// |
// | This license applies to this document only, not any other software
// | that it may be combined with.
// |
// +----------------------------------------------------------------------+
// | Contributors:
// | https://www.anuko.com/time_tracker/credits.htm
// +----------------------------------------------------------------------+

define('TT_CURL_SUCCESS', 1);

// Class ttWorkHelper is used to help with operations with the Remote Work plugin.
// It does everything via curl calls to a Remote Work server using its API.
class ttWorkHelper {
  var $errors = null;            // Errors go here. Set in constructor by reference.
  var $work_server_uri = null;   // Location of work server.
  var $register_uri = null;      // URI to register with remote work server.
  var $put_own_work_item_uri = null;  // URI to publish own work item.
  var $get_own_work_item_uri = null;  // URI to get own work item details.
  var $get_own_work_item_offer_uri = null;  // URI to get own work item offer.
  var $accept_own_work_item_offer_uri = null; // URI to accept own work item offer.
  var $decline_own_work_item_offer_uri = null; // URI to decline own work item offer.
  var $get_own_work_item_offers_uri = null; // URI to get offers on own work item.
  var $get_own_work_items_uri = null; // URI to get own work items for group.
  var $get_available_work_items_uri = null; // URI to get available work items for group.
  var $get_available_work_item_uri = null;  // URI to get a single available work item.
  var $delete_own_work_item_uri = null;     // URI to delete own work item.
  // TODO: design how (and what) to delete when a group is deleted.
  var $update_own_work_item_uri = null;  // URI to update own work item.
  var $update_own_work_item_on_offer_uri = null;  // URI to update own work item posted on offer.
  var $put_own_offer_uri = null;     // URI to publish own offer.
  var $get_own_offer_uri = null;     // URI to get own offer details.
  var $get_own_offers_uri = null;    // URI to get own offers.
  var $get_available_offers_uri = null; // URI to get available offers.
  var $get_available_offer_uri = null;  // URI to get a single available offer.
  var $get_group_items_uri = null;      // URI to get all group items in one API call.
  var $delete_own_offer_uri = null; // URI to delete own offer.
  var $update_own_offer_uri = null; // URI to update own offer.
  var $send_message_to_work_owner_uri = null; // URI to send message to work owner.
  var $send_message_to_offer_owner_uri = null; // URI to send message to offer owner.
  var $site_id = null;              // Site id for work server.
  var $site_key = null;             // Site key for work server.

  // Constructor.
  function __construct(&$errors) {
    $this->errors = &$errors;

    $this->work_server_uri = defined('WORK_SERVER_URI') ? WORK_SERVER_URI : "https://www.anuko.com/work/";

    // Note: at some point a need will arise for API versioning.
    // When this happens, we will append an API version number to the end of URI,
    // for example: register_0_1 instead of register.
    // This should theoretically allow a remote work server to be able to work with
    // a complete variety of deployed clients, including those without versions.
    $this->register_uri = $this->work_server_uri.'register'; // register_0_0
    $this->put_own_work_item_uri = $this->work_server_uri.'putownworkitem';
    $this->get_own_work_item_uri = $this->work_server_uri.'getownworkitem';
    $this->get_own_work_item_offer_uri = $this->work_server_uri.'getownworkitemoffer';
    $this->get_own_work_item_offers_uri = $this->work_server_uri.'getownworkitemoffers';
    $this->get_own_work_items_uri = $this->work_server_uri.'getownworkitems';
    $this->get_available_work_items_uri = $this->work_server_uri.'getavailableworkitems';
    $this->get_available_work_item_uri = $this->work_server_uri.'getavailableworkitem';
    $this->delete_own_work_item_uri = $this->work_server_uri.'deleteownworkitem';
    $this->accept_own_work_item_offer_uri = $this->work_server_uri.'acceptownworkitemoffer';
    $this->decline_own_work_item_offer_uri = $this->work_server_uri.'declineownworkitemoffer';
    $this->update_own_work_item_uri = $this->work_server_uri.'updateownworkitem';
    $this->update_own_work_item_on_offer_uri = $this->work_server_uri.'updateownworkitemonoffer';
    $this->put_own_offer_uri = $this->work_server_uri.'putownoffer';
    $this->get_own_offer_uri = $this->work_server_uri.'getownoffer';
    $this->get_own_offers_uri = $this->work_server_uri.'getownoffers';

    $this->get_available_offers_uri = $this->work_server_uri.'getavailableoffers';
    $this->get_available_offer_uri = $this->work_server_uri.'getavailableoffer';
    $this->get_group_items_uri = $this->work_server_uri.'getgroupitems';
    $this->delete_own_offer_uri = $this->work_server_uri.'deleteownoffer';
    $this->update_own_offer_uri = $this->work_server_uri.'updateownoffer';
    $this->send_message_to_work_owner_uri = $this->work_server_uri.'sendmessagetoworkowner';
    $this->send_message_to_offer_owner_uri = $this->work_server_uri.'sendmessagetoofferowner';
    $this->checkSiteRegistration();
  }

  // checkSiteRegistration - obtains site id and key from local database.
  // If not found, it tries to register with remote work server.
  function checkSiteRegistration() {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    // Obtain site id.
    $sql = "select param_value as id from tt_site_config where param_name = 'worksite_id'";
    $res = $mdb2->query($sql);
    $val = $res->fetchRow();
    if (!$val) {
      // No site id found, need to register.
      $group_id = $user->getGroup();
      $org_id = $user->org_id;
      $fields = array('lang' => urlencode($user->lang),
        'name' => urlencode('time tracker'),
        'origin' => urlencode('time tracker source'),
        'org_id' => urlencode($org_id),
        'group_id' => urlencode($group_id),
        'group_name' => urlencode(base64_encode($user->getGroupName())),
        'user_id' => urlencode($user->getUser()),
        'user_name' => urlencode(base64_encode($user->getName())),
        'user_email' => urlencode(base64_encode($user->getEmail())),
        'user_ip' => urlencode($_SERVER['REMOTE_ADDR']));

      // Urlify the data for the POST.
      foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
      $fields_string = rtrim($fields_string, '&');

      // Open connection.
      $ch = curl_init();

      // Set the url, number of POST vars, POST data.
      curl_setopt($ch, CURLOPT_URL, $this->register_uri);
      curl_setopt($ch, CURLOPT_POST, true);
      curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
      curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

      // Execute a post request.
      $result = curl_exec($ch);

      // Close connection.
      curl_close($ch);

      if (!$result) {
        $this->errors->add($i18n->get('error.remote_work'));
        return false;
      }

      $result_array = json_decode($result, true);

      // Check for errors.
      $call_status = $result_array['call_status'];
      if (!$call_status) {
        $this->errors->add($i18n->get('error.remote_work'));
        return false;
      }
      if ($call_status['code'] != TT_CURL_SUCCESS) {
        $this->errors->add($call_status['error']);
        return false;
      }

      $reg_status = $result_array['reg_status']; // Registration status.
      if ($reg_status['site_id'] && $reg_status['site_key']) {
        $this->site_id = $reg_status['site_id'];
        $this->site_key = $reg_status['site_key'];

        // Registration successful. Store id and key locally for future use.
        $sql = "insert into tt_site_config values('worksite_id', $this->site_id, now(), null)";
        $mdb2->exec($sql);
        $sql = "insert into tt_site_config values('worksite_key', ".$mdb2->quote($this->site_key).", now(), null)";
        $mdb2->exec($sql);
      } else {
        $this->errors->add($i18n->get('error.remote_work'));
      }
    } else {
      // Site id found.
      $this->site_id = $val['id'];

      // Obtain site key.
      $sql = "select param_value as site_key from tt_site_config where param_name = 'worksite_key'";
      $res = $mdb2->query($sql);
      $val = $res->fetchRow();
      $this->site_key = $val['site_key'];
    }
  }

  // putOwnWorkItem - publishes a work item in remote work server.
  //
  // Note about some fields using additional base64 encoding.
  // There is a problem with data posted by curl calls on the server side for
  // some languages. Data arrives corrupted.
  //
  // For example: consider a case for a single Russian letter ф in the subject field.
  // UTF-8 encoding for ф: 0xD1 0x84 (2 bytes).
  // urlencoded ф: %D1%84 - a string of 6 characters.
  // If we use a curl call like here with only urlencoded ф, what arrives on the server in POST is "C3 91 C2 84"
  // no idea what it is.
  //
  // A workaround for now is to use use an additional base64 encoding for all text fields,
  // which are decoded back to utf-8 strings on the server side.
  function putOwnWorkItem($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;
    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($fields['offer_id']),
      'type' => urlencode($fields['type']),
      'subject' => urlencode(base64_encode($fields['subject'])),
      'descr_short' => urlencode(base64_encode($fields['descr_short'])),
      'descr_long' => urlencode(base64_encode($fields['descr_long'])),
      'currency' => urlencode($fields['currency']),
      'amount' => urlencode($fields['amount']),
      'created_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'created_by' => urlencode($user->getUser()),
      'created_by_name' => urlencode(base64_encode($user->getName())),
      'created_by_email' => urlencode(base64_encode($user->getEmail()))
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->put_own_work_item_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // updateOwnWorkItem - updates a work item in remote work server.
  function updateOwnWorkItem($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'group_key' => urlencode($user->getGroupKey()),
      'work_id' => urlencode($fields['work_id']),
      'type' => urlencode($fields['type']),
      'subject' => urlencode(base64_encode($fields['subject'])),
      'descr_short' => urlencode(base64_encode($fields['descr_short'])),
      'descr_long' => urlencode(base64_encode($fields['descr_long'])),
      'currency' => urlencode($fields['currency']),
      'amount' => urlencode($fields['amount']),
      'modified_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'modified_by' => urlencode($user->getUser()),
      'modified_by_name' => urlencode(base64_encode($user->getName())),
      'modified_by_email' => urlencode(base64_encode($user->getEmail()))
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->update_own_work_item_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // updateOwnWorkItemOnOffer - updates own work item posted on offer in remote work server.
  function updateOwnWorkItemOnOffer($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'group_key' => urlencode($user->getGroupKey()),
      'work_id' => urlencode($fields['work_id']),
      'descr_short' => urlencode(base64_encode($fields['descr_short'])),
      'descr_long' => urlencode(base64_encode($fields['descr_long'])),
      'modified_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'modified_by' => urlencode($user->getUser()),
      'modified_by_name' => urlencode(base64_encode($user->getName())),
      'modified_by_email' => urlencode(base64_encode($user->getEmail()))
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->update_own_work_item_on_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // getOwnWorkItems - obtains a list of work items this group is currently outsourcing.
  function getOwnWorkItems() {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey())
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_own_work_items_iri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $active_work = $result_array['active_work'];
    return $active_work;
  }

  // getAvailableWorkItems - obtains a list of available work items this group can  bid on.
  function getAvailableWorkItems() {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id)
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_available_work_items_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $available_work = $result_array['available_work'];
    return $available_work;
  }

  // getOwnWorkItem - gets work item details from remote work server.
  function getOwnWorkItem($work_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'work_id' => urlencode($work_id));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_own_work_item_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $work_item = $result_array['work_item'];
    return $work_item;
  }

  // getOwnWorkItemOffers - gets offers on own work item from remote work server.
  function getOwnWorkItemOffers($work_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'work_id' => urlencode($work_id));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_own_work_item_offers_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $work_item_offers = $result_array['work_item_offers'];
    return $work_item_offers;
  }

  // deleteOwnWorkItem - deletes work item from remote work server.
  function deleteOwnWorkItem($work_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'work_id' => urlencode($work_id),
      'modified_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'modified_by' => urlencode($user->getUser()),
      'modified_by_name' => urlencode(base64_encode($user->getName())),
      'modified_by_email' => urlencode(base64_encode($user->getEmail())));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->delete_own_work_item_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // putOwnOffer - publishes an offer in remote work server.
  function putOwnOffer($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;
    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'group_key' => urlencode($user->getGroupKey()),
      'work_id' => urlencode($fields['work_id']),
      'subject' => urlencode(base64_encode($fields['subject'])),
      'descr_short' => urlencode(base64_encode($fields['descr_short'])),
      'descr_long' => urlencode(base64_encode($fields['descr_long'])),
      'currency' => urlencode($fields['currency']),
      'amount' => urlencode($fields['amount']),
      'payment_info' => urlencode(base64_encode($fields['payment_info'])),
      'created_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'created_by' => urlencode($user->getUser()),
      'created_by_name' => urlencode(base64_encode($user->getName())),
      'created_by_email' => urlencode(base64_encode($user->getEmail()))
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->put_own_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // getOwnOffers - obtains a list of offers this group made available to other groups.
  function getOwnOffers() {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey())
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_own_offers_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $active_offers = $result_array['active_offers'];
    return $active_offers;
  }

  // getAvailableOffers - obtains a list of available offers from other organizations.
  function getAvailableOffers() {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id)
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_available_offers_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $available_offers = $result_array['available_offers'];
    return $available_offers;
  }

  // getOwnOffer - gets offer details from remote work server.
  function getOwnOffer($offer_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($offer_id));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_own_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $offer = $result_array['offer'];
    return $offer;
  }

  // updateOwnOffer - updates an offer in remote work server.
  function updateOwnOffer($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($fields['offer_id']),
      'subject' => urlencode(base64_encode($fields['subject'])),
      'descr_short' => urlencode(base64_encode($fields['descr_short'])),
      'descr_long' => urlencode(base64_encode($fields['descr_long'])),
      'currency' => urlencode($fields['currency']),
      'amount' => urlencode($fields['amount']),
      'payment_info' => urlencode(base64_encode($fields['payment_info'])),
      'modified_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'modified_by' => urlencode($user->getUser()),
      'modified_by_name' => urlencode(base64_encode($user->getName())),
      'modified_by_email' => urlencode(base64_encode($user->getEmail()))
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->update_own_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // deleteOwnOffer - deletes an offer from remote work server.
  function deleteOwnOffer($offer_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($offer_id),
      'modified_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'modified_by' => urlencode($user->getUser()),
      'modified_by_name' => urlencode(base64_encode($user->getName())),
      'modified_by_email' => urlencode(base64_encode($user->getEmail())));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->delete_own_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // getOwnWorkItemOffer - gets offer details from remote work server
  // for an offer posted on own work item.
  function getOwnWorkItemOffer($offer_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($offer_id));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_own_work_item_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $offer = $result_array['offer'];
    return $offer;
  }

  // declineOwnWorkItemOffer - declines an offer posted on own work item in remote work server.
  function declineOwnWorkItemOffer($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($fields['offer_id']),
      'client_comment' => urlencode(base64_encode($fields['client_comment'])));
      //'modified_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      //'modified_by' => urlencode($user->getUser()),
      //'modified_by_name' => urlencode(base64_encode($user->getName())),
      //'modified_by_email' => urlencode(base64_encode($user->getEmail())));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->decline_own_work_item_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // acceptOwnWorkItemOffer - accepts an offer posted on own work item in remote work server.
  function acceptOwnWorkItemOffer($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($fields['offer_id']),
      'client_comment' => urlencode(base64_encode($fields['client_comment'])),
      'accepted_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'accepted_by' => urlencode($user->getUser()),
      'accepted_by_name' => urlencode(base64_encode($user->getName())),
      'accepted_by_email' => urlencode(base64_encode($user->getEmail())));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->accept_own_work_item_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // getCurrencies - obtains a list of supported currencies.
  static function getCurrencies() {
    $mdb2 = getConnection();

    $sql = "select id, name from tt_work_currencies order by id";
    $res = $mdb2->query($sql);
    if (is_a($res, 'PEAR_Error')) return false;

    while ($val = $res->fetchRow()) {
      $result[] = array('id'=>$val['id'], 'name'=>$val['name']);
    }
    return $result;
  }

  // getCurrencyID - obtains an ID for currency.
  static function getCurrencyID($currency) {
    $mdb2 = getConnection();

    $currency_id = null;
    $sql = "select id from tt_work_currencies where name = ".$mdb2->quote($currency);
    $res = $mdb2->query($sql);
    if (is_a($res, 'PEAR_Error')) return null;

    if($val = $res->fetchRow()) {
      $currency_id = $val['id'];
    }
    return $currency_id;
  }

  // getCurrencyName - obtains currency name using its id.
  static function getCurrencyName($currency_id) {
    $mdb2 = getConnection();

    $currency_name = null;
    $sql = "select name from tt_work_currencies where id = $currency_id";
    $res = $mdb2->query($sql);
    if (is_a($res, 'PEAR_Error')) return null;

    if($val = $res->fetchRow()) {
      $currency_name = $val['name'];
    }
    return $currency_name;
  }

  // getGroupItems - obtains a list of all items relevant to group in one API call to Remote Work Server.
  function getGroupItems() {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_key' => urlencode($user->getGroupKey())
    );

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_group_items_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    unset($result_array['call_status']); // Remove call_status element,
    return $result_array;
  }

  // getAvailableWorkItem - gets available work item details from remote work server.
  function getAvailableWorkItem($work_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'user_id' => urlencode($user->getUser()),
      'user_name' => urlencode(base64_encode($user->getName())),
      'user_email' => urlencode(base64_encode($user->getEmail())),
      'user_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'work_id' => urlencode($work_id));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_available_work_item_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $work_item = $result_array['work_item'];
    return $work_item;
  }

  // getAvailableOffer - gets available offer details from remote work server.
  function getAvailableOffer($offer_id) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'user_id' => urlencode($user->getUser()),
      'user_name' => urlencode(base64_encode($user->getName())),
      'user_email' => urlencode(base64_encode($user->getEmail())),
      'user_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'offer_id' => urlencode($offer_id));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->get_available_offer_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    $offer = $result_array['offer'];
    return $offer;
  }

  // sendMessageToWorkOwner - sends a message to work owner via remote work server.
  function sendMessageToWorkOwner($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'group_key' => urlencode($user->getGroupKey()),
      'work_id' => urlencode($fields['work_id']),
      'sender_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'sender_user_id' => urlencode($user->getUser()),
      'sender_name' => urlencode(base64_encode($user->getName())),
      'sender_email' => urlencode(base64_encode($user->getEmail())),
      'message_body' => urlencode(base64_encode($fields['message_body'])));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->send_message_to_work_owner_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }

  // sendMessageToOfferOwner - sends a message to offer owner via remote work server.
  function sendMessageToOfferOwner($fields) {
    global $i18n;
    global $user;
    $mdb2 = getConnection();

    $group_id = $user->getGroup();
    $org_id = $user->org_id;

    $curl_fields = array('lang' => urlencode($user->lang),
      'site_id' => urlencode($this->site_id),
      'site_key' => urlencode($this->site_key),
      'org_id' => urlencode($org_id),
      'org_key' => urlencode($user->getOrgKey()),
      'group_id' => urlencode($group_id),
      'group_name' => urlencode(base64_encode($user->getGroupName())),
      'group_key' => urlencode($user->getGroupKey()),
      'offer_id' => urlencode($fields['offer_id']),
      'sender_ip' => urlencode($_SERVER['REMOTE_ADDR']),
      'sender_user_id' => urlencode($user->getUser()),
      'sender_name' => urlencode(base64_encode($user->getName())),
      'sender_email' => urlencode(base64_encode($user->getEmail())),
      'message_body' => urlencode(base64_encode($fields['message_body'])));

    // url-ify the data for the POST.
    foreach($curl_fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
    $fields_string = rtrim($fields_string, '&');

    // Open connection.
    $ch = curl_init();

    // Set the url, number of POST vars, POST data.
    curl_setopt($ch, CURLOPT_URL, $this->send_message_to_offer_owner_uri);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    // Execute a post request.
    $result = curl_exec($ch);

    // Close connection.
    curl_close($ch);

    if (!$result) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }

    $result_array = json_decode($result, true);

    // Check for errors.
    $call_status = $result_array['call_status'];
    if (!$call_status) {
      $this->errors->add($i18n->get('error.remote_work'));
      return false;
    }
    if ($call_status['code'] != TT_CURL_SUCCESS) {
      $this->errors->add($call_status['error']);
      return false;
    }

    return true;
  }
}