function login()
{
if ($username == null) {
echo "E-Mail is a required field.";
} else {
if ($password == null) {
echo "Password is a required field.";
} else {
ProgressIndicator::Show();
$url = "http://demo.kikapptools.com/Gastos/crud/Login.php";
$httpClient_post = new httpClient();
$inputMetodo = new InputText();
$inputMetodo->setValue("login");
$httpClient_post->addVariable('username', $username);
$httpClient_post->addVariable('password', $password);
$result = $httpClient_post->Execute('POST', $url);
$id_user = new InputText();
$struct = array("response" => DataType::Character(50));
Data::FromJson($struct, $result);
$id_user = $struct['response'];
ProgressIndicator::Hide();
if ($id_user != "0") {
StorageAPI::Set("token", $id_user);
AndroidAction::GoHome();
} else {
echo "Wrong user or password";
}
}
}
}
public function typeToString(DataType $type)
{
if ($type->getId() == DataType::BINARY) {
return 'BLOB';
}
return parent::typeToString($type);
}
public function typeToString(DataType $type)
{
switch ($type->getId()) {
case DataType::BIGINT:
return 'INTEGER';
case DataType::BINARY:
return 'BLOB';
}
return parent::typeToString($type);
}
public function typeToString(DataType $type)
{
if ($type->getId() == DataType::IP) {
return 'varchar(19)';
}
if ($type->getId() == DataType::IP_RANGE) {
return 'varchar(41)';
}
return $type->getName();
}
private function displaySharing()
{
$url = UrlRewriting::GetUrlByAlias("admin/data/share", "datatype=" . urlencode($_GET['show']) . "&blank=true");
$shares = Language::DirectTranslateHtml("SHARES");
$newshare = Language::DirectTranslateHtml("NEW_SHARE");
echo "<h2>" . $shares . "</h2><a href=\"javascript:showIFrameDialog('" . $newshare . "',300,200,'" . $url . "',true);\">" . $newshare . "</a>";
$datatype = new DataType($_GET['show']);
foreach ($datatype->getShares() as $share) {
echo "<br /><br />" . $share->GetName() . ":<br /><a href='" . $share->getUrl() . "'>" . $share->getUrl() . "</a>";
}
}
/**
* The NumberParser can parse integer and double datatypes.
* With NumberParser::setLanguage(en/de/it/es ...) one could set up a Language.
* The default language is english (en).
*
* @param DataType $datatype
*/
public function __construct($datatype)
{
$this->setLanguage('en');
$this->dataType = $datatype;
if ($datatype->getName() == 'xsd:integer') {
$this->integer = true;
} elseif ($datatype->getName() == 'xsd:double') {
$this->double = true;
} else {
throw new DataParserException("wrong parameter.");
}
}
/**
* test if the method getInputType returns the correct inputtype
*/
public function testGetInputType()
{
$DataType = new DataType();
$this->assertEquals('number', $DataType->getInputType('int'));
$this->assertEquals('checkbox', $DataType->getInputType('bool'));
$this->assertEquals('file', $DataType->getInputType('blob'));
$this->assertEquals('single', $DataType->getInputType('binary'));
$this->assertEquals('text', $DataType->getInputType('text'));
$this->assertEquals('select-multiple', $DataType->getInputType('set'));
$this->assertEquals('date', $DataType->getInputType('date'));
$this->assertEquals('datetime', $DataType->getInputType('datetime'));
$this->assertEquals('number', $DataType->getInputType('year'));
}
public function typeToString(DataType $type)
{
if ($type->getId() == DataType::BINARY) {
return 'BYTEA';
}
if (defined('POSTGRES_IP4_ENABLED')) {
if ($type->getId() == DataType::IP) {
return 'ip4';
}
if ($type->getId() == DataType::IP_RANGE) {
return 'ip4r';
}
}
return parent::typeToString($type);
}
/**
* DataType for value
*
* @param mixed $pValue
* @return string
*/
public static function dataTypeForValue($pValue = null)
{
// Match the value against a few data types
if ($pValue === null) {
return DataType::TYPE_NULL;
} elseif ($pValue === '') {
return DataType::TYPE_STRING;
} elseif ($pValue instanceof \PHPExcel\RichText) {
return DataType::TYPE_INLINE;
} elseif ($pValue[0] === '=' && strlen($pValue) > 1) {
return DataType::TYPE_FORMULA;
} elseif (is_bool($pValue)) {
return DataType::TYPE_BOOL;
} elseif (is_float($pValue) || is_int($pValue)) {
return DataType::TYPE_NUMERIC;
} elseif (preg_match('/^[\\+\\-]?([0-9]+\\.?[0-9]*|[0-9]*\\.?[0-9]+)([Ee][\\-\\+]?[0-2]?\\d{1,3})?$/', $pValue)) {
$tValue = ltrim($pValue, '+-');
if (is_string($pValue) && $tValue[0] === '0' && strlen($tValue) > 1 && $tValue[1] !== '.') {
return DataType::TYPE_STRING;
} elseif (strpos($pValue, '.') === false && $pValue > PHP_INT_MAX) {
return DataType::TYPE_STRING;
}
return DataType::TYPE_NUMERIC;
} elseif (is_string($pValue) && array_key_exists($pValue, DataType::getErrorCodes())) {
return DataType::TYPE_ERROR;
}
return DataType::TYPE_STRING;
}
protected function getInternalColumns()
{
if (is_null($this->columns)) {
$this->columns = array();
$keyLength = $this->getKeyLength();
if (is_null($keyLength)) {
throw new ErrorException("Cannot create meta-table-schema for indicies when no key-length is specified!");
}
$columnPage = new Column();
for ($i = 1; $i <= 33; $i++) {
$columnPage->setName("ref{$i}");
$columnPage->setDataType(DataType::INT());
$columnPage->setLength($keyLength);
$columnPage->setExtraFlags(Column::EXTRA_PRIMARY_KEY);
$this->columns[] = clone $columnPage;
$columnPage->setName("val{$i}");
$columnPage->setDataType(DataType::INT());
$columnPage->setLength($keyLength);
$columnPage->setExtraFlags(Column::EXTRA_PRIMARY_KEY);
$this->columns[] = clone $columnPage;
$columnPage->setName("row{$i}");
$columnPage->setDataType(DataType::INT());
$columnPage->setLength($keyLength);
$columnPage->setExtraFlags(Column::EXTRA_PRIMARY_KEY);
$this->columns[] = clone $columnPage;
}
}
return $this->columns;
}
function save()
{
if ($username == null) {
echo "E-Mail is a required field.";
} else {
if ($password == null) {
echo "Password is a required field.";
} else {
if ($password != $password2) {
echo "Please make sure your passwords match.";
} else {
ProgressIndicator::Show();
$url = "http://demo.kikapptools.com/Gastos/crud/updateUser.php";
$httpClient_post = new httpClient();
$inputMetodo = new InputText();
$inputMetodo->setValue("login");
$httpClient_post->addVariable('username', $username);
$httpClient_post->addVariable('password', $password);
$httpClient_post->addVariable('id', $token);
$result = $httpClient_post->Execute('POST', $url);
$id_user = new InputText();
$struct = array("response" => DataType::Character(50));
Data::FromJson($struct, $result);
$id_user = $struct['response'];
ProgressIndicator::Hide();
AndroidAction::GoHome();
}
}
}
}
/**
*
* @param DataType $type
* @return DataTypeValidator
*/
public static function getByDataType(DataType $type)
{
$res = array();
$dataTypeID = DataBase::Current()->EscapeString($type->getID());
$rows = DataBase::Current()->ReadRows("SELECT * FROM {'dbprefix'}datatype_validator WHERE dataType = '" . $dataTypeID . "'");
foreach ($rows as $row) {
$validator = new DataTypeValidator();
$validator->id = $row->id;
$validator->dataTypeID = $row->dataType;
$validator->dataType = $type;
$validator->select = $row->select;
$validator->message = $row->message;
$res[] = $validator;
}
return $res;
}
function login()
{
if ($email == null) {
echo "E-Mail is a required field.";
} else {
if ($pass == null) {
echo "Password is a required field.";
} else {
ProgressIndicator::Show();
$url = "http://demo.kikapptools.com/magento/apiKikApp/api.php?metodo=login";
$httpClient_post = new httpClient();
$httpClient_post->addVariable('email', $email);
$httpClient_post->addVariable('password', $pass);
$result = $httpClient_post->Execute('POST', $url);
$customerToken = new InputText();
$userName = new InputText();
$response = array("customerToken" => DataType::Character(150), "userName" => DataType::Character(150));
Data::FromJson($response, $result);
$customerToken = $response['customerToken'];
$userName = $response['userName'];
ProgressIndicator::Hide();
if ($customerToken != "") {
StorageAPI::Set("token", $customerToken);
StorageAPI::Set("userName", $userName);
AndroidAction::GoHome();
} else {
echo "Invalid user";
}
}
}
}
/**
* Makes this instance in effect a reference to another FileList
* instance.
* @param Reference $r
* @throws BuildException
*/
public function setRefid(Reference $r)
{
if ($this->dir !== null || count($this->filenames) !== 0) {
throw $this->tooManyAttributes();
}
parent::setRefid($r);
}
function save()
{
if ($email == null) {
echo "EMail is a required field.";
} else {
if ($password == null) {
echo "Password is a required field.";
} else {
if ($password != $password_2) {
echo "Please make sure your passwords match.";
} else {
ProgressIndicator::Show();
$url = "http://demo.kikapptools.com/Gastos/crud/Register.php";
$http = new httpClient();
$http->addVariable('username', $email);
$http->addVariable('passcode', $password);
//lo de pasar la clave a md5 lo hace el Register.php
$result = $http->Execute('POST', $url);
$struct = array("id_usuario" => DataType::Character(101));
Data::FromJson($struct, $result);
$id_user = new InputText(100);
$id_user = $struct['id_usuario'];
if ($id_user == "0") {
echo "User already signed up";
} else {
echo "Signed up succesfully.";
StorageAPI::Set("token", $id_user);
AndroidAction::GoHome();
}
}
}
}
}
/**
* Makes this instance in effect a reference to another PatternSet
* instance.
* You must not set another attribute or nest elements inside
* this element if you make it a reference.
*/
function setRefid(Reference $r)
{
if (!empty($this->includeList) || !empty($this->excludeList)) {
throw $this->tooManyAttributes();
}
parent::setRefid($r);
}
/**
* Returns the initial value of the column.
*
* @return mixed
*/
public function getInitialValue()
{
if ($this->hasDefaultValue) {
return $this->defaultValue;
}
return $this->isNullable ? null : $this->dataType->getInitialValue();
}
function load_data()
{
$url = "http://www.devxtend.com/Gecko/samples/3_2/rest/main_load_data";
$hc = new httpClient();
$rs = $hc->Execute("GET", $url);
$struct = array(array("id" => DataType::Character(6), "name" => DataType::Character(100)));
Data::FromJson($struct, $rs);
}
function load_cat()
{
$url = "http://demo.kikapptools.com/Gastos/crud/getCategories.php";
$hc = new httpClient();
$rs = $hc->Execute("GET", $url);
$struct = array(array("idCat" => DataType::Numeric(11), "name" => DataType::Character(80), "desc" => DataType::Character(200)));
Data::FromJson($struct, $rs);
}
/**
*
* @param DataType $dataType
* @return array
*/
public static function getByDataType(DataType $dataType)
{
$res = array();
$dataTypeID = DataBase::Current()->EscapeString($dataType->getID());
$fields = DataBase::Current()->ReadRows("SELECT * FROM {'dbprefix'}datafields WHERE datatype = '" . $dataTypeID . "'");
foreach ($fields as $field) {
$fieldObj = new DataField();
$fieldObj->id = $field->id;
$fieldObj->dataTypeID = $field->dataType;
$fieldObj->dataType = $dataType;
$fieldObj->displayName = $field->displayName;
$fieldObj->dataName = $field->dataName;
$fieldObj->validatorID = $field->validator;
$res[] = $fieldObj;
}
return $res;
}
function loadCity()
{
$url = "http://demo.kikapptools.com/HttpClientEjemplo/crud/getCity.php";
$httpClient = new httpClient();
$result = $httpClient->Execute('GET', $url);
$struct = array("nombreCiudad" => DataType::Character(150));
Data::FromJson($struct, $result);
$city = $product['nombreCiudad'];
}
public function testGetList()
{
$primitive = Primitive::enumeration('enum')->of('DataType');
$enum = DataType::create(DataType::getAnyId());
$this->assertEquals($primitive->getList(), $enum->getObjectList());
$primitive->setDefault($enum);
$this->assertEquals($primitive->getList(), $enum->getObjectList());
$primitive->import(array('enum' => DataType::getAnyId()));
$this->assertEquals($primitive->getList(), $enum->getObjectList());
}
public function run()
{
$type = DataType::getInputType($this->column->dbType);
$this->htmlOptions += $this->fixedHtmlOptions[$type];
$column = $this->column->name;
$name = isset($this->htmlOptions['name']) ? $this->htmlOptions['name'] : 'Row[' . $column . ']';
switch ($type) {
case 'number':
echo CHtml::activeTextField($this->row, $column, $this->htmlOptions);
break;
case 'select':
echo CHtml::activeDropDownList($this->row, $column, $this->getEnumValues(), $this->htmlOptions);
break;
case 'select-multiple':
#echo CHtml::activeListBox($this->row, $column, $this->getSetValues(), $this->htmlOptions);
echo CHtml::listBox($name, $this->row->getAttributeAsArray($column), $this->getSetValues(), $this->htmlOptions);
break;
case 'text':
echo CHtml::activeTextArea($this->row, $column, $this->htmlOptions);
break;
case 'file':
echo '<script type="text/javascript">
$(document).ready(function() {
$("# echo CHtml::$idPrefix; ?>").submit(function() {
alert("ok1");
});
});
</script>';
echo CHtml::activeFileField($this->row, $column, $this->htmlOptions);
break;
case 'date':
$this->SetDateTimeHtmlOptions($column);
echo CHtml::activeTextField($this->row, $column, $this->htmlOptions);
echo '<script type="text/javascript">
$(document).ready(function() {
$("#' . $this->htmlOptions['id'] . '").datepicker({showOn: "button", dateFormat: "yy-mm-dd", buttonImage: "' . ICONPATH . '/16/calendar.png' . '", buttonImageOnly: true, buttonText: "' . Yii::t('core', 'showCalendar') . '"});
});
</script>';
break;
case 'datetime':
$this->SetDateTimeHtmlOptions($column);
echo CHtml::activeTextField($this->row, $column, $this->htmlOptions);
echo '<script type="text/javascript">
$(document).ready(function() {
now = new Date();
$("#' . $this->htmlOptions['id'] . '").datepicker({showOn: "button", dateFormat: "yy-mm-dd " + now.getHours() + ":" + now.getMinutes() + ":" + now.getSeconds(), buttonImage: "' . ICONPATH . '/16/calendar.png' . '", buttonImageOnly: true, buttonText: "' . Yii::t('core', 'showCalendar') . '"});
});
</script>';
break;
default:
echo CHtml::activeTextField($this->row, $column, $this->htmlOptions);
break;
}
}
public function getValue($flag = self::AS_STRING)
{
$array = $this->value;
$out = $this->arraySetString($this->value, $flag);
if ($flag == self::AS_STRING) {
$this->value = $out;
$out = parent::getValue();
$this->value = $array;
}
return $out;
}
function clientStart()
{
$token = StorageAPI::Get("token");
$url = "http://demo.kikapptools.com/Gastos/crud/getAccount.php";
$httpClient = new httpClient();
$httpClient->addVariable("id", $token);
$result = $httpClient->Execute('POST', $url);
$struct = array("money" => DataType::Numeric(11));
Data::FromJson($struct, $result);
$input = $struct['money'];
}
public function testIsValid()
{
$this->assertTrue(DataType::text(true)->isValid(null));
$this->assertFalse(DataType::text(false)->isValid(null));
$this->assertFalse(DataType::integer()->isValid('2'));
$this->assertFalse(DataType::integer()->isValid(2147483648.0));
$this->assertTrue(DataType::integer()->isValid(2147483647));
$this->assertTrue(DataType::integer()->isValid(-2147483648.0));
$this->assertTrue(DataType::string(5)->isValid('test1'));
$this->assertFalse(DataType::string(5)->isValid('test12'));
}
public function testImport()
{
$realPrimitive = Primitive::string('stringPrimitive')->required();
$form = Form::create()->add($realPrimitive)->add(Primitive::alias('alias', $realPrimitive))->import(array('alias' => 'Йа строка'));
$errors = $form->getErrors();
$this->assertFalse(isset($errors['stringPrimitive']));
$enumPrimitive = Primitive::enumeration('enumerationPrimitive')->of('DataType')->required();
$form = Form::create()->add($enumPrimitive)->add(Primitive::alias('alias', $enumPrimitive))->import(array('alias' => DataType::getAnyId()));
$errors = $form->getErrors();
$this->assertFalse(isset($errors['enumerationPrimitive']));
}
function start()
{
$url = "http://demo.kikapptools.com/CRMManager/crud/getCompanies.php?companyId=" . $id;
$httpClient = new httpClient();
$result = $httpClient->Execute('GET', $url);
$struct = array("CompanyName" => DataType::Character(100), "CompanyImage" => DataType::Character(200), "CompanyPhone" => DataType::Phone(), "CompanyAddress" => DataType::Address());
Data::FromJson($struct, $result);
$image = $struct['CompanyImage'];
$name = $struct['CompanyName'];
$address = $struct['CompanyAddress'];
$phone = $struct['CompanyPhone'];
}
function load_grid()
{
$url = "http://demo.kikapptools.com/magento/apiKikApp/Categories.php?cId=" . $cat;
$httpClient = new httpClient();
$result = $httpClient->Execute('GET', $url);
$struct = array(array("id" => DataType::Numeric(6), "name" => DataType::Character(150)));
Data::FromJson($struct, $result);
foreach ($struct as $product) {
$id = $product['id'];
$name = $product['name'];
}
}
function load_image()
{
$url = "http://demo.kikapptools.com/magento/apiKikApp/ProductImages.php?pId=" . $id;
$httpClient = new httpClient();
echo $id;
$result = $httpClient->Execute('GET', $url);
$str_images = array(array("url" => DataType::Character(350)));
Data::FromJson($str_images, $result);
foreach ($str_images as $img) {
$image = $img['url'];
}
}
