WebSVN – SmartDukaan – Diff – /trunk/DtrMobileAppDashboard/app/Controller/UsersController.php

 	    );
 		$this->Paginator->settings = $options;
 		$users = $this->Paginator->paginate();
 		foreach ($users as $key => $value) {
 			$userId = $value['User']['id'];
-			$quer= "select r.retailer_id,a.name, ud. from retailerlinks r join agents a on r.agent_id=a.id left join user_docs ud on u.id=ud.user_id where user_id=$userId";
+			$quer= "select r.retailer_id,a.name from retailerlinks r join agents a on r.agent_id=a.id where user_id=$userId";
 			$res = $this->User->query($quer);
 			/*$last_act= "select last_active from useractive where user_id=$userId";
 			$res_last = $this->User->query($last_act);*/
 			if(empty($res)){
 				$users[$key]['User']['retailer_id']="";
 			return false;
+		}
+	}
+	function sendFile($id) {
+		$id = '/RetailerDocs/'.$id;
+		$file = $this->Attachment->getFile($id);
+	    $this->response->file($file['path']);
+	    // Return response object to prevent controller from trying to render
+	    // a view
+	    return $this->response;
+	}
 	function privacyPolicy(){
+	}
+}

Subversion Repositories SmartDukaan