{"id":15162,"date":"2014-03-12T01:43:04","date_gmt":"2014-03-12T05:43:04","guid":{"rendered":"http:\/\/napmamembers.com\/go\/?page_id=15162"},"modified":"2015-04-21T14:18:32","modified_gmt":"2015-04-21T18:18:32","slug":"crm-liststudents","status":"publish","type":"page","link":"http:\/\/napmamembers.com\/go\/crm-liststudents\/","title":{"rendered":"CRM-ListStudents"},"content":{"rendered":"[insert_php]\nrequire_once(“.\/api\/src\/isdk.php”);<\/p>\n

$app = new iSDK;
\necho “created object!
“;<\/p>\n

if ($app->cfgCon(“connectionName”)) {<\/p>\n

echo “App Connected!
Please Stand By While I Pull Up that Information for You!<\/br>“;<\/p>\n

\t# $email = ‘tobymilroy@napma.com’;
\n\t$_DFYSchoolOwnerID = i4w_get_contact_field(‘id’);
\n $totalRecords = $app->dsCount(“Contact”, array(‘_DFYSchoolOwnerID’ => $_DFYSchoolOwnerID));<\/p>\n

echo “<\/p>\n

You currently have ” . $totalRecords . ” students loaded into the system.<\/h3>\n

“;<\/p>\n

if ($totalRecords > 0) {
\n $totalPages = ceil($totalRecords \/ 1000);
\n $contacts = array();
\n $page = 0;
\n do {
\n $contact = $app->dsQuery(“Contact”, 1000, $page++, array(‘_DFYSchoolOwnerID’ => $_DFYSchoolOwnerID), array(‘Id’, ‘Groups’, ‘_DFYSchoolOwnerID’, ‘_DFYSchoolOwnerName’, ‘FirstName’, ‘LastName’, ‘Email’, ‘Phone1’));<\/p>\n

foreach ($contact as $c) {
\n $contacts[] = $c;
\n }
\n } while ($page < $totalPages);\n\n #echo \"\n\n

“;\r\n        #print_r($contacts);\r\n        #echo “<\/pre>\n
“;<\/p>\n
        function aasort (&$array, $key) {
\n            $sorter=array();
\n            $ret=array();
\n            reset($array);
\n            foreach ($array as $ii => $va) {
\n                $sorter[$ii]=$va[$key];
\n            }
\n            asort($sorter);
\n            foreach ($sorter as $ii => $va) {
\n                $ret[$ii]=$array[$ii];
\n            }
\n            return $array=$ret;
\n        }<\/p>\n
        $contacts = aasort($contacts,”LastName”);<\/p>\n
        #echo “<\/p>\n
\";\r\n        #$rev_array = rsort($sort_arra);\r\n        #print_r($contacts);\r\n        #echo \"<\/pre>\n
“;<\/p>\n
        echo “<\/p>\n“;
\n        echo ‘<\/p>\n\n\n
#<\/td>\nID#<\/th>\nFirst Name<\/td>\nLast Name<\/td>\nEmail<\/td>\nPhone<\/th>\nKickin<\/th>\nNBBC<\/th>\nLeadership<\/th>\nGOLD<\/th>\n<\/tr>\n
‘;
\n\t\t$i=0;
\n        foreach($contacts as $cont)
\n\t\t{
\n        echo ‘<\/p>\n
‘. ($i +1) .’<\/td>\n
‘;
\n        echo ‘<\/p>\n
‘.$cont[Id].’<\/td>\n
‘;
\n        #echo ‘<\/p>\n
‘.$cont[Groups].’<\/td>\n
‘;
\n    \t#echo ‘<\/p>\n
‘.$cont[_DFYSchoolOwnerID].’<\/td>\n
‘;
\n        #echo ‘<\/p>\n
‘.$cont[_DFYSchoolOwnerName].’<\/td>\n
‘;
\n        echo ‘<\/p>\n
‘.$cont[FirstName].’<\/td>\n
‘;
\n        echo ‘<\/p>\n
‘.$cont[LastName].’<\/td>\n
‘;
\n        echo ‘<\/p>\n
‘.$cont[Email].’<\/td>\n
‘;
\n    \techo ‘<\/p>\n
‘.$cont[Phone1].’<\/td>\n
‘;
\n        #Kickin\tNBBC\tLeadership gold
\n        $kickin = explode(“,”,$cont[Groups]);
\n        echo ‘<\/p>\n
‘.(in_array(“2704″, $kickin)?’X’:”).’<\/td>\n
‘;
\n        echo ‘<\/p>\n
‘.(in_array(“2706″, $kickin)?’X’:”).’<\/td>\n
‘;
\n        echo ‘<\/p>\n
‘.(in_array(“2708″, $kickin)?’X’:”).’<\/td>\n
‘;
\n        echo ‘<\/p>\n
‘.(in_array(“2710″, $kickin)?’X’:”).’<\/td>\n<\/tr>\n
‘;
\n        $i++;
\n\t\t}
\n\t\techo “<\/table>\n
“;<\/p>\n
    } else {
\n        echo “There were no contacts found with the specified Owner ID ” . $_DFYSchoolOwnerID;
\n    }<\/p>\n
} else {
\n    echo “connection failed!
“;
\n}<\/p>\n[\/insert_php]\n","protected":false},"excerpt":{"rendered":"
CRM – List Students<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"page-crm.php","meta":{"footnotes":""},"class_list":["post-15162","page","type-page","status-publish","hentry"],"publishpress_future_action":{"enabled":false,"date":"2026-05-07 19:42:54","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"http:\/\/napmamembers.com\/go\/wp-json\/wp\/v2\/pages\/15162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/napmamembers.com\/go\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/napmamembers.com\/go\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/napmamembers.com\/go\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/napmamembers.com\/go\/wp-json\/wp\/v2\/comments?post=15162"}],"version-history":[{"count":0,"href":"http:\/\/napmamembers.com\/go\/wp-json\/wp\/v2\/pages\/15162\/revisions"}],"wp:attachment":[{"href":"http:\/\/napmamembers.com\/go\/wp-json\/wp\/v2\/media?parent=15162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}