CiviCRM Community Forums (archive)

When someone fill an online form for a non-monetary contribution the status by default is set to "Completed". I need to change the non-monetary contributions to "Pending" using a post hook (as suggested by Kurund).

I have used simple hooks before but I need a little guidance about getting the table information (civicrm_contribution table) into the query and updating the contribution_status_id to 1


function joomla_civicrm_post( $op, $objectName, $objectId, &$objectRef ) {

if ( $objectName == 'Contribution' && $op == 'create' ) {

// this is the contribution page we are interested
if ( $objectRef->contribution_page_id != 2) {
        return;
    }


    $tableName = CRM_Core_DAO::getFieldValue( 'CRM_Contribute_DAO_Contribution',
                                              $objectRef,
                                              'table_name' );
   

$sql = "UPDATE $tableName SET contribution_status_id = 1 WHERE entity_id = $objectId";
        CRM_Core_DAO::executeQuery( $sql, CRM_Core_DAO::$_nullArray);
}
}

Thanks in advance for any pointers.

Thanks Lobo... Got an error with the entity_id.   
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => UPDATE civicrm_contribution SET contribution_status_id = 1 WHERE entity_id = 86 [nativecode=1054 ** Unknown column 'entity_id' in 'where clause']
    [type] => DB_Error
    [user_info] => UPDATE civicrm_contribution SET contribution_status_id = 1 WHERE entity_id = 86 [nativecode=1054 ** Unknown column 'entity_id' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_contribution SET contribution_status_id = 1 WHERE entity_id = 86 [nativecode=1054 ** Unknown column 'entity_id' in 'where clause']"]
)

[/code]

Like always thank you Lobo... it worked! 

I also realized that I needed to change the status to pending is 2 (SET contribution_status_id = 2) just in case someone out there is doing the same.