+
-
";
}
-
- function generate() {
- $start = $_REQUEST['start'];
+
+ public function generate()
+ {
+ $start = $_REQUEST['start'];
$nr_cards = $_REQUEST['nr_cards'];
$digits = $_REQUEST['digits'];
$batch = $_REQUEST['batch'];
$value = $_REQUEST['value'];
if ($this->CDRTool['filter']['reseller']) {
- $reseller=$this->CDRTool['filter']['reseller'];
+ $reseller = $this->CDRTool['filter']['reseller'];
} else {
- $reseller = $_REQUEST['reseller'];
+ $reseller = $_REQUEST['reseller'];
}
if (!$digits) {
print "
Error: No digits specified!";
return 0;
}
- $card_len=$digits;
+ $card_len = $digits;
if (!$nr_cards) $nr_cards = 10;
if (!$value) $value = 10;
-
- $alf=array("0","1","2","3","4","5","6","7","8","9");
+
+ $alf = array("0","1","2","3","4","5","6","7","8","9");
print "
";
- printf ("Request generation of %d cards or %d digits in value of %s",$nr_cards,$card_len,$value);
-
+ printf("Request generation of %d cards or %d digits in value of %s", $nr_cards, $card_len, $value);
+
$now = date("Y-m-d_H:i:s");
if (!$batch) {
$batch_name=$now."-cards_".$nr_cards."-value_".$value;
} else {
$batch_name=$now."-".$batch."-cards_".$nr_cards."-value_".$value;
}
- $generated = 0;
- $failed = 0;
- $j = 0;
- $random_len = $card_len-strlen($start);
- $initial_len = strlen($start);
+ $generated = 0;
+ $failed = 0;
+ $j = 0;
+ $random_len = $card_len-strlen($start);
+ $initial_len = strlen($start);
while ($generated < $nr_cards) {
$j++;
if ($j > 5 * $nr_cards) {
print "Error: could not generate $nr_cards unique random cards";
break;
}
- $card=$start;
- $i=0;
+ $card = $start;
+ $i = 0;
- while($i < $random_len) {
+ while ($i < $random_len) {
srand((double)microtime()*1000000);
if ($i==0) {
- $randval = rand(1,9);
+ $randval = rand(1, 9);
} else {
- $randval = rand(0,9);
+ $randval = rand(0, 9);
}
$card=$card.$alf[$randval];
$i++;
}
- $query=sprintf("insert into prepaid_cards
- (number,value,date_batch,batch,service,reseller_id)
- values ('%s','%s',NOW(),'%s','sip',%d)",
-
- addslashes($card),
- addslashes($value),
- addslashes($batch_name),
- intval($reseller)
+ $query = sprintf(
+ "
+ insert into prepaid_cards (number,value,date_batch,batch,service,reseller_id)
+ values (
+ '%s',
+ '%s',
+ NOW(),
+ '%s',
+ 'sip',
+ %d)
+ ",
+ addslashes($card),
+ addslashes($value),
+ addslashes($batch_name),
+ intval($reseller)
);
- dprint($query);
+ dprint_sql($query);
if ($this->db->query($query) && $this->db->affected_rows()) {
- $generated++;
+ $generated++;
} else {
$failed++;
}
}
if ($generated) {
print "
Generated $generated cards";
- $log_query=sprintf("insert into log
- (date,login,ip,datasource,results,description,reseller_id)
- values
- (NOW(),'%s','%s','Prepaid generator','%d','Batch %s created',%d)",
- addslashes($this->loginname),
- addslashes($_SERVER['REMOTE_ADDR']),
- addslashes($generated),
- addslashes($batch_name),
- intval($reseller)
+ $log_query = sprintf(
+ "
+ insert into log (date,login,ip,datasource,results,description,reseller_id)
+ values (
+ NOW(),
+ '%s',
+ '%s',
+ 'Prepaid generator',
+ '%d',
+ 'Batch %s created',
+ %d
+ )
+ ",
+ addslashes($this->loginname),
+ addslashes($_SERVER['REMOTE_ADDR']),
+ addslashes($generated),
+ addslashes($batch_name),
+ intval($reseller)
);
-
- dprint($log_query);
+
+ dprint_sql($log_query);
$this->db->query($log_query);
}
}
- function export($batch) {
-
+ public function export($batch)
+ {
if (!$batch) return false;
- $available = $_REQUEST['available'];
+ $available = $_REQUEST['available'];
- $query = sprintf("select * from prepaid_cards where batch = '%s' and %s",addslashes($batch),$this->whereResellerFilter);
+ $query = sprintf("select * from prepaid_cards where batch = '%s' and %s", addslashes($batch), $this->whereResellerFilter);
if ($available == "yes") {
$query .= " and value > 0";
$query .= " order by id ASC ";
-
} elseif ($available == "no") {
$query .= " and value = 0";
$query .= " order by date_active DESC ";
}
dprint($query);
print "Id,Number,Batch,Value\n";
$this->db->query($query);
- $rows= $this->db->num_rows();
+ $rows = $this->db->num_rows();
while ($this->db->next_record()) {
$i++;
$id = $this->db->f('id');
$batch = $this->db->f('batch');
$number = $this->db->f('number');
$value = $this->db->f('value');
$date_active = $this->db->f('date_active');
print "$id,$number,$batch,$value\n";
}
- $log_query=sprintf("insert into log
- (date,login,ip,datasource,results,description,reseller_id)
- values
- (NOW(),'%s','%s','Prepaid generator','%d','Batch %s exported',%d)",
- addslashes($this->loginname),
- addslashes($_SERVER['REMOTE_ADDR']),
- addslashes($rows),
- addslashes($batch),
- $this->CDRTool['filter']['reseller']
+ $log_query = sprintf(
+ "
+ insert into log (date,login,ip,datasource,results,description,reseller_id)
+ values (
+ NOW(),
+ '%s',
+ '%s',
+ 'Prepaid generator',
+ '%d',
+ 'Batch %s exported',%d
+ )
+ ",
+ addslashes($this->loginname),
+ addslashes($_SERVER['REMOTE_ADDR']),
+ addslashes($rows),
+ addslashes($batch),
+ $this->CDRTool['filter']['reseller']
);
- dprint($log_query);
+ dprint_sql($log_query);
$this->db->query($log_query);
+ }
- }
-
- function deleteBatch($batch, $confirm) {
-
+ public function deleteBatch($batch, $confirm)
+ {
if (!$batch) return false;
if (!$confirm) {
- $batch_enc=urlencode($batch);
+ $batch_enc = urlencode($batch);
print "
PHP_SELF?batch=$batch_enc&action=delete&confirm=1>Confirm deletion of batch $batch
";
return;
}
- $query=sprintf("delete from prepaid_cards where batch = '%s' and %s",addslashes($batch),$this->whereResellerFilter);
+ $query = sprintf("delete from prepaid_cards where batch = '%s' and %s", addslashes($batch), $this->whereResellerFilter);
$this->db->query($query);
if ($this->db->affected_rows()) {
- $log_query=sprintf("insert into log
- (date,login,ip,datasource,results,description,reseller_id)
- values
- (NOW(),'%s','%s','Prepaid generator','%d','Batch %s deleted',%d)",
- addslashes($this->loginname),
- addslashes($_SERVER['REMOTE_ADDR']),
- addslashes($this->db->affected_rows()),
- addslashes($batch),
- $this->CDRTool['filter']['reseller']
+ $log_query = sprintf(
+ "
+ insert into log (date,login,ip,datasource,results,description,reseller_id)
+ values (
+ NOW(),
+ '%s',
+ '%s',
+ 'Prepaid generator',
+ '%d',
+ 'Batch %s deleted',%d
+ )
+ ",
+ addslashes($this->loginname),
+ addslashes($_SERVER['REMOTE_ADDR']),
+ addslashes($this->db->affected_rows()),
+ addslashes($batch),
+ $this->CDRTool['filter']['reseller']
);
-
- dprint($log_query);
+
+ dprint_sql($log_query);
$this->db->query($log_query);
return true;
-
}
-
return false;
}
- function blockBatch($batch) {
-
+ public function blockBatch($batch)
+ {
if (!$batch) return false;
- $query=sprintf("update prepaid_cards set blocked = '1' where batch = '%s' and %s",addslashes($batch),$this->whereResellerFilter);
+ $query = sprintf("update prepaid_cards set blocked = '1' where batch = '%s' and %s", addslashes($batch), $this->whereResellerFilter);
$this->db->query($query);
}
- function deblockBatch($batch) {
-
+ public function deblockBatch($batch)
+ {
if (!$batch) return false;
- $query=sprintf("update prepaid_cards set blocked = '0' where batch = '%s' and %s",addslashes($batch),$this->whereResellerFilter);
+ $query = sprintf("update prepaid_cards set blocked = '0' where batch = '%s' and %s", addslashes($batch), $this->whereResellerFilter);
$this->db->query($query);
}
- function showBatches () {
-
- $query=sprintf("select count(*) as c,batch,reseller_id,date_batch
- from prepaid_cards
- where %s
- group by batch
- order by date_batch DESC",$this->whereResellerFilter);
- dprint($query);
+ public function showBatches()
+ {
+ $query = sprintf(
+ "
+ select count(*) as c,batch,reseller_id,date_batch from prepaid_cards
+ where %s group by batch order by date_batch DESC
+ ",
+ $this->whereResellerFilter
+ );
+ dprint_sql($query);
$this->db->query($query);
print "
";
}
}
-
-?>