// Column Types
					    $pdocrud->fieldTypes("status_v", "select");//change state to select dropdown
					    $pdocrud->fieldDataBinding("status_v", array("Open Order"=>"Open Order","Shipped"=>"Shipped"), "", "","array");
					    $pdocrud->fieldTypes("notes_v", "textarea");//change about_yourself 'textarea' to input type text
						
					    // FILTER-1
					    $pdocrud->where("column-name", "Pending", "="); // EQUAL TO

					    //FILTER-2
					    $pdocrud->where("column-name", "Pending", "!="); // NOT EQUAL TO
					
					    //FILTER-3
					    $pdocrud->where("assigned_agent", "Ashley", "=", "OR" ,"("); 
					    $pdocrud->where("assigned_agent", "YEISHA", "=", "" ,")");
						
						//FILTER-4
						// Equal to Sent AND List of Status_cn it could be. Pay attention to the And/ OR statements and perenthesis
						$pdocrud->where("status_verification", "Sent", "=");
						$pdocrud->where("status_cn", null, "is","", "(" );
						$pdocrud->where("status_cn", "Pending", "=","OR");
						$pdocrud->where("status_cn", "Left VM", "=","OR");
						$pdocrud->where("status_cn", "CB", "=", "OR");
						$pdocrud->where("status_cn", "NA", "=", "OR");
						$pdocrud->where("status_cn", "Pending Receipt", "=", "OR");
						$pdocrud->where("status_cn", "Refax", "=", "OR");
						$pdocrud->where("status_cn", "Med Release", "=","OR", ")" );
						
						// FILTER 5
						$pdocrud->where("status_verification", "Failed%", "LIKE");

					  
					  

				      
					    // Internal - admin-b-cn
						$pdocrud->where("status_verification", "Sent", "=");
						$pdocrud->where("status_cn", null, "is","", "(" );
						$pdocrud->where("status_cn", "Pending", "=","OR");
						$pdocrud->where("status_cn", "Left VM", "=","OR");
						$pdocrud->where("status_cn", "CB", "=", "OR");
						$pdocrud->where("status_cn", "NA", "=", "OR");
						$pdocrud->where("status_cn", "Pending Receipt", "=", "OR");
						$pdocrud->where("status_cn", "Refax", "=", "OR");
						$pdocrud->where("status_cn", "Med Release", "=","OR", ")" );
						
						// Internal - admin-b-dl
						$pdocrud->where("status_b", null, "is");
						$pdocrud->where("owner", null, "is not");
						
						// Internal -admin-b-dupe
						$pdocrud->where("status_verification", "Dupe", "=");
						$pdocrud->where("status_b", null, "is");
						
						// Internal = admin-b-failed
						$pdocrud->where("status_verification", "Failed%", "LIKE");
						$pdocrud->where("status_b", null, "is");
						
						// Internal - admin-b-oro2
						$pdocrud->where("status_verification", "ORO-2", "=");
						$pdocrud->where("status_b", null, "is");
						
						// Internal - Admin-b-sent
						$pdocrud->where("owner", null, "is not");
						$pdocrud->where("status_b", null, "is");

						// Internal - admin-cn-issues
						$pdocrud->where("call_type", "CN", "=");
						$pdocrud->where("status_dc", "Issue%", "LIKE");
						
						// Internal = admin-dc-approvals
						$pdocrud->where("file_rx", null, "is not");
						$pdocrud->where("campaign_id", "101", "=", "", "(" );
						$pdocrud->where("campaign_id", "202", "=", "OR", ")" );
						
						// Internal - admin-dc-issues
						$pdocrud->where("status_dc", "issue%", "LIKE");
						
						// Internal - admin-owner-issues
						$pdocrud->where("status_o", "issue%", "LIKE");
						
						// Internal - admin-verification-issues
						$pdocrud->where("status_verification", "issue%", "LIKE");
						
						// Internal - approved
						$pdocrud->where("status_verification", "Ready", "=");

						// Internal - calls
						$pdocrud->where("call_type", "CN", "=");
						$pdocrud->where("assigned_agent", "", "!=");
						$pdocrud->where("status_dc", "Refax", "!=");
						$pdocrud->where("status_dc", "Denied", "!=");
						$pdocrud->where("status_dc", "PCP-Not Theirs", "!=");
						$pdocrud->where("status_dc", "Med Release", "!=");
						$pdocrud->where("status_dc", "PCP-Incorrect", "!=");
						$pdocrud->where("status_dc", "Completed", "!=");
						$pdocrud->where("status_dc", "PCP-Incorrect number", "!=");
						$pdocrud->where("status_dc", "DNC", "!=");
						$pdocrud->where("status_dc", "RX-None", "!=");
						$pdocrud->where("status_dc", "RX-Incorrect", "!=");
						$pdocrud->where("status_dc", "Pending", "!=");

						// Internal - dc-check
						$pdocrud->where("status_verification", "PCP-Ready", "=");
						$pdocrud->where("create_date", "2022-01-03 08:46:45", "<=");
						$pdocrud->where("file_rx", null, "is");
						$pdocrud->where("date_v", null, "is");
						
						// Internal - Fax-Pending
						$pdocrud->where("inbound_status", "Fax Received", "=","OR");
						$pdocrud->where("inbound_status", "More Info", "=");
						
						// Internal - Passed
						$pdocrud->where("status_verification", "Passed", "=");
						
						// Internal = pending-faxes
						$pdocrud->where("status_dc", "Fax-Pending", "=","OR");
						$pdocrud->where("status_dc", "Fax-Pending-CN", "=","OR");
						$pdocrud->where("status_dc", "Fax-Pending-CG", "=");


		


		  		  	

		  


						
						// Records - Verification
					    $pdocrud->where("status_verification", "Pending", "=");

						// Records - PCP-Ready
						$pdocrud->where("status_dc", "Pending", "=");

						// Records - Pending Faxes
						$pdocrud->where("status_dc", "Fax-Pending", "=");

						
					  
					  

				      
					    // ACTION BUTTONS
					    // Adds chosen column at the end of the url
					    $action = "https://www.google.com/{Phone}";
					    $text = 'Thinking';
					    $attr = array("title"=>"Redirect");
					    $pdocrud->enqueueBtnActions("url", $action, "url",$text,"client_id", $attr);

					    // ACTION Button Samples
					    // NPI CHECK
					    $action = "https://npiregistry.cms.hhs.gov/registry/search-results-table?number={pcp_npi}";//pk will be replaced by primary key value
					    $text = 'NPI';
					    $attr = array("title"=>"Redirect");
					    $pdocrud->enqueueBtnActions("url", $action, "url",$text,"client_id", $attr);
						
						// Action Button
						// Check ICD Code
						$action = "https://www.icd10data.com/search?s={icd_code}";//pk will be replaced by primary key value
						$text = 'Lookup';
						$attr = array("title"=>"Redirect");
						$pdocrud->enqueueBtnActions("url", $action, "url",$text,"icd_code", $attr);

					  
					  

				      
						// Place at the top of every page
						$pdocrud = new PDOCrud();
						if ($pdocrud->checkUserSession("userId"))
						{
						if ($pdocrud->checkUserSession("role", array("100","101","102","121"))) 
						{
						}
	   				      else
	     				    {
						  header("Location: https://tools.myflex.io/kto/records/no-permission.php");
	     				    }
						}
	  				      else
	  				    {
						  header("Location: https://tools.myflex.io/kto/records/not-authorized.php");
						exit();
					    }