/**
  * delete olayında önce kaydın active özelliğini pasif e olarak değiştiriyoruz. 
  * daha sonra deleted= 1 ve active = 1 olan kaydı oluşturuyor. 
  * böylece tablo içerisinde loglama mekanizması için gerekli olan kayıt oluşuyor.
  * @version 25.04.2016 
  * @param type $id
  * @param type $params
  * @return array
  * @throws PDOException
  */
 public function deletedAct($params = array())
 {
     try {
         $pdo = $this->slimApp->getServiceManager()->get('pgConnectFactory');
         $pdo->beginTransaction();
         $opUserId = InfoUsers::getUserId(array('pk' => $params['pk']));
         if (\Utill\Dal\Helper::haveRecord($opUserId)) {
             $opUserIdValue = $opUserId['resultSet'][0]['user_id'];
             $getFirm = InfoFirmProfile::getCheckIsThisFirmRegisteredUser(array('cpk' => $params['cpk'], 'op_user_id' => $opUserIdValue));
             if (\Utill\Dal\Helper::haveRecord($getFirm)) {
                 $getFirmId = $getFirm['resultSet'][0]['firm_id'];
                 //$kontrol = $this->haveRecords($params);
                 $kontrol = $this->haveRecords(array('id' => $params['id'], 'firm_id' => $getFirmId));
                 if (!\Utill\Dal\Helper::haveRecord($kontrol)) {
                     $this->makePassive(array('id' => $params['id']));
                     $operationIdValue = -3;
                     $operationId = SysOperationTypes::getTypeIdToGoOperationId(array('parent_id' => 3, 'main_group' => 3, 'sub_grup_id' => 32, 'type_id' => 3));
                     if (\Utill\Dal\Helper::haveRecord($operationId)) {
                         $operationIdValue = $operationId['resultSet'][0]['id'];
                     }
                     $languageId = NULL;
                     $languageIdValue = 647;
                     if (isset($params['language_code']) && $params['language_code'] != "") {
                         $languageId = SysLanguage::getLanguageId(array('language_code' => $params['language_code']));
                         if (\Utill\Dal\Helper::haveRecord($languageId)) {
                             $languageIdValue = $languageId['resultSet'][0]['id'];
                         }
                     }
                     $profilePublic = 0;
                     if (isset($params['profile_public']) && $params['profile_public'] != "") {
                         $profilePublic = intval($params['profile_public']);
                     }
                     $sql = " \n                        INSERT INTO info_firm_verbal(\n                            firm_id, \n                            consultant_id,\n                            operation_type_id, \n                            language_id,\n                            op_user_id,\n                            profile_public,                           \n                            act_parent_id,  \n                            about,\n                            about_eng,\n                            verbal1_title, \n                            verbal1, \n                            verbal2_title, \n                            verbal2, \n                            verbal3_title, \n                            verbal3, \n                            verbal1_title_eng, \n                            verbal1_eng, \n                            verbal2_title_eng, \n                            verbal2_eng, \n                            verbal3_title_eng, \n                            verbal3_eng,\n                            consultant_confirm_type_id, \n                            confirm_id,\n                            language_parent_id,\n                            cons_allow_id,\n                            active,\n                            deleted\n                            )                        \n                        SELECT \n                            firm_id, \n                            consultant_id,                            \n                            " . intval($operationIdValue) . " AS operation_type_id,\n                            language_id,   \n                            " . intval($opUserIdValue) . " AS op_user_id, \n                            profile_public, \n                            act_parent_id,                            \n                            about,\n                            about_eng,\n                            verbal1_title,\n                            verbal1,\n                            verbal2_title,\n                            verbal2,\n                            verbal3_title,\n                            verbal3,\n                            verbal1_title_eng,\n                            verbal1_eng,\n                            verbal2_title_eng,\n                            verbal2_eng,\n                            verbal3_title_eng,\n                            verbal3_eng,                             \n                            consultant_confirm_type_id, \n                            confirm_id,\n                            language_parent_id,\n                            cons_allow_id,\n                            1,\n                            1\n                        FROM info_firm_verbal \n                        WHERE id =  " . intval($params['id']) . " \n                        ";
                     $statement_act_insert = $pdo->prepare($sql);
                     $insert_act_insert = $statement_act_insert->execute();
                     // echo debugPDO($sql, $params);
                     $affectedRows = $statement_act_insert->rowCount();
                     $insertID = $pdo->lastInsertId('info_firm_verbal_id_seq');
                     /*
                      * ufak bir trik var. 
                      * işlem update oldugunda update işlemini yapan kişinin dil bilgisini kullanıcaz. 
                      * ancak delete işlemi oldugunda delete işlemini yapan user in dil bilgisini değil 
                      * silinen kaydı yapan kişinin dil bilgisini alıcaz.
                      */
                     $consIdAndLanguageId = SysOperationTypes::getConsIdAndLanguageId(array('table_name' => 'info_firm_verbal', 'id' => $params['id']));
                     if (\Utill\Dal\Helper::haveRecord($consIdAndLanguageId)) {
                         $ConsultantId = $consIdAndLanguageId['resultSet'][0]['consultant_id'];
                         $languageIdValue = $consIdAndLanguageId['resultSet'][0]['language_id'];
                     }
                     $xjobs = ActProcessConfirm::insert(array('op_user_id' => intval($opUserIdValue), 'operation_type_id' => intval($operationIdValue), 'table_column_id' => intval($insertID), 'cons_id' => intval($ConsultantId), 'preferred_language_id' => intval($languageIdValue)));
                     if ($xjobs['errorInfo'][0] != "00000" && $xjobs['errorInfo'][1] != NULL && $xjobs['errorInfo'][2] != NULL) {
                         throw new \PDOException($xjobs['errorInfo']);
                     }
                     $pdo->commit();
                     return array("found" => true, "errorInfo" => $errorInfo, "affectedRowsCount" => $affectedRows);
                 } else {
                     // 23505  unique_violation
                     $errorInfo = '23505';
                     $pdo->rollback();
                     $result = $kontrol;
                     return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '');
                 }
             } else {
                 $errorInfo = '23502';
                 // 23502  not_null_violation
                 $errorInfoColumn = 'cpk';
                 $pdo->rollback();
                 return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
             }
         } else {
             $errorInfo = '23502';
             // 23502  not_null_violation
             $errorInfoColumn = 'pk';
             $pdo->rollback();
             return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
         }
     } catch (\PDOException $e) {
         $pdo->rollback();
         return array("found" => false, "errorInfo" => $e->getMessage());
     }
 }
 /**
  * delete olayında önce kaydın active özelliğini pasif e olarak değiştiriyoruz. 
  * daha sonra deleted= 1 ve active = 1 olan kaydı oluşturuyor. 
  * böylece tablo içerisinde loglama mekanizması için gerekli olan kayıt oluşuyor.
  * @version 21.04.2016 
  * @param type $id
  * @param type $params
  * @return array
  * @throws PDOException
  */
 public function deletedAct($params = array())
 {
     try {
         $pdo = $this->slimApp->getServiceManager()->get('pgConnectFactory');
         $pdo->beginTransaction();
         $opUserId = InfoUsers::getUserId(array('pk' => $params['pk']));
         if (\Utill\Dal\Helper::haveRecord($opUserId)) {
             $opUserIdValue = $opUserId['resultSet'][0]['user_id'];
             $this->makePassive(array('id' => $params['id']));
             $operationIdValue = -3;
             $operationId = SysOperationTypes::getTypeIdToGoOperationId(array('parent_id' => 3, 'main_group' => 3, 'sub_grup_id' => 42, 'type_id' => 3));
             if (\Utill\Dal\Helper::haveRecord($operationId)) {
                 $operationIdValue = $operationId['resultSet'][0]['id'];
             }
             $sql = "  \n                    INSERT INTO info_users_socialmedia(\n                        user_id, \n                        profile_public, \n                        op_user_id, \n                        operation_type_id, \n                        consultant_id, \n                        sys_socialmedia_id, \n                        act_parent_id, \n                        user_link,\n                        active,\n                        deleted\n                        )\n                        SELECT  \n                            user_id,\n                            profile_public,                           \n                            " . intval($opUserIdValue) . " AS op_user_id,  \n                            " . intval($operationIdValue) . " AS operation_type_id,  \n                            consultant_id, \n                            sys_socialmedia_id,\n                            act_parent_id,                                                   \n                            user_link,\n                            1,\n                            1    \n                        FROM info_users_socialmedia \n                        WHERE id =  " . intval($params['id']) . " \n                        ";
             $statement_act_insert = $pdo->prepare($sql);
             // echo debugPDO($sql, $params);
             $insert_act_insert = $statement_act_insert->execute();
             $affectedRows = $statement_act_insert->rowCount();
             $insertID = $pdo->lastInsertId('info_users_socialmedia_id_seq');
             /*
              * ufak bir trik var. 
              * işlem update oldugunda update işlemini yapan kişinin dil bilgisini kullanıcaz. 
              * ancak delete işlemi oldugunda delete işlemini yapan user in dil bilgisini değil 
              * silinen kaydı yapan kişinin dil bilgisini alıcaz.
              */
             $consIdAndLanguageId = SysOperationTypes::getConsIdAndLanguageId(array('table_name' => 'info_users_socialmedia', 'id' => $params['id']));
             if (\Utill\Dal\Helper::haveRecord($consIdAndLanguageId)) {
                 $ConsultantId = $consIdAndLanguageId['resultSet'][0]['consultant_id'];
                 $languageIdValue = $consIdAndLanguageId['resultSet'][0]['language_id'];
             }
             $xjobs = ActProcessConfirm::insert(array('op_user_id' => intval($opUserIdValue), 'operation_type_id' => intval($operationIdValue), 'table_column_id' => intval($insertID), 'cons_id' => intval($ConsultantId), 'preferred_language_id' => intval($languageIdValue)));
             if ($xjobs['errorInfo'][0] != "00000" && $xjobs['errorInfo'][1] != NULL && $xjobs['errorInfo'][2] != NULL) {
                 throw new \PDOException($xjobs['errorInfo']);
             }
             $pdo->commit();
             return array("found" => true, "errorInfo" => $errorInfo, "affectedRowsCount" => $affectedRows);
         } else {
             $errorInfo = '23502';
             // 23502  not_null_violation
             $errorInfoColumn = 'pk';
             $pdo->rollback();
             return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
         }
     } catch (\PDOException $e) {
         $pdo->rollback();
         return array("found" => false, "errorInfo" => $e->getMessage());
     }
 }
