GetHeaderOnline ( $username, $password, $url );
function WhoAmI($authHeader, $url) {
$xml = "
WhoAmI
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
if ($value->firstChild->textContent == "UserId") {
return $value->lastChild->textContent;
}
}
return null;
}
function CrmGetAccountName($authHeader, $id, $url) {
$xml = "
Target
" . $id . "
systemuser
ColumnSet
false
firstname
lastname
Retrieve
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$firstname = "";
$lastname = "";
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
if ($value->firstChild->textContent == "firstname") {
$firstname = $value->lastChild->textContent;
}
if ($value->firstChild->textContent == "lastname") {
$lastname = $value->lastChild->textContent;
}
}
echo $firstname . " -" . $lastname;
return $firstname . " " . $lastname;
}
function CrmGetContactDataByCard($authHeader, $id, $url) {
$xml="
Query
true
ccs_subwaycardid
Equal
".$id."
And
false
false
contact
0
0
false
false
RetrieveMultiple
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
var_dump($response);
$result=array();
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
$result[$value->firstChild->textContent]=$value->lastChild->textContent;
}
return $result;
}
function CrmGetAccountDataByGuid($authHeader, $id, $url) {
$xml = "
Target
".$id."
systemuser
ColumnSet
true
Retrieve
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$result=array();
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
$result[$value->firstChild->textContent]=$value->lastChild->textContent;
}
return $result;
}
function CrmGetAccountDataByGuid2($authHeader, $id, $url) {
$xml = "
Target
".$id."
ccs_transactions
ColumnSet
true
Retrieve
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$result=array();
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
$result[$value->firstChild->textContent]=$value->lastChild->textContent;
}
return $result;
}
function CrmGetTransactions($authHeader, $id, $url) {
$xml="
Query
true
ccs_cliente
Equal
".$id."
ccs_tipodetransaccion
Equal
2
ccs_fechayhora
OnOrAfter
2016-12-03T10:30:00Z
And
false
false
ccs_transactions
ccs_fechayhora
Descending
0
0
false
false
RetrieveMultiple
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
//var_dump($response);
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$result=array();
$counter=-1;
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
if($value->firstChild->textContent!="EntityCollection"){
if($value->firstChild->textContent=="statecode"){$counter++;}
$result[$counter][$value->firstChild->textContent]=$value->lastChild->textContent;
}
}
return $result;
}
function CrmGetMovements($authHeader, $id, $url) {
$xml="
Query
true
ccs_cliente
Equal
".$id."
ccs_fechadelmovimiento
OnOrAfter
2016-12-03T10:30:00Z
And
false
false
ccs_movimientodeproductos
ccs_fechadelmovimiento
Descending
0
0
false
false
RetrieveMultiple
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$result=array();
$counter=-1;
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
if($value->firstChild->textContent!="EntityCollection"){
if($value->firstChild->textContent=="ccs_monto"){$counter++;}
$result[$counter][$value->firstChild->textContent]=$value->lastChild->textContent;
}
}
return $result;
}
function CrmGetBonifications($authHeader, $id, $url) {
$xml="
Query
true
ccs_cliente
Equal
".$id."
ccs_tipodetransaccion
NotEqual
2
ccs_fechayhora
OnOrAfter
2016-12-03T10:30:00Z
ccs_puntosasignados
Equal
true
And
false
false
ccs_transactions
ccs_fechayhora
Descending
0
0
false
false
RetrieveMultiple
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
//var_dump($response);
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$result=array();
$counter=-1;
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
if($value->firstChild->textContent!="EntityCollection"){
if($value->firstChild->textContent=="statecode"){$counter++;}
$result[$counter][$value->firstChild->textContent]=$value->lastChild->textContent;
}
}
return $result;
}
function CrmGetProduct($authHeader, $id, $url) {
$xml="
Query
true
productid
Equal
".$id."
And
false
false
product
0
0
false
false
RetrieveMultiple
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
//var_dump($response);
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$result=array();
$counter=-1;
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
if($value->firstChild->textContent!="EntityCollection"){
if($value->firstChild->textContent=="statecode"){$counter++;}
$result[$counter][$value->firstChild->textContent]=$value->lastChild->textContent;
}
}
return $result;
}
function CrmGetBodega($authHeader, $id, $url) {
$xml="
Query
true
ccs_bodegaid
Equal
".$id."
And
false
false
ccs_bodega
0
0
false
false
RetrieveMultiple
";
$executeSoap = new CrmExecuteSoap ();
$response = $executeSoap->ExecuteSOAPRequest ( $authHeader, $xml, $url );
//var_dump($response);
$responsedom = new DomDocument ();
$responsedom->loadXML ( $response );
$result=array();
$counter=-1;
$values = $responsedom->getElementsbyTagName ( "KeyValuePairOfstringanyType" );
foreach ( $values as $value ) {
if($value->firstChild->textContent!="EntityCollection"){
if($value->firstChild->textContent=="statecode"){$counter++;}
$result[$counter][$value->firstChild->textContent]=$value->lastChild->textContent;
}
}
return $result;
}
?>