PHP Organization::insert方法代码示例

 /**
  * set up for dependent objects before running each test
  */
 public final function setUp()
 {
     //run default set-up method
     parent::setUp();
     //create a new organization for the test volunteers to belong
     $organization = new Organization(null, "123 Easy Street", '', "Albuquerque", "Feeding people since 1987", "9 - 5", "Food for Hungry People", "505-765-4321", "NM", "R", "87801");
     $organization->insert($this->getPDO());
     //create a new volunteer to use as an admin for the tests
     //don't need to insert them into the database: just need their info to create sessions
     //for testing purposes, allow them to create organizations they're not associated with
     $salt = bin2hex(openssl_random_pseudo_bytes(32));
     $hash = hash_pbkdf2("sha512", "password4321", $salt, 262144, 128);
     $this->admin = new Volunteer(null, $organization->getOrgId(), "fakeemail@fake.com", null, "John", $hash, true, "Doe", "505-123-4567", $salt);
     $this->admin->insert($this->getPDO());
     //create a non-admin volunteer for the tests
     $salt = bin2hex(openssl_random_pseudo_bytes(32));
     $hash = hash_pbkdf2("sha512", "password1234", $salt, 262144, 128);
     $this->volunteer = new Volunteer(null, $organization->getOrgId(), "notanemail@fake.com", null, "Jane", $hash, false, "Doe", "505-555-5555", $salt);
     $this->volunteer->insert($this->getPDO());
     //create the guzzle client
     $this->guzzle = new \GuzzleHttp\Client(["cookies" => true]);
     //visit ourselves to get the xsrf-token
     $this->guzzle->get('https://bootcamp-coders.cnm.edu/~tfenstermaker/bread-basket/public_html/php/api/organization');
     $cookies = $this->guzzle->getConfig()["cookies"];
     $this->token = $cookies->getCookieByName("XSRF-TOKEN")->getValue();
     //send a request to the sign-in method
     $adminLogin = new stdClass();
     $adminLogin->email = "fakeemail@fake.com";
     $adminLogin->password = "password4321";
     $login = $this->guzzle->post('https://bootcamp-coders.cnm.edu/~tfenstermaker/bread-basket/public_html/php/controllers/sign-in-controller.php', ['json' => $adminLogin, 'headers' => ['X-XSRF-TOKEN' => $this->token]]);
 }

 /**
  * Save a new organization with the minimal information
  * @return an array with result and message json encoded
  */
 public function run()
 {
     $controller = $this->getController();
     // Retrieve data from form
     $newOrganization = Organization::newOrganizationFromPost($_POST);
     try {
         //Save the organization
         Rest::json(Organization::insert($newOrganization, Yii::app()->session["userId"]));
     } catch (CTKException $e) {
         return Rest::json(array("result" => false, "msg" => $e->getMessage()));
     }
 }

     throw new InvalidArgumentException("password cannot be empty", 405);
 }
 // sanitize the email & search by volEmail
 $volEmail = filter_var($requestObject->volEmail, FILTER_SANITIZE_EMAIL);
 $volunteer = Volunteer::getVolunteerByVolEmail($pdo, $volEmail);
 if ($volunteer !== null) {
     throw new RuntimeException("This email already has an account", 422);
 }
 // create a new salt and email activation
 $volSalt = bin2hex(openssl_random_pseudo_bytes(32));
 $volEmailActivation = bin2hex(openssl_random_pseudo_bytes(8));
 // create the hash
 $volHash = hash_pbkdf2("sha512", $requestObject->password, $volSalt, 262144, 128);
 //create a new organization and insert into mySQL
 $organization = new Organization(null, $requestObject->orgAddress1, $requestObject->orgAddress2, $requestObject->orgCity, $requestObject->orgDescription, $requestObject->orgHours, $requestObject->orgName, $requestObject->orgPhone, $requestObject->orgState, $requestObject->orgType, $requestObject->orgZip);
 $organization->insert($pdo);
 $reply->message = "New organization has been created";
 //create a new Volunteer and insert into mySQL
 $volunteer = new Volunteer(null, $organization->getOrgId(), $requestObject->volEmail, $volEmailActivation, $requestObject->volFirstName, $volHash, true, $requestObject->volLastName, $requestObject->volPhone, $volSalt);
 $volunteer->insert($pdo);
 $reply->message = "A new administrator has been created";
 if ($volunteer->getVolIsAdmin() === true) {
     $_SESSION["volunteer"] = $volunteer;
     $reply->status = 200;
     $reply->message = "Logged in as administrator";
 }
 // create Swift message
 $swiftMessage = Swift_Message::newInstance();
 // attach the sender to the message
 // this takes the form of an associative array where the Email is the key for the real name
 $swiftMessage->setFrom(["breadbasketapp@gmail.com" => "Bread Basket"]);

 $udata['vAddressLine2'] = $_POST['vAddressLine2'];
 $udata['vAddressLine3'] = $_POST['vAddressLine3'];
 $udata['vCity'] = $_POST['vCity'];
 $udata['vCountry'] = $_POST['vCountry'];
 $udata['vState'] = $_POST['vState'];
 $udata['vZipcode'] = $_POST['vZipcode'];
 $udata['vPhone'] = $odata['vPhone'];
 $udata['eUserType'] = 'Admin';
 $udata['eSelfReg'] = 'Yes';
 // $udata['vActivationCode'] = $activationcode;
 $udata['dCreatedDate'] = $udata['dModifiedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
 $udata['eStatus'] = 'Need to Verify';
 // pr($_POST);
 $odata['vOrganizationCode'] = $orgObj->getUniqueCode($odata['eOrganizationType']);
 // pr($odata);
 $oid = $res = $orgObj->insert($odata);
 if ($oid > 0) {
     $odata['iOrganizationID'] = $oid;
     $res = $orgvrfObj->insert($odata);
     //
     $udata['iOrganizationID'] = $oid;
     $uid = $orgUsrObj->insert($udata);
     if ($uid > 0) {
         $udata['iUserID'] = $uid;
         $iVerifiedID = $userToVerifyObj->insert($udata);
     }
     // echo $uid; exit;
     // org default preferences
     //------------------------DEFALT VALUES OF PURCHASE ORDER -----------------------------------------//
     if ($odata['eOrganizationType'] != 'Supplier') {
         $where = ' AND eFor = "PO"  AND eType = "Default" AND eStatus = "Active"';

 /**
  * function to map the ralated to (organization) for potentials while importing
  * checks if the organization exists else will add a new one
  * @param string $organization_name
  * @return integer idorganization
  */
 public function map_related_to_organization($organization_name)
 {
     if (strlen($organization_name) > 2) {
         $organization_name = trim($organization_name);
         $do_organization = new Organization();
         $qry = "\n\t\t\tselect `idorganization` \n\t\t\tfrom `organization` \n\t\t\twhere \n\t\t\t`organization_name` = ?\n\t\t\tAND `deleted` = 0 \n\t\t\tAND `iduser` = " . $_SESSION["do_user"]->iduser;
         $do_organization->query($qry, array($organization_name));
         if ($do_organization->getNumRows() > 0) {
             $do_organization->next();
             return $do_organization->idorganization;
         } else {
             $do_organization->insert("organization", array("organization_name" => CommonUtils::purify_input($organization_name), "iduser" => $_SESSION["do_user"]->iduser));
             $idorganization = $do_organization->getInsertId();
             //adding the added_on
             $q_upd = "\n\t\t\t\tupdate `organization`\n\t\t\t\tset `added_on` = '" . date("Y-m-d H:i:s") . "'\n\t\t\t\twhere `idorganization` = " . $idorganization;
             $do_organization->query($q_upd);
             $do_organization->insert("organization_custom_fld", array("idorganization" => $idorganization));
             $do_organization->insert("organization_address", array("idorganization" => $idorganization));
             $do_data_history = new DataHistory();
             $do_data_history->add_history($idorganization, 6, 'add');
             $do_data_history->free();
             return $idorganization;
         }
     }
 }

 /**
  * When an initation to join an organization network is sent :
  * this method will :
  * 1. Create a new person and organization.
  * 2. Make the new person a member and admin of the organization
  * 3. Join the network of the organization inviting
  * @param type $person the minimal data to create a person
  * @param type $organization the minimal data to create an organization
  * @param type $parentOrganizationId the organization Id to join the network of
  * @return newPersonId ans newOrganizationId
  */
 public static function createPersonOrganizationAndAddMember($person, $organization, $parentOrganizationId)
 {
     //The data check is normaly done before inserting but the both data (organization and person)
     //must be ok before inserting
     //Check person datas
     Person::getAndcheckPersonData($person, false);
     //Check organization datas
     Organization::getAndCheckOrganization($organization);
     //Create a new person
     $newPerson = Person::insert($person);
     //Create a new organization
     $newOrganization = Organization::insert($organization, $newPerson["id"]);
     //Link the person as an admin
     Link::addMember($newOrganization["id"], Organization::COLLECTION, $newPerson["id"], PHType::TYPE_CITOYEN, $newPerson["id"], true);
     //Link the organization as a member of the invitor
     //TODO SBAR - On GRANDDIR case, the parent organization can manage (data, event, project...) their organization members.
     //Should be a parameter of the application.
     $isParentOrganizationAdmin = true;
     Link::addMember($parentOrganizationId, Organization::COLLECTION, $newOrganization["id"], Organization::COLLECTION, $newPerson["id"], $isParentOrganizationAdmin);
     return array("result" => true, "msg" => Yii::t("organisation", "The invitation process completed with success"), "id" => $newOrganization["id"]);
 }

 /**
  * test grabbing an organization by zip code
  */
 public function testGetValidOrganizationByZip()
 {
     //count the number of rows currently in the database
     $numRows = $this->getConnection()->getRowCount("organization");
     //create a new organization and insert into mySQL
     $organization = new Organization(null, $this->VALID_ADDRESS1, $this->VALID_ADDRESS2, $this->VALID_CITY, $this->VALID_DESCRIPTION, $this->VALID_HOURS, $this->VALID_NAME, $this->VALID_PHONE, $this->VALID_STATE, $this->VALID_TYPE, $this->VALID_ZIP);
     $organization->insert($this->getPDO());
     //grab data from mySQL and enforce that the fields match
     $pdoOrganization = Organization::getOrganizationByOrgZip($this->getPDO(), $this->VALID_ZIP);
     $this->assertSame($numRows + 1, $this->getConnection()->getRowCount("organization"));
     $this->assertSame($pdoOrganization[0]->getOrgAddress1(), $this->VALID_ADDRESS1);
     $this->assertSame($pdoOrganization[0]->getOrgAddress2(), $this->VALID_ADDRESS2);
     $this->assertSame($pdoOrganization[0]->getOrgCity(), $this->VALID_CITY);
     $this->assertSame($pdoOrganization[0]->getOrgDescription(), $this->VALID_DESCRIPTION);
     $this->assertSame($pdoOrganization[0]->getOrgHours(), $this->VALID_HOURS);
     $this->assertSame($pdoOrganization[0]->getOrgName(), $this->VALID_NAME);
     $this->assertSame($pdoOrganization[0]->getOrgPhone(), $this->VALID_PHONE);
     $this->assertSame($pdoOrganization[0]->getOrgState(), $this->VALID_STATE);
     $this->assertSame($pdoOrganization[0]->getOrgType(), $this->VALID_TYPE);
     $this->assertSame($pdoOrganization[0]->getOrgZip(), $this->VALID_ZIP);
 }

 public static function importMongoDB2($post)
 {
     /***** new version *****/
     $newFolder = false;
     $path = '../../modules/cityData/importData/';
     if (!file_exists($path)) {
         mkdir($path, 0775);
     }
     $pathFile = '../../modules/cityData/importData/' . $post['nameFile'] . '/';
     if (!file_exists($pathFile)) {
         mkdir($pathFile, 0775);
         $count = 1;
         $newFolder = true;
     } else {
         $files = scandir($pathFile);
         $count = 1;
         foreach ($files as $key => $value) {
             $name_file = explode(".", $value);
             if (strpos($name_file[0], "cityData") !== false) {
                 $count++;
             }
         }
     }
     //importmongo all
     if (file_exists("../../modules/cityData/importData/importAllMongo.sh") == true) {
         $textImportMongoAll = file_get_contents("../../modules/cityData/importData/importAllMongo.sh", FILE_USE_INCLUDE_PATH);
     } else {
         $textImportMongoAll = "";
     }
     if ($newFolder) {
         $textImportMongoAll = $textImportMongoAll . "cd " . $post['nameFile'] . ";\n";
         $textImportMongoAll = $textImportMongoAll . "sh importMongo.sh;\n";
         $textImportMongoAll = $textImportMongoAll . "cd .. ;\n";
     }
     //importmongo
     if (file_exists("../../modules/cityData/importData/" . $post['nameFile'] . "/importMongo.sh") == true) {
         $textFileSh = file_get_contents("../../modules/cityData/importData/" . $post['nameFile'] . "/importMongo.sh", FILE_USE_INCLUDE_PATH);
     } else {
         $textFileSh = "";
     }
     $textFileSh = $textFileSh . "mongoimport --db pixelhumain --collection organizations " . $post['nameFile'] . "_" . $count . ".json --jsonArray;\n";
     file_put_contents("../../modules/cityData/importData/" . $post['nameFile'] . "/" . $post['nameFile'] . "_" . $count . ".json", $post['jsonImport']);
     file_put_contents("../../modules/cityData/importData/" . $post['nameFile'] . "/error_" . $count . ".json", $post['jsonError']);
     file_put_contents("../../modules/cityData/importData/" . $post['nameFile'] . "/importMongo.sh", $textFileSh);
     file_put_contents("../../modules/cityData/importData/importAllMongo.sh", $textImportMongoAll);
     if (isset($post['jsonImport'])) {
         $arrayDataImport = json_decode($post['jsonImport'], true);
         foreach ($arrayDataImport as $key => $value) {
             $newOrganization = Organization::newOrganizationFromImportData($value);
             try {
                 $resData[] = Organization::insert($newOrganization, Yii::app()->session["userId"]);
             } catch (CTKException $e) {
                 $resData[] = $e->getMessage();
             }
         }
         $params = array("result" => true, "resData" => $resData);
     } else {
         $params = array("result" => false);
     }
     return $params;
 }

 // $vOrganizationCode = $generalobj->UniqueID("ORG",PRJ_DB_PREFIX."_organization_master","vOrganizationCode",$charlimit="10");
 $vOrganizationCode = $orgObj->getUniqueCode($Data['eOrganizationType']);
 // echo $vOrganizationCode; exit;
 $code = $Data['vOrganizationCode'] = $vOrganizationCode;
 //	  $vCompanyRegNo = $generalobj->UniqueID("",PRJ_DB_PREFIX."_organization_master","vCompanyRegNo",$charlimit="10");
 $regno = $Data['vCompanyRegNo'];
 // = $vCompanyRegNo;
 $compcode = $Data['vCompCode'];
 // if(count($arr)>0) {
 $Data['eStatus'] = "Need to Verify";
 /*} else {
 	 $Data['eStatus'] = "Active";
   }*/
 // prints($Data);exit;
 $orgObj->setAllVar($Data);
 $iOrganizationID = $res = $orgObj->insert();
 //INSERT THIS RECORD IN ORGANIZATION_MASTER_TOVERIFY TABLE
 $insID = $gdbobj->getMaxId(PRJ_DB_PREFIX . "_organization_master", 'iOrganizationID');
 $Data1 = $Data;
 $iOrganizationID = $Data1['iOrganizationID'] = $insID[0]['id'];
 $orgvrfObj->setAllVar($Data1);
 $res = $orgvrfObj->insert();
 /*	 if($res){
 		  $orgdtls = $orgObj->select($iOrganizationID);
 		  if($orgdtls[0]['eOrganizationType'] == 'Supplier'){
 				$opdt['vOrderStatusLevel'] = '';
 				$rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID");
 		  } else if($orgdtls[0]['eOrganizationType'] == 'Buyer'){
 				$opdt['vInvoiceStatusLevel'] = '';
 				$rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID");
 		  }

 /**
  * function to map organization to contact while importing
  * checks if the organization already exists else add a new one
  * @param string $organization_name
  * @param object $import_object
  * @param array $data
  * @return integer idorganization
  */
 public function map_contact_organization($organization_name, $import_object, $data)
 {
     $qry = "\n\t\tselect idorganization \n\t\tfrom organization \n\t\twhere organization_name = ?\n\t\tAND deleted = 0\n\t\tAND iduser =" . $_SESSION["do_user"]->iduser;
     $stmt = $this->getDbConnection()->executeQuery($qry, array(trim($organization_name)));
     if ($stmt->rowCount() > 0) {
         $rs = $stmt->fetch();
         return $rs["idorganization"];
     } else {
         if (strlen($organization_name) > 2) {
             $mapped_fields = $import_object->get_mapped_fields();
             $do_organization = new Organization();
             $do_organization->insert("organization", array("organization_name" => CommonUtils::purify_input($organization_name), "iduser" => $_SESSION["do_user"]->iduser));
             $idorganization = $do_organization->getInsertId();
             $q_upd = "\n\t\t\t\tupdate `organization`\n\t\t\t\tset `added_on` = ?\n\t\t\t\twhere `idorganization` = ?";
             $do_organization->query($q_upd, array(date("Y-m-d H:i:s"), $idorganization));
             $do_organization->insert("organization_custom_fld", array("idorganization" => $idorganization));
             $mapped_fields = $import_object->get_mapped_fields();
             if (array_search("cnt_mail_street", $mapped_fields) !== false) {
                 $org_bill_address = $data[array_search("cnt_mail_street", $mapped_fields)];
             } else {
                 $org_bill_address = '';
             }
             if (array_search("cnt_mail_pobox", $mapped_fields) !== false) {
                 $org_bill_pobox = $data[array_search("cnt_mail_pobox", $mapped_fields)];
             } else {
                 $org_bill_pobox = '';
             }
             if (array_search("cnt_mailing_city", $mapped_fields) !== false) {
                 $org_bill_city = $data[array_search("cnt_mailing_city", $mapped_fields)];
             } else {
                 $org_bill_city = '';
             }
             if (array_search("cnt_mailing_state", $mapped_fields) !== false) {
                 $org_bill_state = $data[array_search("cnt_mailing_state", $mapped_fields)];
             } else {
                 $org_bill_state = '';
             }
             if (array_search("cnt_mailing_postalcode", $mapped_fields) !== false) {
                 $org_bill_postalcode = $data[array_search("cnt_mailing_postalcode", $mapped_fields)];
             } else {
                 $org_bill_postalcode = '';
             }
             if (array_search("cnt_mailing_country", $mapped_fields) !== false) {
                 $org_bill_country = $data[array_search("cnt_mailing_country", $mapped_fields)];
             } else {
                 $org_bill_country = '';
             }
             $do_organization->insert("organization_address", array("idorganization" => $idorganization, "org_bill_address" => CommonUtils::purify_input($org_bill_address), "org_bill_pobox" => CommonUtils::purify_input($org_bill_pobox), "org_bill_city" => CommonUtils::purify_input($org_bill_city), "org_bill_state" => CommonUtils::purify_input($org_bill_state), "org_bill_postalcode" => CommonUtils::purify_input($org_bill_postalcode), "org_bill_country" => CommonUtils::purify_input($org_bill_country)));
             $do_data_history = new DataHistory();
             $do_data_history->add_history($idorganization, 6, 'add');
             $do_data_history->free();
             return $idorganization;
         } else {
             return 0;
         }
     }
 }

 /**
  * test putting a valid organization into the API
  */
 public function testValidPut()
 {
     //create a new organization, and insert into the database
     $organization = new Organization(null, $this->VALID_ADDRESS1, $this->VALID_ADDRESS2, $this->VALID_CITY, $this->VALID_DESCRIPTION, $this->VALID_HOURS, $this->VALID_NAME, $this->VALID_PHONE, $this->VALID_STATE, $this->VALID_TYPE, $this->VALID_ZIP);
     $organization->insert($this->getPDO());
     //update the organization
     $organization->setOrgName($this->VALID_NAME_ALT);
     //send the info to update to the API
     $response = $this->guzzle->put('https://bootcamp-coders.cnm.edu/~bbrown52/bread-basket/public_html/php/api/organization/' . $organization->getOrgId(), ['allow-redirects' => ['strict' => true], 'json' => $organization, 'headers' => ['X-XSRF-TOKEN' => $this->token]]);
     //ensure the response was sent, and the api returned a positive status
     $this->assertSame($response->getStatusCode(), 200);
     $body = $response->getBody();
     $retrievedOrg = json_decode($body);
     $this->assertSame(200, $retrievedOrg->status);
     //pull the value from the DB, and make sure it was properly updated
     $neworg = Organization::getOrganizationByOrgId($this->getPDO(), $organization->getOrgId());
     $this->assertSame($neworg->getOrgName(), $this->VALID_NAME_ALT);
 }