Esempio n. 3
0
 /**
  * parametre olarak gelen 'id' li kaydın password unu update yapar  !!
  * @author Okan CIRAN
  * @version v 1.0  02.09.2016     
  * @param array | null $args
  * @param type $params
  * @return array
  * @throws PDOException
  */
 public function setPersonPassword($params = array())
 {
     try {
         $pdo = $this->slimApp->getServiceManager()->get('pgConnectFactory');
         $pdo->beginTransaction();
         $userId = $this->getUserId(array('pk' => $params['key']));
         if (\Utill\Dal\Helper::haveRecord($userId)) {
             $opUserIdValue = $userId['resultSet'][0]['user_id'];
             /*
              * kullanıcı için gerekli olan private key ve value değerleri yaratılılacak.                       
              */
             $xcDeletedOnTheLink = InfoUsersSendingMail::setDeletedOnTheLinks(array('key' => $params['key']));
             if ($xcDeletedOnTheLink['errorInfo'][0] != "00000" && $xcDeletedOnTheLink['errorInfo'][1] != NULL && $xcDeletedOnTheLink['errorInfo'][2] != NULL) {
                 throw new \PDOException($xcDeletedOnTheLink['errorInfo']);
             }
             $affectedRows = $xcDeletedOnTheLink['affectedRowsCount'];
             if ($affectedRows == 1) {
                 $active = 0;
                 $operationIdValue = -2;
                 $operationId = SysOperationTypes::getTypeIdToGoOperationId(array('parent_id' => 3, 'main_group' => 3, 'sub_grup_id' => 43, 'type_id' => 2));
                 if (\Utill\Dal\Helper::haveRecord($operationId)) {
                     $operationIdValue = $operationId['resultSet'][0]['id'];
                 }
                 /*
                  * parametre olarak gelen array deki 'id' li kaydın, info_users tablosundaki 
                  * alanlarını update eder !! username update edilmez.  
                  */
                 $this->updateInfoUsers(array('id' => $opUserIdValue, 'op_user_id' => $opUserIdValue, 'active' => $active, 'operation_type_id' => $operationIdValue, 'language_id' => 647, 'password' => $params['password']));
                 /*
                  *  parametre olarak gelen array deki 'id' li kaydın, info_users_details tablosundaki 
                  * active = 0 ve deleted = 0 olan kaydın active alanını 1 yapar  !!
                  */
                 $this->setUserDetailsDisables(array('id' => $opUserIdValue));
                 $operationIdValueDetail = -2;
                 $operationIdDetail = SysOperationTypes::getTypeIdToGoOperationId(array('parent_id' => 3, 'main_group' => 3, 'sub_grup_id' => 40, 'type_id' => 2));
                 if (\Utill\Dal\Helper::haveRecord($operationIdDetail)) {
                     $operationIdValueDetail = $operationIdDetail['resultSet'][0]['id'];
                 }
                 $sql = " \n                    INSERT INTO info_users_detail(\n                           profile_public,  \n                           operation_type_id,\n                           active,\n                           name,\n                           surname,\n                           auth_email,\n                           language_id,\n                           op_user_id,\n                           root_id,\n                           act_parent_id,\n                           auth_allow_id,\n                           password \n                            ) \n                           SELECT \n                                0 AS profile_public, \n                                " . intval($operationIdValueDetail) . " AS operation_type_id,\n                                " . intval($active) . " AS active, \n                                name, \n                                surname,\n                                auth_email,   \n                                language_id,   \n                                " . intval($opUserIdValue) . " AS op_user_id,\n                                a.root_id,\n                                a.act_parent_id,\n                                1,\n                                '" . $params['password'] . "' AS password\n                            FROM info_users_detail a\n                            WHERE root_id  =" . intval($opUserIdValue) . "                               \n                                AND active =1 AND deleted =0 and \n                                c_date = (SELECT MAX(c_date)  \n\t\t\t\t\t\tFROM info_users_detail WHERE root_id =a.root_id\n\t\t\t\t\t\tAND active =1 AND deleted =0)  \n                    ";
                 $statementActInsert = $pdo->prepare($sql);
                 //  echo debugPDO($sql, $params);
                 $insertAct = $statementActInsert->execute();
                 $affectedRows = $statementActInsert->rowCount();
                 $insertID = $pdo->lastInsertId('info_users_detail_id_seq');
                 $errorInfo = $statementActInsert->errorInfo();
                 if ($errorInfo[0] != "00000" && $errorInfo[1] != NULL && $errorInfo[2] != NULL) {
                     throw new \PDOException($errorInfo[0]);
                 }
                 /*
                  * ufak bir trik var. 
                  * işlem update oldugunda update işlemini yapan kişinin dil bilgisini kullanıcaz. 
                  * ancak delete işlemi oldugunda delete işlemini yapan user in dil bilgisini değil 
                  * silinen kaydı yapan kişinin dil bilgisini alıcaz.
                  */
                 $consIdAndLanguageId = SysOperationTypes::getConsIdAndLanguageId(array('table_name' => 'info_users_detail', 'id' => $insertID));
                 if (\Utill\Dal\Helper::haveRecord($consIdAndLanguageId)) {
                     $ConsultantId = $consIdAndLanguageId['resultSet'][0]['consultant_id'];
                     // $languageIdValue = $consIdAndLanguageId ['resultSet'][0]['language_id'];
                 }
                 $xjobs = ActProcessConfirm::insert(array('op_user_id' => intval($opUserIdValue), 'operation_type_id' => intval($operationIdValue), 'table_column_id' => intval($insertID), 'cons_id' => intval($ConsultantId), 'preferred_language_id' => 647));
                 if ($xjobs['errorInfo'][0] != "00000" && $xjobs['errorInfo'][1] != NULL && $xjobs['errorInfo'][2] != NULL) {
                     throw new \PDOException($xjobs['errorInfo']);
                 }
                 $pdo->commit();
                 return array("found" => true, "errorInfo" => $errorInfo, "affectedRowsCount" => $affectedRows);
             } else {
                 $errorInfo = '23502';
                 /// 23502 user_id not_null_violation
                 $errorInfoColumn = 'key';
                 $pdo->rollback();
                 return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
             }
         } else {
             $errorInfo = '23502';
             /// 23502 user_id not_null_violation
             $errorInfoColumn = 'pk';
             $pdo->rollback();
             return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
         }
     } catch (\PDOException $e) {
         $pdo->rollback();
         return array("found" => false, "errorInfo" => $e->getMessage());
     }
 }
 /**
  * @author Okan CIRAN
  * @ info_firm_profile tablosuna yeni bir kayıt oluşturur.  !!
  * @version v 1.0  06.01.2016
  * @param array | null $args
  * @return array
  * @throws \PDOException
  */
 public function insertTemp($params = array())
 {
     try {
         $pdo = $this->slimApp->getServiceManager()->get('pgConnectFactory');
         $pdo->beginTransaction();
         $opUserId = InfoUsers::getUserIdTemp(array('pktemp' => $params['pktemp']));
         if (\Utill\Dal\Helper::haveRecord($opUserId)) {
             $opUserIdValue = $opUserId['resultSet'][0]['user_id'];
             $kontrol = $this->haveRecords($params);
             if (!\Utill\Dal\Helper::haveRecord($kontrol)) {
                 $operationIdValue = -1;
                 $operationId = SysOperationTypes::getTypeIdToGoOperationId(array('parent_id' => 3, 'main_group' => 3, 'sub_grup_id' => 23, 'type_id' => 1));
                 if (\Utill\Dal\Helper::haveRecord($operationId)) {
                     $operationIdValue = $operationId['resultSet'][0]['id'];
                 }
                 $ConsultantId = 1001;
                 $getConsultant = SysOsbConsultants::getConsultantIdForTableName(array('table_name' => 'info_firm_profile', 'operation_type_id' => $operationIdValue));
                 if (\Utill\Dal\Helper::haveRecord($getConsultant)) {
                     $ConsultantId = $getConsultant['resultSet'][0]['consultant_id'];
                 }
                 $foundationYearx = NULL;
                 if (isset($params['foundation_yearx']) && $params['foundation_yearx'] != "") {
                     $foundationYearx = $params['foundation_yearx'];
                 }
                 //to_timestamp(1451599200 )
                 $languageId = NULL;
                 $languageIdValue = 647;
                 if (isset($params['language_code']) && $params['language_code'] != "") {
                     $languageId = SysLanguage::getLanguageId(array('language_code' => $params['language_code']));
                     if (\Utill\Dal\Helper::haveRecord($languageId)) {
                         $languageIdValue = $languageId['resultSet'][0]['id'];
                     }
                 }
                 $sql = " \n                   INSERT INTO info_firm_profile(\n                        profile_public, \n                        country_id,                    \n                        firm_name, \n                        web_address, \n                        tax_office, \n                        tax_no, \n                        sgk_sicil_no, \n                        ownership_status_id,                         \n                        language_code, \n                        language_id,\n                        op_user_id, \n                        consultant_id,\n                        operation_type_id,                      \n                        foundation_yearx, \n                        firm_name_short,\n                        act_parent_id,                      \n                        description,\n                        description_eng,\n                        duns_number,\n                        logo\n                        )\n                VALUES (\n                        " . intval($params['profile_public']) . ", \n                        " . intval($params['country_id']) . ",\n                        :firm_name, \n                        :web_address, \n                        :tax_office, \n                        :tax_no,\n                        :sgk_sicil_no, \n                        " . intval($params['ownership_status_id']) . ",\n                        :language_code,  \n                        " . intval($languageIdValue) . ",\n                        " . intval($opUserIdValue) . ",\n                        " . intval($ConsultantId) . ",\n                        " . intval($operationIdValue) . ",\n                        " . intval($foundationYearx) . " ,\n                        :firm_name_short,\n                        (SELECT last_value FROM info_firm_profile_id_seq),\n                        :description,\n                        :description_eng,\n                        :duns_number,\n                        :logo\n                                            )    ";
                 $statementInsert = $pdo->prepare($sql);
                 $statementInsert->bindValue(':firm_name', $params['firm_name'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':web_address', $params['web_address'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':tax_office', $params['tax_office'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':tax_no', $params['tax_no'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':sgk_sicil_no', $params['sgk_sicil_no'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':language_code', $params['language_code'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':firm_name_short', $params['firm_name_short'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':description', $params['description'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':description_eng', $params['description_eng'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':duns_number', $params['duns_number'], \PDO::PARAM_STR);
                 $statementInsert->bindValue(':logo', $params['logo'], \PDO::PARAM_STR);
                 // echo debugPDO($sql, $params);
                 $result = $statementInsert->execute();
                 $insertID = $pdo->lastInsertId('info_firm_profile_id_seq');
                 $errorInfo = $statementInsert->errorInfo();
                 if ($errorInfo[0] != "00000" && $errorInfo[1] != NULL && $errorInfo[2] != NULL) {
                     throw new \PDOException($errorInfo[0]);
                 }
                 InfoFirmKeys::insert(array('firm_id' => $insertID, 'country_id' => $params['country_id']));
                 $this->insertCompanyUser(array('firm_id' => $insertID, 'language_id' => $languageIdValue, 'consultant_id' => $ConsultantId, 'user_id' => $opUserIdValue, 'op_user_id' => $opUserIdValue));
                 $pdo->commit();
                 return array("found" => true, "errorInfo" => $errorInfo, "lastInsertId" => $insertID);
             } else {
                 $errorInfo = '23505';
                 // 23505  unique_violation
                 $errorInfoColumn = 'firm_name';
                 $pdo->rollback();
                 return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
             }
         } else {
             $errorInfo = '23502';
             // 23502  not_null_violation
             $errorInfoColumn = 'pk';
             $pdo->rollback();
             return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
         }
     } catch (\PDOException $e) {
         $pdo->rollback();
         return array("found" => false, "errorInfo" => $e->getMessage());
     }
 }
 /**
  * @author Okan CIRAN     
  * @ info_users_addresses tablosundan parametre olarak  gelen id kaydın active alanını 1 yapar ve 
  * yeni yeni kayıt oluşturarak deleted ve active = 1 olarak  yeni kayıt yapar. ! 
  * @version v 1.0  02.02.2016
  * @param array | null $args
  * @return array
  * @throws \PDOException
  */
 public function deletedActTemp($params = array())
 {
     try {
         $pdo = $this->slimApp->getServiceManager()->get('pgConnectFactory');
         $pdo->beginTransaction();
         $userId = InfoUsers::getUserIdTemp(array('pktemp' => $params['pktemp']));
         if (\Utill\Dal\Helper::haveRecord($userId)) {
             $userIdValue = $userId['resultSet'][0]['user_id'];
             $operationIdValue = -3;
             $operationId = SysOperationTypes::getTypeIdToGoOperationId(array('parent_id' => 3, 'main_group' => 3, 'sub_grup_id' => 38, 'type_id' => 3));
             if (\Utill\Dal\Helper::haveRecord($operationId)) {
                 $operationIdValue = $operationId['resultSet'][0]['id'];
             }
             $this->makePassive(array('id' => $params['id']));
             $statementInsert = $pdo->prepare(" \n                    INSERT INTO info_users_addresses (\n                        user_id,                        \n                        active, \n                        deleted,\n                        op_user_id,                        \n                        operation_type_id,\n                        act_parent_id,  \n                        language_id,\n                        address_type_id, \n                        address1, \n                        address2, \n                        postal_code, \n                        country_id, \n                        city_id, \n                        borough_id, \n                        city_name, \n                        description, \n                        description_eng,\n                        profile_public,\n                        consultant_id,                        \n                        language_parent_id,                        \n                        consultant_id, \n                        act_parent_id\n                        )    \n                        \n                    SELECT\n                        user_id,\n                        1 AS active,  \n                        1 AS deleted, \n                        " . intval($userIdValue) . " AS op_user_id,                    \n                        " . intval($operationIdValue) . ",\n                        act_parent_id, \n                        language_id,\n                        address_type_id, \n                        address1, \n                        address2, \n                        postal_code, \n                        country_id, \n                        city_id, \n                        borough_id, \n                        city_name, \n                        description, \n                        description_eng,\n                        profile_public,\n                        confirm_id,                        \n                        language_parent_id ,                        \n                        consultant_id,                        \n                        act_parent_id\n                    FROM info_users_addresses \n                    WHERE id  =" . intval($params['id']) . "    \n                    )");
             $insertAct = $statementInsert->execute();
             $affectedRows = $statementInsert->rowCount();
             $errorInfo = $statementInsert->errorInfo();
             if ($errorInfo[0] != "00000" && $errorInfo[1] != NULL && $errorInfo[2] != NULL) {
                 throw new \PDOException($errorInfo[0]);
             }
             $pdo->commit();
             return array("found" => true, "errorInfo" => $errorInfo, "affectedRowsCount" => $affectedRows);
         } else {
             $errorInfo = '23502';
             /// 23502  not_null_violation
             $errorInfoColumn = 'pk / op_user_id';
             $pdo->rollback();
             return array("found" => false, "errorInfo" => $errorInfo, "resultSet" => '', "errorInfoColumn" => $errorInfoColumn);
         }
     } catch (\PDOException $e) {
         $pdo->rollback();
         return array("found" => false, "errorInfo" => $e->getMessage());
     }
 }