/**
* Gets a related entity instance from an entity set identifed by a key
*
* @param ResourceSet $sourceResourceSet The entity set related to
* the entity to be fetched.
* @param object $sourceEntityInstance The related entity instance.
* @param ResourceSet $targetResourceSet The entity set from which
* entity needs to be fetched.
* @param ResourceProperty $targetProperty The metadata of the target
* property.
* @param KeyDescriptor $keyDescriptor The key to identify the entity
* to be fetched.
*
* @return Object/NULL Returns entity instance if found else null
*/
public function getResourceFromRelatedResourceSet(ResourceSet $sourceResourceSet, $sourceEntityInstance, ResourceSet $targetResourceSet, ResourceProperty $targetProperty, KeyDescriptor $keyDescriptor)
{
$result = array();
$srcClass = get_class($sourceEntityInstance);
$navigationPropName = $targetProperty->getName();
$key = null;
foreach ($keyDescriptor->getValidatedNamedValues() as $keyName => $valueDescription) {
$key = $key . $keyName . '=' . $valueDescription[0] . ' and ';
}
$key = rtrim($key, ' and ');
if ($srcClass === 'category') {
if ($navigationPropName === 'products') {
$query = "SELECT * FROM products WHERE CategoryID = '{$sourceEntityInstance->CategoryID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeproducts($stmt);
} else {
die('category does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'customers') {
if ($navigationPropName === 'orders') {
$query = "SELECT * FROM orders WHERE CustomerID = '{$sourceEntityInstance->CustomerID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeorders($stmt);
} else {
die('customers does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'employee') {
if ($navigationPropName === 'employees') {
$query = "SELECT * FROM employees WHERE ReportsTo = '{$sourceEntityInstance->EmployeeID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeemployees($stmt);
} else {
if ($navigationPropName === 'orders') {
$query = "SELECT * FROM orders WHERE EmployeeID = '{$sourceEntityInstance->EmployeeID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeorders($stmt);
} else {
die('employee does not have navigation porperty with name: ' . $navigationPropName);
}
}
} else {
if ($srcClass === 'order_detail') {
} else {
if ($srcClass === 'order') {
if ($navigationPropName === 'order_details') {
$query = "SELECT * FROM order_details WHERE OrderID = '{$sourceEntityInstance->OrderID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeorder_details($stmt);
} else {
die('order does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'product') {
if ($navigationPropName === 'order_details') {
$query = "SELECT * FROM order_details WHERE ProductID = '{$sourceEntityInstance->ProductID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeorder_details($stmt);
} else {
die('product does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'shipper') {
if ($navigationPropName === 'orders') {
$query = "SELECT * FROM orders WHERE ShipVia = '{$sourceEntityInstance->ShipperID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeorders($stmt);
} else {
die('shipper does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'supplier') {
if ($navigationPropName === 'products') {
$query = "SELECT * FROM products WHERE SupplierID = '{$sourceEntityInstance->SupplierID}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeproducts($stmt);
} else {
die('supplier does not have navigation porperty with name: ' . $navigationPropName);
}
}
}
}
}
}
}
}
}
return empty($result) ? null : $result[0];
}
/**
* Gets a related entity instance from an entity set identifed by a key
*
* @param ResourceSet $sourceResourceSet The entity set related to
* the entity to be fetched.
* @param object $sourceEntityInstance The related entity instance.
* @param ResourceSet $targetResourceSet The entity set from which
* entity needs to be fetched.
* @param ResourceProperty $targetProperty The metadata of the target
* property.
* @param KeyDescriptor $keyDescriptor The key to identify the entity
* to be fetched.
*
* @return Object/NULL Returns entity instance if found else null
*/
public function getResourceFromRelatedResourceSet(ResourceSet $sourceResourceSet, $sourceEntityInstance, ResourceSet $targetResourceSet, ResourceProperty $targetProperty, KeyDescriptor $keyDescriptor)
{
$result = array();
$srcClass = get_class($sourceEntityInstance);
$navigationPropName = $targetProperty->getName();
$key = null;
foreach ($keyDescriptor->getValidatedNamedValues() as $keyName => $valueDescription) {
$key = $key . $keyName . '=' . $valueDescription[0] . ' and ';
}
$key = rtrim($key, ' and ');
if ($srcClass === 'Customer') {
if ($navigationPropName === 'Orders') {
$query = "SELECT * FROM Orders WHERE CustomerID = '{$sourceEntityInstance->CustomerID}' and {$key}";
$stmt = sqlsrv_query($this->_connectionHandle, $query);
if ($stmt === false) {
$errorAsString = self::_getSQLSRVError();
ODataException::createInternalServerError($errorAsString);
}
$result = $this->_serializeOrders($stmt);
} else {
ODataException::createInternalServerError('Customer does not have navigation porperty with name: ' . $navigationPropName . ' Contact Service Provider');
}
} else {
if ($srcClass === 'Order') {
if ($navigationPropName === 'Order_Details') {
$query = "SELECT * FROM [Order Details] WHERE OrderID = {$sourceEntityInstance->OrderID}";
$stmt = sqlsrv_query($this->_connectionHandle, $query);
if ($stmt === false) {
$errorAsString = self::_getSQLSRVError();
ODataException::createInternalServerError($errorAsString);
}
$result = $this->_serializeOrderDetails($stmt);
} else {
ODataException::createInternalServerError('Order does not have navigation porperty with name: ' . $navigationPropName . ' Contact Service Provider');
}
}
}
return empty($result) ? null : $result[0];
}
/**
* Validate the given entity instance.
*
* @param object $entityInstance Entity instance to validate
* @param ResourceSet &$resourceSet Resource set to which the entity
* instance belongs to.
* @param KeyDescriptor &$keyDescriptor The key descriptor.
* @param string $methodName Method from which this function
* invoked.
*
* @return void
*
* @throws ODataException
*/
private function _validateEntityInstance($entityInstance, ResourceSet &$resourceSet, KeyDescriptor &$keyDescriptor, $methodName)
{
if (is_null($entityInstance)) {
ODataException::createResourceNotFoundError($resourceSet->getName());
}
$entityName = $resourceSet->getResourceType()->getInstanceType()->getName();
if (!is_object($entityInstance) || !$entityInstance instanceof $entityName) {
ODataException::createInternalServerError(Messages::metadataQueryProviderWrapperIDSQPMethodReturnsUnExpectedType($entityName, $methodName));
}
foreach ($keyDescriptor->getValidatedNamedValues() as $keyName => $valueDescription) {
try {
$keyProperty = new \ReflectionProperty($entityInstance, $keyName);
$keyValue = $keyProperty->getValue($entityInstance);
if (is_null($keyValue)) {
ODataException::createInternalServerError(Messages::metadataQueryProviderWrapperIDSQPMethodReturnsInstanceWithNullKeyProperties($methodName));
}
$convertedValue = $valueDescription[1]->convert($valueDescription[0]);
if ($keyValue != $convertedValue) {
ODataException::createInternalServerError(Messages::metadataQueryProviderWrapperIDSQPMethodReturnsInstanceWithNonMatchingKeys($methodName));
}
} catch (\ReflectionException $reflectionException) {
//throw ODataException::createInternalServerError(
// Messages::orderByParserFailedToAccessOrInitializeProperty(
// $resourceProperty->getName(), $resourceType->getName()
// )
//);
}
}
}
/**
* Gets a related entity instance from an entity set identifed by a key
*
* @param ResourceSet $sourceResourceSet The entity set related to
* the entity to be fetched.
* @param object $sourceEntityInstance The related entity instance.
* @param ResourceSet $targetResourceSet The entity set from which
* entity needs to be fetched.
* @param ResourceProperty $targetProperty The metadata of the target
* property.
* @param KeyDescriptor $keyDescriptor The key to identify the entity
* to be fetched.
*
* @return Object/NULL Returns entity instance if found else null
*/
public function getResourceFromRelatedResourceSet(ResourceSet $sourceResourceSet, $sourceEntityInstance, ResourceSet $targetResourceSet, ResourceProperty $targetProperty, KeyDescriptor $keyDescriptor)
{
$result = array();
$srcClass = get_class($sourceEntityInstance);
$navigationPropName = $targetProperty->getName();
$keys = array();
$namedKeyValues = $keyDescriptor->getValidatedNamedValues();
foreach ($namedKeyValues as $key => $value) {
$keys[] = "{$key} = '{$value['0']}' ";
}
$conditionStr = implode(' AND ', $keys);
switch (true) {
case $srcClass == 'Post':
if ($navigationPropName == 'Tags') {
$query = "SELECT t.*, tt.description" . " FROM wp_terms AS t" . " INNER JOIN wp_term_taxonomy AS tt" . " ON tt.term_id = t.term_id" . " INNER JOIN wp_term_relationships AS tr" . " ON tr.term_taxonomy_id = tt.term_taxonomy_id" . " WHERE tt.taxonomy IN ('post_tag')" . " AND tr.object_id IN ({$sourceEntityInstance->PostID})" . " AND tt.term_id = " . $namedKeyValues['TagID'][0];
$stmt = mysql_query($query);
$result = $this->_serializeTags($stmt);
} elseif ($navigationPropName == 'Categories') {
$query = "SELECT t.*, tt.description" . " FROM wp_terms AS t" . " INNER JOIN wp_term_taxonomy AS tt" . " ON tt.term_id = t.term_id" . " INNER JOIN wp_term_relationships AS tr" . " ON tr.term_taxonomy_id = tt.term_taxonomy_id" . " WHERE tt.taxonomy IN ('category')" . " AND tr.object_id IN ({$sourceEntityInstance->PostID})" . " AND tt.term_id = " . $namedKeyValues['CategoryID'][0];
$stmt = mysql_query($query);
$result = $this->_serializeCategories($stmt);
} else {
if ($navigationPropName == 'Comments') {
$query = "SELECT * FROM `wp_comments`" . " WHERE comment_approved = 1" . " AND comment_post_ID = {$sourceEntityInstance->PostID}" . " AND comment_ID = " . $namedKeyValues['CommentID'][0];
$stmt = mysql_query($query);
$result = $this->_serializeComments($stmt);
} else {
die('Post does not have navigation porperty with name: ' . $navigationPropName);
}
}
break;
case $srcClass == 'Tag':
if ($navigationPropName == 'Posts') {
$query = "SELECT p . *" . " FROM wp_posts AS p" . " INNER JOIN wp_term_relationships AS tr" . " ON p.ID = tr.object_id" . " INNER JOIN wp_term_taxonomy AS tt" . " ON tr.term_taxonomy_id = tt.term_taxonomy_id" . " WHERE tt.term_id = {$sourceEntityInstance->TagID}" . " AND p.post_type = 'post'" . " AND p.post_status = 'publish'" . " AND p.ID = " . $namedKeyValues['PostID'][0];
$stmt = mysql_query($query);
$result = $this->_serializePosts($stmt);
} else {
die('Tag does not have navigation porperty with name: ' . $navigationPropName);
}
break;
case $srcClass == 'Category':
if ($navigationPropName == 'Posts') {
$query = "SELECT p . *" . " FROM wp_posts AS p" . " INNER JOIN wp_term_relationships AS tr" . " ON p.ID = tr.object_id" . " INNER JOIN wp_term_taxonomy AS tt" . " ON tr.term_taxonomy_id = tt.term_taxonomy_id" . " WHERE tt.term_id = {$sourceEntityInstance->CategoryID}" . " AND p.post_type = 'post'" . " AND p.post_status = 'publish'" . " AND p.ID = " . $namedKeyValues['PostID'][0];
$stmt = mysql_query($query);
$result = $this->_serializePosts($stmt);
} else {
die('Category does not have navigation porperty with name: ' . $navigationPropName);
}
break;
case $srcClass == 'Comment':
die('Comment does not have navigation porperty with name: ' . $navigationPropName);
break;
case $srcClass == 'User':
if ($navigationPropName == 'Posts') {
$query = "SELECT * FROM `wp_posts` WHERE" . " wp_posts.post_type = 'post'" . " AND wp_posts.post_status = 'publish'" . " AND wp_posts.post_author = {$sourceEntityInstance->UserID}" . " AND wp_posts.ID = " . $namedKeyValues['PostID'][0];
$stmt = mysql_query($query);
$result = $this->_serializePosts($stmt);
} elseif ($navigationPropName == 'Comments') {
$query = "SELECT * FROM `wp_comments`" . " WHERE comment_approved = 1" . " AND wp_comments.user_id = {$sourceEntityInstance->UserID}" . " AND wp_comments.comment_ID = " . $namedKeyValues['CommentID'][0];
$stmt = mysql_query($query);
$result = $this->_serializeComments($stmt);
} else {
die('User does not have navigation porperty with name: ' . $navigationPropName);
}
break;
}
mysql_free_result($stmt);
return empty($result) ? null : $result[0];
}
/**
* Gets a related entity instance from an entity set identifed by a key
*
* @param ResourceSet $sourceResourceSet The entity set related to
* the entity to be fetched.
* @param object $sourceEntityInstance The related entity instance.
* @param ResourceSet $targetResourceSet The entity set from which
* entity needs to be fetched.
* @param ResourceProperty $targetProperty The metadata of the target
* property.
* @param KeyDescriptor $keyDescriptor The key to identify the entity
* to be fetched.
*
* @return Object/NULL Returns entity instance if found else null
*/
public function getResourceFromRelatedResourceSet(ResourceSet $sourceResourceSet, $sourceEntityInstance, ResourceSet $targetResourceSet, ResourceProperty $targetProperty, KeyDescriptor $keyDescriptor)
{
$result = array();
$srcClass = get_class($sourceEntityInstance);
$navigationPropName = $targetProperty->getName();
$key = null;
foreach ($keyDescriptor->getValidatedNamedValues() as $keyName => $valueDescription) {
$key = $key . $keyName . '=' . $valueDescription[0] . ' and ';
}
$key = rtrim($key, ' and ');
if ($srcClass === 'event') {
if ($navigationPropName === 'event_inventories') {
$query = "SELECT * FROM event_inventory WHERE eventId = '{$sourceEntityInstance->eventId}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeevent_inventories($stmt);
} else {
if ($navigationPropName === 'event_users') {
$query = "SELECT * FROM event_user WHERE eventId = '{$sourceEntityInstance->eventId}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeevent_users($stmt);
} else {
die('event does not have navigation porperty with name: ' . $navigationPropName);
}
}
} else {
if ($srcClass === 'event_inventory') {
} else {
if ($srcClass === 'event_user') {
} else {
if ($srcClass === 'inventory') {
if ($navigationPropName === 'event_inventories') {
$query = "SELECT * FROM event_inventory WHERE itemId = '{$sourceEntityInstance->inventoryItemId}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeevent_inventories($stmt);
} else {
die('inventory does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'item') {
if ($navigationPropName === 'inventories') {
$query = "SELECT * FROM inventory WHERE itemId = '{$sourceEntityInstance->itemId}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeinventories($stmt);
} else {
die('item does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'user') {
if ($navigationPropName === 'events') {
$query = "SELECT * FROM event WHERE userName = '******' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeevents($stmt);
} else {
if ($navigationPropName === 'event_users') {
$query = "SELECT * FROM event_user WHERE userName = '******' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeevent_users($stmt);
} else {
if ($navigationPropName === 'inventories') {
$query = "SELECT * FROM inventory WHERE lastCheckedOutBy = '{$sourceEntityInstance->userName}' and {$key}";
$stmt = mysql_query($query);
if ($stmt === false) {
die(print_r(mysql_error(), true));
}
$result = $this->_serializeinventories($stmt);
} else {
die('user does not have navigation porperty with name: ' . $navigationPropName);
}
}
}
}
}
}
}
}
}
return empty($result) ? null : $result[0];
}
/**
* Gets an entity instance from an entity set identifed by a key
*
* @param ResourceSet $resourceSet The entity set from which an entity needs to be fetched
* @param KeyDescriptor $keyDescriptor The key to identify the entity to be fetched
*
* @return Object/NULL Returns entity instance if found else null
*/
public function getResourceFromResourceSet(ResourceSet $resourceSet, KeyDescriptor $keyDescriptor)
{
$resourceSetName = $resourceSet->getName();
if ($resourceSetName !== 'Customers' && $resourceSetName !== 'Orders' && $resourceSetName !== 'Order_Details' && $resourceSetName !== 'Products' && $resourceSetName !== 'Employees') {
die('(NorthWindQueryProvider) Unknown resource set ' . $resourceSetName);
}
if ($resourceSetName === 'Order_Details') {
$resourceSetName = 'Order Details';
}
$namedKeyValues = $keyDescriptor->getValidatedNamedValues();
$condition = null;
foreach ($namedKeyValues as $key => $value) {
$condition .= $key . ' = ' . $value[0] . ' and ';
}
$len = strlen($condition);
$condition = substr($condition, 0, $len - 5);
$query = "SELECT * FROM [{$resourceSetName}] WHERE {$condition}";
$stmt = sqlsrv_query($this->_connectionHandle, $query);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
//If resource not found return null to the library
if (!sqlsrv_has_rows($stmt)) {
return null;
}
$result = null;
while ($record = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
switch ($resourceSetName) {
case 'Customers':
$result = $this->_serializeCustomer($record);
break;
case 'Orders':
$result = $this->_serializeOrder($record);
break;
/**case 'Order Details':
$result = $this->_serializeOrder_Detail($record);
break;
case 'Products':
$result = $this->_serializeProduct($record);
break;**/
/**case 'Order Details':
$result = $this->_serializeOrder_Detail($record);
break;
case 'Products':
$result = $this->_serializeProduct($record);
break;**/
case 'Employees':
$result = $this->_serializeEmployee($record);
break;
}
}
sqlsrv_free_stmt($stmt);
return $result;
}
public function getResourceFromRelatedResourceSet(ResourceSet $sourceResourceSet, $sourceEntityInstance, ResourceSet $targetResourceSet, ResourceProperty $targetProperty, KeyDescriptor $keyDescriptor)
{
$result = array();
$srcClass = get_class($sourceEntityInstance);
$navigationPropName = $targetProperty->getName();
$key = null;
foreach ($keyDescriptor->getValidatedNamedValues() as $keyName => $valueDescription) {
$key = $key . $keyName . '=' . $valueDescription[0] . ' and ';
}
$key = rtrim($key, ' and ');
if ($srcClass === 'Customer1') {
if ($navigationPropName === 'Orders') {
$query = "SELECT * FROM Orders WHERE CustomerID = '{$sourceEntityInstance->CustomerID}' and {$key}";
$stmt = sqlsrv_query($this->_connectionHandle, $query);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
$result = $this->_serializeOrders($stmt);
} else {
die('Customer does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'Order1') {
if ($navigationPropName === 'Order_Details') {
$query = "SELECT * FROM [Order Details] WHERE OrderID = {$sourceEntityInstance->OrderID}";
$stmt = sqlsrv_query($this->_connectionHandle, $query);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
$result = $this->_serializeOrder_Details($stmt);
} else {
die('Order does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'Product1') {
if ($navigationPropName === 'Order_Details') {
$query = "SELECT * FROM [Order Details] WHERE ProductID = {$sourceEntityInstance->ProductID} and {$key}";
$stmt = sqlsrv_query($this->_connectionHandle, $query);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
$result = $this->_serializeOrder_Details($stmt);
} else {
die('Order does not have navigation porperty with name: ' . $navigationPropName);
}
} else {
if ($srcClass === 'Employee1') {
if ($navigationPropName === 'Subordinates') {
$query = "SELECT * FROM Employees WHERE ReportsTo = {$sourceEntityInstance->EmployeeID} and {$key}";
$stmt = sqlsrv_query($this->_connectionHandle, $query);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
$result = $this->_serializeEmployees($stmt);
} else {
die('Order does not have navigation porperty with name: ' . $navigationPropName);
}
}
}
}
}
return empty($result) ? null : $result[0];
}
