Is there a way to manually assign envelopes? Say for instance, John Doe has envelope 347. We are converting to OSC now so can I just make John, envelope 347 instead of automatically numbering him as the next incremental number?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is no way to do this currently within OSC. I would recommend you assign the envelopes. Then go into MySQL and adjust the envelope numbers as you need.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just created a page that prompts for your highest envelope number. Then it inserts that number+1 into the admin account record. I added the page to the menu system. When you go to choose an envelope, all the unused ones will be listed in the drop down.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
<?php
/*******************************************************************************
*
* filename : SetEnvHolder.php
* last change : 01/12/2005
* description : Page to get around annoying select envelop option.
* Use to set user ZEnvelopePlaceHolder to a high value
*
* http://www.infocentral.org/
* Copyright 2003 David L Smith Jr.
*
* InfoCentral is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
******************************************************************************/
// Include the function library
require "Include/Config.php";
require "Include/Functions.php";
// Security: user must be administrator to use this page
if (!$_SESSION['bAdmin'])
{
Redirect("Menu.php");
exit;
}
// Set the page title and include HTML header
$sPageTitle = "Set the top envelope number";
require "Include/Header.php";
?>
<html>
<body>
<?php
if (isset($_POST[envelope])) {
// process form
$envend = ++$_POST[envelope];
$sSQL = "update person_per set per_Envelope=$envend where per_LastName='Admin'";
$result = mysql_Query($sSQL);
echo "Your last envelop number has been set to ";
echo --$_POST[envelope];
} else{
// display form
?>
<p>Use this page to set the last envelope number.</p>
Is there a way to manually assign envelopes? Say for instance, John Doe has envelope 347. We are converting to OSC now so can I just make John, envelope 347 instead of automatically numbering him as the next incremental number?
There is no way to do this currently within OSC. I would recommend you assign the envelopes. Then go into MySQL and adjust the envelope numbers as you need.
I just created a page that prompts for your highest envelope number. Then it inserts that number+1 into the admin account record. I added the page to the menu system. When you go to choose an envelope, all the unused ones will be listed in the drop down.
Thanks dlsmithjr.
Can you post the page to this forum and I'll make sure it gets to CVS and the next release.
Thank you.
<?php
/*******************************************************************************
*
* filename : SetEnvHolder.php
* last change : 01/12/2005
* description : Page to get around annoying select envelop option.
* Use to set user ZEnvelopePlaceHolder to a high value
*
* http://www.infocentral.org/
* Copyright 2003 David L Smith Jr.
*
* InfoCentral is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
******************************************************************************/
// Include the function library
require "Include/Config.php";
require "Include/Functions.php";
// Security: user must be administrator to use this page
if (!$_SESSION['bAdmin'])
{
Redirect("Menu.php");
exit;
}
// Set the page title and include HTML header
$sPageTitle = "Set the top envelope number";
require "Include/Header.php";
?>
<html>
<body>
<?php
if (isset($_POST[envelope])) {
// process form
$envend = ++$_POST[envelope];
$sSQL = "update person_per set per_Envelope=$envend where per_LastName='Admin'";
$result = mysql_Query($sSQL);
echo "Your last envelop number has been set to ";
echo --$_POST[envelope];
} else{
// display form
?>
<p>Use this page to set the last envelope number.</p>
<form action="<?php echo $_SERVER[PHP_SELF]; ?>" method="post" >
<P><strong>Last Envelope:</strong><INPUT type="text" name="envelope"></p>
<p><INPUT type="Submit" name="submit" value="Enter last Envelope number"></p>
</FORM
<?php
} // end if
?>
</body>
</html>
<?php
require "Include/Footer.php";
?>